cancel
Showing results for 
Search instead for 
Did you mean: 

EPM 10.0 SP27 EPM Member Selector issue

Former Member

Hello,1-epm-member-selector.png2-epm-member-selector.png

I have installed EPM 10.0 SP19 and in another machine EPM 10.0 SP27 and the result is the same in both solutions.

I have to expand members of a dimension using the EPM Member selector and filtering by a property of the dimension to expand that is driven by the context. I have to expand the products in rows that have the property Business Unit equal to the member of the dimension Business Unit that is selected in the context.

Attached you can see the result

Can you Help me?

Marta

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member186338
Active Contributor
0 Kudos

I have found the issue preventing you to use property to CONTEXT filter.

You have to set "Display as ID" in the context member selection!

And on your screenshot I see that context is shown as ID - Description!

In order to be independent of Display option you can do the following:

In A1 you have page axis member of BUSINESS dimension.

In B1 put formula: =EPMMemberProperty(, EPMMemberID(A1), "ID")

Name B1 as a range ___BUS

Configure filter for SOP_FAMILY as:

Property

BUSINESS = ___BUS

Done!

Former Member
0 Kudos

Thank you very much Vadim,

setting "Display as ID" in the context member selection for Business dimension it works the EPMMemberProperty! But just for me...Users too have to set "Display as ID" in the context member to allow the report to work and it is not so easy, users are 350 all over the world. Is there a solution to set the context member for the business dimension as ID as a fized rule?

About the other solution you suggested - the name range - it doesn't work; attached you can find my test.

Thank you

Marta

businessinpageaxis.png

epmmemberpropertyandnamerange.png

result1.png

result2.png

former_member186338
Active Contributor
0 Kudos

"Is there a solution to set the context member for the business dimension as ID as a fized rule?" - Not possible, user can change it at any moment!

"About the other solution you suggested - the name range - it doesn't work; attached you can find my test." - It works, I always test solutions before posting. Look on the screenshots:

Property filter:

Former Member
0 Kudos

You're right Vadim, I tested with SP19 and the solution doesn't work, but with SP27 it works properly!

Now we have to decide to update users EPM version, now they have installed EPM SP19...

Thank you very much!

Marta

former_member186338
Active Contributor
0 Kudos

Then please accept the correct answer and close the question!

EPM SP19 is absolutely old, you have to upgrade to something recent. May be SP24 will also work!

former_member186338
Active Contributor
0 Kudos

Just to test property:

Use a simple report with any selection for

SOP_ACCOUNT

Add in some cell:

=EPMDimensionOverride("000","SOP_ACCOUNT","BUSINESS=EN")

Former Member
0 Kudos

Thank you Vadim,

I know that I could use the EPMDimensionOverride formula, but I can't because I need to use also EPMInsertMember and they cannot be used together...

former_member186338
Active Contributor
0 Kudos

EPMDimensionOverride is just to test that property filter is working correctly!

Former Member
0 Kudos

Sure Vadim,

attached the formula that works properly and the report as result

epmdimensionoverrideformula.png

reportresult.png

former_member186338
Active Contributor
0 Kudos

Then the original test has to work properly!

I have created exactly the same case and - no issues! I can't imagine what you are doing wrong...

Look again on my sample...

If I change COMPANY_CODE and refresh - I have a correct list of COST_CENTER for the new COMPANY_CODE member...

former_member186338
Active Contributor
0 Kudos

P.S. You can also play with a named range as a filter criteria:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.28/en-US/f1610fed36504f06ade60a6af...

tested, working!

Former Member
0 Kudos

Attached the image of SOP Family dimension: the SOP Family EN135 has the property BUSINESS = EN

Thank you

Martasop-family-dimesnion.png

Former Member
0 Kudos

sop-family-dimesnion-en.png

As also lots of other families...

former_member186338
Active Contributor
0 Kudos

I don't know what are you doing wrong. In my test the result is absolutely fine.

May be the property has space at the end? Like EN<space>?

I am working with EPM SP27 patch 2

Former Member
0 Kudos

sample-edit-report-dimensions.jpgsample-edit-report-property-filter.jpgsample-report.jpg

Hello Vadim,

I've tried to develop a very simple report with a dimension in row and another one in column as you suggested and attached the result; The EPM Member selector doesn't work properly.

Maybe I have to set something? Do you have any idea?

Thank you

Marta

former_member186338
Active Contributor
0 Kudos

In my case everything is working fine!

Please ensure that for BUSINESS dimension the Display is set to ID only.

Add BUSINESS to page axis

former_member186338
Active Contributor
0 Kudos

Something like:

1. New report

2. Add BUSINESS to page axis

3. Set BUSINESS Display to ID only

4. Add SOP_ACCOUNT to column axis

5. Add SOP_FAMILY to row axis

6. Configure filter for SOP_FAMILY property

Done

Former Member
0 Kudos

Done, but the result is the same, attached the images

Thank you

Martareport-1.pngedit-report.pngepm-member-selector.pngepm-member-selector-result.png

former_member186338
Active Contributor
0 Kudos

Please show that you really have members in SOP_FAMILY with property BUSINESS having value EN

Screenshot of SOP_FAMILY dimension administration will help!

If you don't have this property value then your report will fail.

Have to repeat - my test report is working absolutely as expected.

former_member186338
Active Contributor
0 Kudos

Just tested!

Working absolutely fine!

May be you have context selection not matching any property value?

P.S. In my sample I am using COST_CENTER dimension having BPC_COMPANY_CODE property. And valid COMPANY_CODE dimension member is selected in the context.

In the report all COST_CENTER members with the property BPC_COMPANY_CODE equal to context member of COMPANY_CODE dimension are shown!

Former Member
0 Kudos

Thank you for your answer Vadim,

I've checked and I have a correct Selling BU member selected in the context; the Selling BU dimension has to be selected by the user in the context.

I really don't understand why...

former_member186338
Active Contributor
0 Kudos

Please show your report screenshot! With detailed description... I have tested this case using EPM SP27 - absolutely no issues.

Former Member
0 Kudos

Thank you Vadim,

I have Excel 2016 and EPM SP27, but the issue is present also in EPM SP19 and the most of users have EPM SP19.

Attached you can find the image of the Report, the image of the EPM Report Editor, the image of the EPM Member Selector of the Selling BU and the image of the EPM Member Selector of the SOP Family.

The SOP Family has a property called Selling BU as the existent dimension and when for example the Selling BU in context is S_MMS, the goal is to expand the SOP Families with the property Selling BU equal to S_MMS.

Thank you

Martaepm-report-epm-selling-bu-in-context.pngreport.pngepm-member-selector-of-selling-bu.pngepm-member-selector-of-sop-family.png.png

former_member186338
Active Contributor
0 Kudos

It's working! Try to simplify your report to my sample!