on 04-19-2017 3:24 PM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
"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:
Just to test property:
Use a simple report with any selection for
SOP_ACCOUNT
Add in some cell:
=EPMDimensionOverride("000","SOP_ACCOUNT","BUSINESS=EN")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sure Vadim,
attached the formula that works properly and the report as result
P.S. You can also play with a named range as a filter criteria:
tested, working!
Attached the image of SOP Family dimension: the SOP Family EN135 has the property BUSINESS = EN
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Done, but the result is the same, attached the images
Thank you
Martareport-1.pngedit-report.pngepm-member-selector.pngepm-member-selector-result.png
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.