Skip to main content
Z
ZAH
Newcomer
September 1, 2022

Member Filter Flow Selection

  • September 1, 2022
  • 2 replies
  • 0 views

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 ? 

2 replies

L
LeeB
Contributor
September 1, 2022

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...

LeeBown_0-1662056781118.png

 

If so you can use the following as string substitution:

XFMemberProperty(DimType=Account, Member=[YourAccount], Property=FlowConstraint)

    Z
    ZAHAuthor
    Newcomer
    September 2, 2022

    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.

    Terms & ConditionsAccessibility statement