Recent Discussions
ShowCurrency=True in excel export?
Hi, I can figure out how to solve problem with cell format in column ShowCurrency=True (in Cube View) to work in Excel export? Any ideas how to fix this? I want to have it both in Excel and PDF export. In Excel formatting I cannot see any settings that I can use. Maybe some kind of combination in ExcelNumberFormat that can be used? Currency is depended on accounts etc. Thanks for your help, Pia
Excel Add-in and Task Activity Log
Hello, I'm responding to audit requests regarding user task activities and found an active user which has no task activity logged. The user uses the Excel Add-in. What Excel activities are/aren't recorded on the Task Activity log? Is there a way to capture the Excel activities? Thanks!
Event Listeners / Custom Control in a Dynamic Dashboard
Hello, To standardize the look and feel of my dashboards, I would like to create a reusable dashboard template for a toolbar. The Menu component seems well suited for this purpose. However, some actions (for example, Save) cannot be defined at the menu item level and are only available at the menu component level. As a workaround, I am using Event Listeners: each menu item sends a parameter value, which is then used as the Event Listener name. This allows me to have one menu item that performs a Save action, another that launches a business rule, another that opens a dialog, etc. This approach works fine until the Custom Control dashboard is embedded in a Dynamic Dashboard. The issue can be easily reproduced by embedding the dashboards described in this blog post into a dynamic dashboard. Any help or guidance would be greatly appreciated. Thanks in advance.
MTD values in cube view
Hi all, my client is loading in OS Actual data in MTD. I set up a cube view to show the actuals MTD month by month. If the user loads the first 3 months, the cv correctly shows the MTD for the first 3 months, but for the 4th month it shows the YTD with inverted sign: If I understand correctly, this setup should be configurable by intervening on the following WF Profile settings: I also changed the following setting in the scenario configuration: nevertheless, the cv keeps showing the inverted YTD in the new month. Can anyone explain why? Thank you!Extract dbo.vStageSourceAndTargetDataWithAttributes data to csv or txt
Hi everyone, I need to add a button to a dashboard to allow users to export to csv or txt some data from the staging area, specifically from dbo.vStageSourceAndTargetDataWithAttributes I tried multiple approaches using a dashboard extender but cannot find the right way to do that. Has anyone done that before and has any suggestion or best practice to do it (even without using a BR)? Thank you for the help!Returning text from a BR# inside GetDataCell — possible?
I'm building a cube view column that shows combined annotations from descendants. I'm calling an Finance Cell Service BR from inside GetDataCell so I can pass dashboard params needed for the logic. GetDataCell(T#|CVTime|:BR#[BRName=..., FunctionName=CombinedComment, Flux_ID = {fluxID}]:U8#{ud8}):Name({ud8} Combined). I need to the UD8 POV member because that distinguishes what type of comment it is (CMvsPM, CQvsPQ, CMvsPYM, Ect...). The BR returns a String, but GetDataCell expects a numeric amount so the text doesn't render in the cell. Pointing the column at V#Annotation doesn't help either. Has anyone gotten BR-returned text to display in a GetDataCell with full POV/param context? Thanks, BenButton Parameter Not Resolving in 8.4.4
Our two environments are currently on different OneStream versions. DEV is on 9.1.1 and PROD is 8.4.4. We have an upgrade scheduled to get them in sync soon. However, currently facing a parameter resolving and passing issue while trying to migrate some functionality from DEV to PROD. All setups are now equal between the two applications for the workspace that I moved over to PROD. However, I believe version 8.4.4 is having some trouble resolving parameters being passed to a button click that I have on the same dashboard. I have a button whose "Selection Changed Server Task" is set to "Execute Data Management Sequence" and "Selection Changed Server Task Arguments" is set to "{FilteredForecastRollforward_ButtonRan}{SelectedContracts=[|!param_SelectContracts!|]}". Within 9.1.1 DEV this data management sequence runs no problem an receives the value of "Contract1" upon logging. However, in 8.4.4 PROD this parameter is not resolving properly and comes as "|!SelectedContracts!|" in the error log even though the setups are identical. Upon checking the 9.1.1 release notes I noticed that there was a fixed issue number "PF7-9772" under "Dashboard Components" that states "Button Component: The Button dashboard component respects the Selection Changed Server Task value, ensuring that Business Rules are run on the designated servers as configured. (PF7-9772)". Could that fix number be related to my problem? Does version 8.4.4 have a known issue with resolving these parameters. And if so, is there a workaround or do I need to wait until our upgrade for this to be resolved? Button: DM Sequence:
