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

[cecilia_petersson2 · Accepted solution]

I've been playing around with comments as you suggest. Column DF is Entity, DG is Entity property Insurance, DH is comment retrieved from database for the selected period(EPMCommentFullContext), DI selects database comment if found, else property, and DJ saves the value of DI to the database. This way, each time you run the report for a new period, the current value of the property will be saved to the database and can be used in a calculation. If run for a previous period, nothing will be changed.

However, a drawback is that it will require manual intervention if you have already run the report for a period and thus saved that period's property value, and you later in the month want to change the property value. Also, my report is simple with only one period. If you have several periods, many columns will be required. I think this might be a difficult one!

/Cecilia

[former_member409271 · Accepted solution]

Hi Cecilia

Thank you soo much for this.

I think I can work with this as my solution. I see that it can become difficult but I now have a base to start from

Many thanks

Aadil