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.

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

You can use an XFBR rule to use the account to lookup and return the cost centers associated with it.  

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

    Hi - thanks for your reply. For the XFBR rule, is it possible to return all cost centers in the hierarchy, we would like to display all cost centers regardless there is data or not.

    Thanks.

    Jacky