The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

100Rub's avatar
100Rub
New Contributor III
2 years ago

Member Filter in Cube View

Hi all,

I have created cube view wherein I have used E#Test.Base in Member Filter 1  (Test have 2 children A and B). I need A and B in Member Filter 2 to act as param value in the Dashboard XFBR String. How can I achieve this ?

Thanks

 

Cube View

2 Replies

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    100Rub  - My Assumptions is that entity derive UD4. If so you get the entity parameter in XFBR and return UD4.

     

  • KarlT's avatar
    KarlT
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    Hi,

    If i'm understanding correctly that your U4 is dependant on the entity the you could trying combing this into a single XFBR in the entity which returns "E#entityA:U4#memA, E#entityB:U4#memB... etc."

    Then in you General Settings, under "Header Overrides" you can switch off default row headers and ensure Entity and U4 are both showing.

    Alternatively, if these are general "Default" values for each entity, then you can assign then to the "UD4 Default" setting on the entity member itself. They can then be referred in any cube view using "U4#EntityDefault". The cube view won't show the U4 name in the column however, instead showing "Entity Default", but if you drill down on the data you will see that it's the correct intersection. Check out the design and reference guide for more information on this feature.