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

ZAH's avatar
ZAH
New Contributor
3 years ago

Member Constraints

Hello all .    i am trying to display in a cubeview a list of accounts with specific constraints related to FLow , for example i want to display Only accounts with having Flow = EQU . any idea wh...
Cube View
ZAH's avatar
ZAH
New Contributor
3 years ago

Hello Nicolas, 

i tried this: A#M_BS.Base:Name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=FlowConstraint)

it displays the flowconstraint for all BS accounts . i want to be able to select Accounts having EQU flow only . in sql it is very easy. but in OS i having difficulty finding the correct function to pass such a filter on .

NicolasArgente's avatar
NicolasArgente
Valued Contributor
3 years ago

It might be easier if you use an XFBR formula. Do you need the indentation in your cube view? as you will loose that by default in the XFBR!

  • OS_Pizza's avatar
    OS_Pizza
    Contributor III
    3 years ago

    NicolasArgente  I am using the below formulae to fetch members in a cube view.

    Account -> A#Root.CustomMemberList(BRName= abc,Param1=value1)

    The results from BR defaults the indentation to 0 instead of the indentation that is mentioned in the formatting tab.

    Do you know how we can change the indent level to 3 after the members get returned from BR.