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
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...
Hi ZAH,
Sorry, you are on the right track... have you tried passing the argument of FlowConstraint?
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 .
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!
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.
Or another easy way could be to code it in a text field?
Can i find it somewhere? (BR Formula)i am still new to the OS world . no indentation is not needed . my cube will be for Data Entry purposes only
Hi,
Please try this in your cube view.
A#M_BS.Base.Where((XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=FlowConstraint) = EQU)
Let us know if this works.
