OneStream Community

rjgoss

Does anyone know of a way to handle this situation while using a Line Item dimension on a cube view input form? Let's say the Line Item dimension has 20 members. Can you set a default number of Line Item rows to always show, say 10, but allow the use...

rjgoss · 06-09-2022

Is there any way to do a GetDataCell in a Cube View or Quick View where the members are dynamic/based on some criteria? The formula below doesn't work, but hopefully give you an idea of what I wish did work. GetDataCell(SUM(E#TopEntityMember.Base.Whe...

User Input Values for Quick Views · 04-29-2022

Has anyone come across a simple way to incorporate user input values with a Quick View? Our users very much prefer the Excel Add-In with Quick Views and tend not to like the predefined nature of cube views. This has been one of the main sources of fr...

rjgoss

If you come up with something more dynamic in v8+, I'd appreciate any more feedback. I've been trying it in v8+ and haven't come across anything with the suppression properties and something like this. Thanks again for your help.

rjgoss

The idea is there would always be 10 line items showing and the user would use the insert suppressed member functionality to add more line items (up to the number of members in the Line Item dimension). There isn't a trigger to add more other than th...

rjgoss

Thank you. I tried this and the process does work, but I was hoping for something more dynamic. Using the parameter approach for line items would become quite cumbersome. I appreciate your help as the idea does have merit.

rjgoss · 11-28-2023

Application=>Tools=>Load/Extract=>Extract=>Cube Views Find the one that is the issue and press the Extract button on top.

rjgoss · 11-27-2023

If it's popping up the selection box, the parameter is still being referenced somewhere. It can be anywhere, so make sure to check places you wouldn't think, such as report headers/footers, overrides, page caption, etc... If it's using shared cube vi...

OneStream Community

User Statistics

User Activity

Line Item Suppression on Planning Forms

GetDataCell in Cube View or Quick View with Dynamic Members

User Input Values for Quick Views

Re: Line Item Suppression on Planning Forms

Re: Line Item Suppression on Planning Forms

Re: Line Item Suppression on Planning Forms

Re: Old Parameter appearing in cubeview

Re: Old Parameter appearing in cubeview