SAP BPC & Templates & Dimentions

[Former Member]

I need your help. Iu2019m trying to do something with the templates of the SAP BPC but I donu2019t know how to do it, or if itu2019s possible.

In a template in the rows can appear the properties of a dimension, I mean that I can see it physically, but not as to filter with that property. For example, if I a put u201Crestaurantu201D I want to show me the address of this u201Crestaurantu201D, like if it was an attribute of BW.

Here I want to put the address like a property of the dimension.

In the beginning, the answer in u201CNOu201D, it canu2019t appear, but do you know how can I do this? Is it possible?

Thank you in advance.

Pablo Mortera.

[Former Member · Accepted solution]

Are you using evdre?

In evdre you can filter your memberset expansion on properties.

Please provide further details.

[sorin_radulescu]

You have function like EVPRO function which is providing the values of property for a specifiv member of a dimension.

You can read more about this function into webexcel help online.

Regards

Sorin Radulescu