on 05-11-2015 7:34 AM
Hi ,
I have a requirement to display values based on the selection of properties from different dimension
Below are the two dimension with properties.
COMP_CODE | |
ID | REG |
A1 | AMS |
A2 | AMS |
E1 | EMEA |
E2 | EMEA |
ENTITY | ||
ID | CC | DEPT |
11 | A1 | FIN |
22 | A1 | IT |
33 | E1 | OPERATION |
44 | E1 | IT |
55 | E1 | HR |
Output for selection
Region | need list | achieved via EPMdimension propertYvalues() |
Ccode | need list | need list based on the reference of region selection .Ex: if AMS is selected should show A1 and A2 in the list |
DEPT | need list | need list based on the reference of CCODE selection.Ex,if A1 is selected the list should show FIN and IT |
Entity | unique value | based on Ccode and DEPT should give entity ID. Ex:CCODE=A1 and Dept=IT then ID=22 |
request your help in the user selections for EPM report
Thanks
Aamer
Hi,
For CCode and Entity use filter value based on Excel reference in EPMContextMember .
For Dept use EPMDimensionPropertyValues.
Hope it helps..
regards,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Thanks for the reply.
I tried with EPMcontextmember..but it only shows the ID which is in context and after double click it show the filtered value.
However,I need a list with values for CCode and Dept based on the earlier selection.
EPMSelectmember and EPMcontextmeber will show result only if double clicked.
is there a work around for this ?
Thanks
Aamer
Hi Vadim,
Thanks for the reply.
User wants to move from hard-coded values in 7.5 report to dynamic reporting using properties in 10.1.
What i want is ...based on the selection of Region ..the CCODE values should be listed out .
And then based on the value selected in CCODE the DEPT values should be displayed .
(there is cross referencing of the dimensions and properties.)
Then for Entity i can use EPMDimensionoverride to display report .
I prefer to use EPM functions but if not support this will have to look into alternative.
Kindly advice on best way forward.
Thanks
Aamer
User | Count |
---|---|
12 | |
3 | |
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.