Display Parameters of Embedded Cube View
OneStream Community, I am having difficulty applying visible parameters after embedding a Cube View in Excel. When I embed the Cube View and select "Use Display Value" the parameters appear but the parameter member list drop down is misaligned to the applicable parameter. Additionally, when the Cube View connection is removed and re-embedded without selecting "Use Display Value" on refresh the cube view shows an object reference error, but then after selecting ok the cube view will render with no issue. Has anyone come across this?
Round up cell value to integer for calculation
Hi All, I am trying to get a decimal value rounded up to integer for calculation (Not for display). The current cube view cell value is 0.75. I can make it displayed as 1. but, when I put it in GetDataCell function for division, it actually went back to use the value 0.75 to calculate the division. I tried using a dynamic calc with Math.ceiling function, not working. Please help. Thank you.
Try Not to Export Transparent Row to Excel
Hi All, in my dashboard, I have a row which I need to use value for a GetDataCell function in a different row. I made that row background and text all "Transparent" in report and Excel format. It is not showing in the dashboard, but it still got exported to Excel. What should I do so it won't be exported to Excel file? Please help. Thank you.
Cube Views - Nested Dimensions - Fill in all rows
Hi Everyone, I have received a request from the business regarding a cube view report where they wish all the rows to be populated with the dimension member. For example in the screenshot below, they would wish to see "Entity 1" populated for all the lines in the second column of Largest Clients. I am not sure if that is feasible unless someone has found a way. Thank you in advacne for your response. RegardsReport (PDF) Background Fill Color Not Extending to Bottom of the Space
Dear community, When opening a cube view in PDF, the row height isn't automatically equal to the row header height. As a result, the color in background within the cells isn't extended properly: A workaround is to set a row height, but the problem becomes when we have an header description that would be bigger. How do you handle this at your customers please? Thanks, FlorenceMonthly Breakdown and Annual Total in Cube View
I am creating a cube view. Currently, it is showing monthly view and annual total for Workflow year, but future years (2027 and 2028) are not showing annual total only. What should change to show both monthly breakdown and annual total for outer years (2027 and 2028)? T#|WFYear|.Months, T#|WFYear|, XFBR(Year_ParmSelect, SelectYearsRPT, YearsReport = |!ProcessYears!|, CurrScenario = |WFScenario|, wfYear= |WFYear|)MergeAndCenterColumnHeaders in Cube Views
Hi, Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views? We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view. There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks
