How I can convert the linked property on dimension (dynamically) in the epmaxisoverride

[Former Member]

I'm doing the migration from BPC 7.5 MS to BPC 10.1 MS, I need to rebuilt an evdre report with an epmreport.

In row I have 3 dimensions: entity, consoscope and currency

Entity: expand a list of entity

Consoscope; I need to have the property "node:cons" of entity dimension (in evdre reports I have using cellkeyrange)

Currency:I need to have the property "curr_lc" of entity dimension (if the users select in the context LC) or the property "curr_eur" (if the users select in the context EUR)

If I use in the epmfunction, linked property "node_cons" of dimension entity I cannot pass dynamically the property to expand rows. I need this functionality to manage the property “curr_lc” or curr_eur”.

Could you explain me how I can convert in epmaxisoverride this need?

Thanks

Ciao

Chiara

[Former Member]

Hi JP,

thanks but I need to related the expansion of currency property to the entity expanded in row:

Entity          consoscope                            currency

1001             G_none                                     lc  (is a property curr_lc if the user select LC)

                   (is a property node_cons of entity dimension)

CN_30_TOP   30_TOP                                 BRL   (is a property curr_lc if the user select LC)

If I use the dimension override I don't link the property currency to the entity expanded in row,

How I can do it?

Thanks

Ciao

Chiara

[Former Member]

Luigi, for more clarity can you please share the screenshots of the report and the master data maintained with property(all mentioned above).

Is the Currency column only for display??? in the report or does the data being displayed with respect to it??

If it is just for display then you can use Local member in that case with the same IF condition to display the appropriate property value as per the user selection.

Regards,

JP

[Former Member]

Hi Luigi,

If I understand you requirements correct then instead of using EPMAxisoverride use only EPMDimensionoverride.

Consoscope; I need to have the property "node:cons" of entity dimension (in evdre reports I have using cellkeyrange)

For this requirement you can use the Link to property function from Member Selector window. Go to Conscope dimension, then below select Dimension property and select Entity dimension with the property to be selected. In my case I have selected Interco dimension and property Entity.

Currency:I need to have the property "curr_lc" of entity dimension (if the users select in the context LC) or the property "curr_eur" (if the users select in the context EUR)

For this requirement you can give currency selection on context member, write an If condition depending upon the user selection of LC and EUR and use Dimension override. In this case B2 is the cell reference of IF condition and A2 is context member selection.

In my case I have used 2 properties ID and CALC...you can change it as per your requirement.

Hope this helps......:)

Regards,

JP