Recent Discussions
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:
Issue in Web Content and File Viewer component to directly open a HTML file in a browser
Dear community, I currently have an html document which is located in the file Explorer under "Documents/Public" folder. I am trying to get this HTML document to be presented into the components, embedded in a dashboard. However, with either a Web Content component or a File Viewer component (which will pinpoint to this specific file in Application Database File, as soon as I open the dashboard, it will load the html page into my default browser... I am using OS v8.1 ... is it a known bug or the expected behaviour ? What is even more strange, directing the Full File Name to a URL will correctly open a document in a dashboard ... Regards,
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!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!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
Report (PDF) Header Background Fill Color Not Extending to Bottom of the Space
The background fill color on the header is not filling the entire space when viewed in PDF. You can see on four of the six columns there is white space where the text is shorter. I need the teal color to fill to the bottom of the header space, and not just exist where the text is located. It works fine in excel and cube view. The issue only exists in report PDFs. Does anyone know of a way to accomplish this? Report/PDF: Excel: Cube View: Here's an example of a PDF that looks good because the length of the header text is more comparable across the columns: I'm sure there's a way to accomplish this through a Custom Report Formatting rule or formula. I'm trying to avoid this, as I feel the formatting should already default to what I want. But, if I have to go this route, I will. Thanks in advance!CVR and GetDataCell Issue in cube views
Hello, I currently have a cube where I am having an issue calculating variances. The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12). When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell. I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?Saving Offline Copy
My team has recently been unable to save offline copies of Excel files that contain XFGetCells + CubeViews. Prior to this, we had no issues and had saved 100+ files offline as part of quarterly reporting. I have seen prior threads where this has been discussed some time ago, and our team has tried updating preferences, saved elsewhere, etc. with no luck. Is anyone else currently having this issue?
