Dynamic Parameters in Dynamic Dashboards
Hi everyone, I'm curious if there is any information on how to use the dynamic parameters in the dynamic dashboard service. I've created a form is dynamically generated from a SQL query - essentially the query results contain the text I want to display next to the component, the type of component, the bound parameter for the component, etc. I also have a field for "list of values" that I'd like to use as the display and value items for the bound parameter for Combo Box components. Here's a screenshot of the table that holds this information: Right now when I generate the form, parameters bound to text boxes don't have to exist in the maintenance unit and I can use these parameters to collect data and save to a table I created on the database. For the combo box parameters, however, I currently have to create those in the maintenance unit. It feels like there should be a way I can fetch the display and value items based on my List of Values column for a dynamically generated parameter, but I'm not quite connecting the dots. Any information on this would be much appreciated!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, Ben
Button 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:
ABS function in GetDataCell formula
Hi all, We encountered an issue with the ABS function in a GetDataCell formula. Our cube view has two rows: the first tagged to account A#100, and the second with the formula GetDataCell(ABS(CVR(Row1))). The data displays correctly in the data explorer, but when using ‘Show Report’ or ‘Export to Excel,’ both rows show the absolute value of the original amount, which is not the expected output. An example is provided below Data explorer view (correct amount) Row Name Member Filter Output Row1 A#100 $ -1,000 ABS_Row1 GetDataCell(ABS(CVR(Row1)) $ 1,000 Show Report/Export to Excel view (incorrect amount) Row Name Member Filter Output Row1 A#100 $ 1,000 ABS_Row1 GetDataCell(ABS(CVR(Row1)) $ 1,000 Does anyone know whether this is an issue in OneStream? Thank you. Best, Jacky
OS Genesis CubeViewTreeView
Hi All, When opening a cube view via OS Genesis cube view tree view, the content block can take a while to open. Even though there is no data, it is a simple cube view PnL. Opening it via cube view or dashboard takes only 2 seconds with data. Is there a way to improve the performance of the cube view tree view content? Appreciate your help on this.
Bi-Viewer - Title and Legend
Bi-viewer appears to be limited on font size and type in version 8.5. So, what I've done is created anpng file through paint and chose the Load option in my Title in my bi-viewer to work around the original legend that is too small. What this allows me to do is have the font whatever size I want and I can make my legend line up with my bar chart. Looks beautiful on the client, but as always, the browser requires something "special". Is there anyway that I can use this thought pattern to make it appear on the browser. The Load function only looks at my cdrive which will not work on the browser. I tried uploading it to Data Explorer to get it on Onestream and then using that url in my image, then attaching my image to the same dashboard where my bi-viewer runs but it doesn't embed it into my chart so browser doesn't like that either. Regardkess if what I try, I just get the picture icon where my Title should be. Any ideas? ....even if it's something I've not mentioned here? Thanks ahead of time.
