Performing calculation logic only for members that underwent an update

[Former Member]

Dear all,

Please help on the below scenario,

Will it be possible to run the calculation only for the master data that underwent a property change?
As at 01-Feb-16		As at 05-Feb-16
Dimension Y	Property X	Dimension Y	Property X
Member 1	A	Member 1	A
Member 2	B	Member 2	B
Member 3	C	Member 3	E
Member 4	D	Member 4	D
On data load the property has been over-written.
On the basis of values in Property X, we have a calculation.
Eg.
If member of Dimension Y has Property X's values
A	500
B	60
C	700
D	80
E	90
Will it be possible to run the calculation only for Member 3 and not for all the members?
As at 01-Feb-16			As at 05-Feb-16
Dimension Y	Property X	$	Dimension Y	Property X	$
Member 1	A	500	Member 1	A	500
Member 2	B	60	Member 2	B	60
Member 3	C	700	Member 3	E	90
Member 4	D	80	Member 4	D	80

We want to do this to ensure better performance as the dimension under consideration have many members and also there are many properties involved in the real scenario.

Regards

Deepika G S

[former_member186338 · Accepted solution]

For sure you can perform calculations only for the members with some specific property:

*XDIM_FILTER Y = [Y].properties("X") = "E"

*WHEN ...

...

But it's not related to the changed property - you have to manually select property value.

Vadim

[Former Member]

Hi Deepika,

The solution would be to create a new property, and during the master data update you first copy out all the old values into that new property, then load new values into the old property. you can do that using start routine.

then in your calc you can determine which property has changed, then only run for those.

Andy