Filter Member by properties via Member Selector in EPM 10

[Former Member]

Hi Gurus,

I need a help about filter member by properties in member selector window. I want to restrict members automatically. For reducing incorrect inputs, when users choose A dimension's member, system have to restrict B dimension's member with A property automatically. Is there anyway to solve this issue?

Best regards

Haşim

[Former Member · Accepted solution]

Hi,

This cannot be done using the member selector. You need to use the dimensionoverride function for this.

In cell A1, use the context function to get the context member of the A dimension.

In the cell A2, use the dimensionoverrride function using the correct property value.

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan,

I know contex and override formulas,and I used these formulas on cost element in same input schdule but I need how can I restrict the members  in the member selector for costcenter using business area property.

Does anyone hear or see something like that?

Best regards

Haşim

[Former Member · Accepted solution]

Hi,

Is Business Area a separate dimension? If yes, then you can use the context function on cost center dimension also. The user can double click to open the member selector of the cost center dimension and the filtered members will be visible.

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan,

Thank you for very fast answer

Business Area is both dimension and property of cost center. But I can't understand how I filter on the member selector automatically.

Can you explain again?

BG Haşim.

[Former Member · Accepted solution]

Hi,

If you look at the context function, there is a parameter for filter. That filter should be maintained as the context of the business area dimension.

Lets say the property in the cost center dimension is BA, then in one of the cells, write the below formula:

=EPMContextMember(,"Cost Center", "BA=EPMContextMember(,"Business Area"))

Now, if you double click on this cell, the member selector will open and the associated filter will be applied automatically.

Hope this helps.

[Former Member · Accepted solution]

Thank You Nilanjan,

It works very well, thanks a lot again

[former_member266029 · Accepted solution]

Hello:

Im using this formula and its not working.

DimensionA = CUENTA

DimensionB= MATERIAL

PropertyB=GRUPO

=EPMContextMember(,"MATERIAL","GRUPO=EPMContextMember(,"CUENTA"))

This message appears and correct my formula.

I think there is a bug, i tried a lot of times and it doesn´t work.

Please help.

Luciana

[Former Member · Accepted solution]

Old post but I think you need concatenation for your EPMContextMember:

=EPMContextMember(,"MATERIAL","GRUPO="&EPMContextMember(,"CUENTA"))

[JohnL]

Hi Hasim,

I don't believe you can automatically do this in the EPM Add-In.

Are you saying you have the Time and Category dimensions in your column key axis, choose the ACTUAL category then only the Time members that have a specific property value (i.e. IN_ACTUAL = Y ) would appear in the member list?

You do have this option when building reports but not when actually choosing members from the member selector.

There is also the EPMContextMember which allows for a third paramater called:

filter - Filter by property to return only members with specified property values. Optional.

EPMContextMember("Finance","Entity","CALC=N;GROUP=SALES") ( from the EPM Add-in Help guide )

HTH,

John 

[Former Member]

Hi John,

Thank you for quick response. Actually, one dimension is in the row axis (costcenter), other is in page axis(bus_area). When user choose bus area, they do not want to see all costcenters. Only they want to see costcenters with chosen bus_area property in member selector. I can't find any method about this. And also they will select costcenter. It means I can't use EPMDimensionOverride formula because in input schedule, all costcenters are not drilled, only one will be shown. What can I do?

Best regards

Haşim