Implementation Q&A

Top Content

Question: Is it possible to loop through members within confirmation rules?

Answer Yes…see the attached Splash presentation which covers how to do this…

Can you give an example of the best way to sum a row from a cube view? For example, if I add two rows to a cube view, one with a selection of members, how do I make the second row a custom sum of the first? I know one way to do it, but I don’t love it, I would love to see what else you guys recommend.

Clarification – this is referring to using Cube View Row/Column math when members expansions are in use. Answer No “elegant” ways to address this currently – options are: Avoid using...

Is there a way to suppress a row in a cube view based on values in another row using conditional formatting?

Answer It is not possible to do this using conditional formatting. However, it IS possible using Cube View Extender rules.

Question: Is there a way to report the total of a group of members based on a text attribute with multiple dimensions in a row?

Question (cont) The example below is for an operating expense that I want to be filtered using a text property of “HP” (a specific business line). I thought the following would work, but it is ...

Top Content

Question: Is it possible to loop through members within confirmation rules?

Is there a way to suppress a row in a cube view based on values in another row using conditional formatting?

Question: Is there a way to report the total of a group of members based on a text attribute with multiple dimensions in a row?

Recent Content

In the Windows application, is there a way for the Zoom to default to what was last selected – each page has a different zoom setting and each session requires users to set the zoom again.

How do you clear elimination records for parent members that have been cleared/removed but cannot be deleted due to existing elimination data?

Question: Is there any security options to limit a user's ability to submit data using excel?

Question: Client wants to be able to input parent entity adjustments using forms rather than journals.

Question: Is it possible to filter the list of members returned in a parameter/drop-down box based on a user’s cube data cell (“slice”) security access?

Is there a way to use an XFBR to Column and Row overrides?

Question: In a Cube View heading, how can I include the last day of the month as the time description in a page caption (e.g., display "as at 30 September 2020" instead of "September 2020“)?

Is it possible to load multiple thing planning registers to meet different requirements and, if so, how?

Question: According to the Design and Reference Guide, it is possible to post adjustments using a form. How is this set up?

Question: How do you hide columns in a column view?

Are there any updates on merge and center on headers for cube views?

Is it possible to extract consolidated data, including Dynamic Calcs?

Is there a list of valid font families for Cube Views?

About Implementation Q&A

Tags

Featured Places

Upgrading to 8.0+

Technical Guides

QuickTips

OneStream Press Excerpts

Tech Talks

Certification