Hello everyone,
Hopefully someone might help . i am trying to create a cube view that will display GL Accounts having specific FLOW criteria . on the rows the i have GL and the columns contain the FLOWS. i have multiple flows configured but each GL has one FLOW. how can i display the Flow constraint that is configured on the GL account ?
It sounds like you are constraining the Accounts by Flow and if I understand correctly you want to display the member in the Flow dimension by which the Account is constrained?
So this member...
If so you can use the following as string substitution:
XFMemberProperty(DimType=Account, Member=[YourAccount], Property=FlowConstraint)
Hello Lee, thank you for the prompt reply,
i tried this
A#M_BS.base .Where(XFMemberProperty(DimType=Account, Member=:A#M_BS.base,Property=FlowConstraint)="FLOW_EQU")
it gave an error, what i am trying to do basicly is just display GL accounts with FlowConstraint= FLOW_EQU by using the BS . rather then choosing the accounts one by one from the COA.
Would the function you sent help me achieve that? or is there another way.
