cancel
Showing results for 
Search instead for 
Did you mean: 

Expand Dimension using another dimension Property

Former Member
0 Kudos

Hi guys,

My template has Product in the Rows (User Defined) and Time in the Collums.

The Entity dimension is changed at the context, but I want Currency to show the value of the property "Currency" of Entity dimension.

I've tryed to do this putting Currency at the collum, and trying to filter it by Dimension Property, but I didnt succeed.

Any thoughts?

Thanks in advance.

Adriano Frossard

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi Adriano,

Simply put currency in the page axis and in the EPMOlapMemberO formula use formula to get a property of entity. Read here:

Vadim

former_member186338
Active Contributor
0 Kudos

The formula in the CURRENCY page axis cell will be like:

= EPMOlapMemberO(EPMMemberProperty(; EPMMemberID($A$4); "CURRENCY");"[CURRENCY].[].[USD]";"USD";"";"000")

Where $A$4 is the page axis cell with ENTITY member.

Vadim

Former Member
0 Kudos

Hi Vadim,

You're right! That will do!

Thanks you so much.

Adriano Frossard

Answers (1)

Answers (1)

former_member190501
Active Contributor
0 Kudos

Hi,

Try using Dimension Override.

Hope it helps...

regards,

Raju