on 03-20-2017 3:53 AM
Hi all,
I want to create a report with a dimension members based on other dimension members, example :
Here is 2 dimension with their members :
The reports :
Dim2 list of members display is based on Prop2 property with value from Dim1 ID.
D2_1 or D2_2 member will not show with D1_2 member.
D2_3 or D2_4 member will not show with D1_1 member.
I want to create a report like this. Few years ago with EPM Add-In, I done it (if I am not mistake). Now I am using AO, but I couldn't find the way.
Thanks.
In general the only possible solution is:
1. Create additional report (as default report) with PRODH in rows and EPMDimensionOverride("000","PRODH","BAS(XXX)") to get required base member list.
2. Create a local member in this report to concatenate string:
PRODH=X1,PRODH=X2,PRODH=X3 etc... - in the first row of the report (for example cell B5)
3. In your real report 001 use
EPMDimensionOverride("000","MATERIAL",B5)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your response Vadim.
I have used it before but I didn't get as per my requirement or did I set incorrectly ?
Dim1 = Product Hier
Dim2 = Material
Prop2 = Product Hier
As I remember in EPM Add-In there is setting by choosing relationship then choose which property from Dim2 to be equal to Dim1 ID (in this case Prop2 should be equal to Dim1-ID).
From my picture, it is only choose 1 dim property, but no selection equal to which dimension.
The product hierarchy members depend on context (epm override) and the material members based on product hierarchy members from property PRODH in material dimension.
Here is my report :
This is member selector for product hierarchy in edit report (based on override) :
This is member selector for material in edit report :
Did I do it correctly ?
User | Count |
---|---|
15 | |
4 | |
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.