Using Dimension Properties

[former_member409271]

Hi Experts

We use the property field of a dimension to work out different calculation. So for example, we use Evpro or EPMMenmberProperty functions to get the property value of a dimension and if that dimensions property is a certain value, a calculation is done, if that property is another value a different calculation will be done.

The issue we are having is that - at some point in time, the property of a dimension will change thus the calculation will change depending on that dimensions property.

When we want to view prior periods, we still want the calculation to be based on what it was before it changed.

Hope I am clear with my query. Is there a way to make the property of a dimension static at a certain time period? or a way around this using BPC or its functions itself?

Thanks

Aadil

[Former Member]

Hi,

You can go for 2 properties with same values. In one property the values will be static and in another property you can change value.Then you can use static property value in your calculation.

Best Regards,

Deepak

[former_member409271]

Hi Deepak

thanks for the reply.

I don't think this will work for us, as the calc uses the property value at a specific time.

So for month march and prior,  the property was "A" the calc would be if A then multiply by an amount.

in Month April , the property changes to "B", so now the calc will multiply the value by another amount.

When we pull data for March and prior we still want to see the calc as it was when the property was "A" and when we pull data for April and going on we want to see the calc as it is when the property is "B".

The property could change again in future months and the calc will then be done according to the new property.

Regards

Aadil