selection based on property values in EPM report BPC10

[Former Member]

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

[former_member190501]

Hi,

For CCode and Entity use filter value based on Excel reference in EPMContextMember .

For Dept use EPMDimensionPropertyValues.

Hope it helps..

regards,

Raju

[Former Member]

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

[cecilia_petersson2]

Hi Aamer,

Try EPMDimensionMemberOverride(). However, the dimension you want to override has to be in either the row or column axis (it doesn't work with page axis).

/Cecilia

[Former Member]

Hi Cecillia,

Thanks

For Entity i plan to use the EPMDimensionoverirde in rows but before that i need to perform the filtering on the Ccode and DEPT properties to read it in override.

Still having trouble in reading multiple values.

Thanks

Aamer

[Former Member]

Hi ,

I am able to get the CCODE entries via the EPMSelectmember and it displays value when double click but not in a drop down list.

Is it possible to get values in the list ?

THanks

Aamer

[former_member186338]

Hi Aamer,

"Is it possible to get values in the list ?" - No! For sure you can create your own VBA code, but I don't think it's what you want.

Vadim

[Former Member]

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

[former_member186338]

"need list based on the reference of CCODE selection.Ex,if A1 is selected the list should show FIN and IT" - VBA only!

[Former Member]

Thanks Vadim.

i am looking into your article as a starting point for writing VBA/API code.

If you have any sample with similar scenario do share,it will help a lot.

Thanks again

Thanks

Aamer

[former_member186338]

Yes, the code from

can be used!

Vadim