Forum Discussion

Jacky_C's avatar
Jacky_C
New Contributor III
2 years ago

Dynamic row header text based on another dimension in the member filter

Hi there, I am new to OneStream and would like to know is there any functionality to achieve below report output. I have two sections in my reports, the first section would be a header displaying w...
Cube View
  • Noemi's avatar
    Noemi
    2 years ago

    Hi Jacky,

    You can use row overrides in your column, in my example I have used two different accounts (you can have up to four using the overrides):

    I hope it helps.

Jacky_C's avatar
Jacky_C
New Contributor III

I see, thanks a lot. I am looking for situation that minimize the coding effort, so it would great if there is some examples of using override to produce the report layout. 

Noemi's avatar
Noemi
New Contributor III
2 years ago

Hi Jacky,

You can use row overrides in your column, in my example I have used two different accounts (you can have up to four using the overrides):

I hope it helps.

  • Jacky_C's avatar
    Jacky_C
    New Contributor III
    2 years ago

    Hi - thanks for your response and example, it will definitely help me with the report layout development. I just have one follow up question, may I know what the substitution variable is used so that the header is renamed as the overridden account (e.g., Employee Compensation and Sales in your screenshots).

    Thank you so much. 

    Jacky