09-01-2022 08:35 AM - last edited on 05-24-2023 12:15 PM by JackLacava
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 ?
09-01-2022 02:27 PM
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)
09-02-2022 03:40 AM
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.