Recent Discussions
Disable dashboard for UX but run in desktop.
I have a dashboard that I want to run whenever I log into the desktop app, and it works just as expected, but it tries to run in the web browser UX and does not work right. How can I disable the dashboard from running in UX, but stay running for the desktop app?
Cube View Time Out issue
Hello Team, I'm experiencing performance challenges with a CubeView that contains: 4 row dimensions (all using .base members) Multiple time period columns Dynamic calculations that are causing significant retrieval delays Current Challenge: The CubeView needs to be executed and its data exported externally, but the dynamic calculations are making the retrieval process extremely time-consuming. Attempted Solution: I've already tried converting the dynamic calculations to stored values using finance rules, but this approach has proven ineffective - it's still taking excessive time and not producing the desired results. Request: Could you suggest any alternative approaches or optimization strategies to improve the performance of this data retrieval and export process? Thank you for your assistance.
XFGETCELL #REFRESH
Certain users aren't able to refresh sheet containing XFGETCELL. Only shows #REFRESH. In OneStream task activity, it shows that the task has failed with an error message "Summary: Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1." This should not be related to access since I was able to refresh sheet using another profile with the same roles.
Report Books - Dashboard Chart
Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews). I was able to add the chart, but I'm struggling with trying to control the formatting. I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?
Cube View sum of columns sums only values from column with first child
Hi everyone, I'm having an issue with a cube view. I have a column whose parameter is E#GroupEntity.Base. When launched, it shows one base entity per column, with its respective data. I need to place a new column at the end of the cube view that sums the values of all the base entities. I tried to use the CVC function to sum columns, but it only sums the data of first base entity, ignoring all the other base entities. Is there a way to achieve what I need, and if yes, could someone please help me? Thank you!
Bulk edit dashboard frames
Is there a method or tool that can edit dashboard frames (names) in bulk? I would like to create a base dashboard template that would include headers, content, and footers. This would be copied & pasted to separate maintenance units and then customized for each dashboard. Is there a way to bulk-edit dashboard frames, or assist with copying & pasting dashboards without renaming them one by one? The only way I know of now is extracting to an XML and changing the text through notepad.
Application Reports & Parcel Service
Hi all, We have an interest in being able to provide the Map Changes Audit Report (out of the standard Application Reports dashboard) to a group of users via the Parcel Service function. I've been able to narrow down the application report itself to an "RPT" component but not sure where to go from there. Has anyone out there managed to set this up and if so, would you mind providing a high level view of the steps involved? Thanks very much in advance, KimCube View Cash Flow Report QTD or MTD
Our cube view cash flow reports were built using an account hierarchy and includes parent cash flow accounts to rollup base accounts. The cash flow reports were originally built on a YTD basis. Later the view parameter was changed to also generate cash flow reports on a QTD or MTD basis. The QTD and MTD cash flow reports reflect the correct calculated movement of balance sheet accounts for the parent cash flow accounts, but still reflect YTD calculated movement for the base accounts. Any income statement accounts included in the cash flow reflect the correct YTD, QTD or MTD amounts for the parent cash flow and base accounts. OS Community - Does anyone have a similar cash flow report build including options to generate the report QTD or MTD and solved obtaining QTD or MTD balance sheet base account calculated movements?
