OneStream Community

db_pdx · 03-20-2024

Hi folks: I am searching for suggestions to improve reporting performance in dashboards. We have a couple of simple, executive dashboards that consist of 5-10 tabs of cube views. These work great for managing a common set of reports for end users. Pa...

db_pdx · 03-16-2023

Hi all: I would like to reference the Cube View name in a Business Rule as part of the Cube View structure. My current assessment is that this is not possible but thought I would check with the community to see if I've missed anything. The goal is to...

db_pdx · 12-03-2021

Hello: Looking for guidance on how to implement an enhanced conditional formatting check. It's quite simple, apply some formatting based on the account type. Consider the example of a single row CubeView with one account as the member filter: A#A8799...

db_pdx · 12-01-2021

Hi all: Looking for advice on how to implement multiple parameters in a report book. The standard loop functionality does not meet current needs. Our reporting requires a user to specify 3 UD's to report out their area of responsibility. Each user wi...

db_pdx

Hi pranav46: do you mean the member names and descriptions? Check your Cube View settings under:General Settings > Header Text > (your dimension)If you mean overriding the text while still displaying some portion of the member use the :Name() functio...

db_pdx

Hi MeganN: you're on the right track, but need to use a slightly different conditional formatting. If (ColE2HeaderDisplayText = 'Variance B/W') AND ((CellAmount > 4000000) OR (CellAmount < -4000000)) ThenBackgroundColor = PinkEnd If If we focus on th...

db_pdx

Hi STDN1610: what you've listed sounds correct "...primary dimension type as entity and nested member expansion... as UD2" Can you share what your member expansion currently looks like? Else, a generic parameter example would be: E#|!YourEntityParame...

db_pdx

I'm interpretting that your BR is generating a (complex) member expansion (as a string), correct? If so, you should be able to use regular MF variables. For example, your Cube View Column would be: |!YourParameterThatResolvesXFBRString!|:Name(|MFTime...

db_pdx · 08-14-2024

"Using XF Functions how can I display the Currency label i.e. AUD?" You can't. You could: 1) Use regular 'ole Excel functionality and put the "AUD" into a cell and then link to it; effectively creating a mock dimension header that indicates what curr...

OneStream Community

User Statistics

User Activity

Cache dashboard results to improve performance when switching tab?

Referencing the Cube View Name in a BR as part of the Cube View Structure?

How to pass standard formatting conditionals to an XFBR rule?

How to run multiple parameters per Loop in a Report Book?

Re: Display Text & Member Description value in Cubview without creating UD8 member

Re: Cube View - Multiple Columns per Entity

Re: How to get two different dimension members in columns changing alternatively based on two parame

Re: How to name a CV column member in business rule

Re: Auto Translation Currencies and displaying the translation currency In Excel