Skip to Content
1

EPM 10.0 SP27 EPM Member Selector issue

Apr 19, 2017 at 02:24 PM

177

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vadim Kalinin Apr 19, 2017 at 02:44 PM
0

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!


filt.png (31.8 kB)
cc.png (43.9 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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

0
Former Member

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

0

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

0
avatar image
Former Member Apr 20, 2017 at 03:53 PM
0

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


Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0
Former Member

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

Thank you

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

0

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.

0
avatar image
Former Member Apr 21, 2017 at 01:27 PM
0

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

Thank you

Martasop-family-dimesnion.png


Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

sop-family-dimesnion-en.png

As also lots of other families...

0

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

0
Vadim Kalinin Apr 21, 2017 at 02:08 PM
0

Just to test property:

Use a simple report with any selection for

SOP_ACCOUNT

Add in some cell:

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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

0
Former Member

Sure Vadim,

attached the formula that works properly and the report as result

epmdimensionoverrideformula.png

reportresult.png

0

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

0

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/f1610fed36504f06ade60a6af8cc9bea.html

tested, working!

0
Vadim Kalinin Apr 26, 2017 at 06:15 PM
0

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!


cont.png (48.7 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

"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:

ccrep.png (40.8 kB)
ccpr.png (34.8 kB)
0
Former Member

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

0

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!

0