Need Help Implementing Data Derivation and Change Tracking in SAP Analytics Cloud Planning Models

[former_member781426]

In SAP Analytics Cloud planning models, we are trying to achieve a derivation process similar to characteristic relationship replication in SAP BW IP (Integration Planning). The goal is to derive and save a value with a record when data is saved in the model. This concept is similar to MD (Master Data) derivation in a SAP BW transformation, where a field exists in the target but not in the source, and you derive it during the load process by reading the MD field of the object.

Here's a step-by-step explanation of what we want to achieve:

1. Original Record:
- Cost Centre = A
- Month = Jan
- Value Type = 20
- Amount = 10

2. User Interaction:
- In the planning layout, the Value Type is not visible to the user.
- The user changes the "Amount" from 10 to 8. Like the following.

- Cost Centre = A
- Month = Jan
- Value Type = 20 (Not visibale to user in the story/planning layout)
- Amount = 10

3. Derivation and Change Tracking:

- When the user saves the modified record, we want to derive a constant value and save it back into the model.
- This constant value, "Value Type = 50," represents the change (delta) made by the user.
- This derived "Value Type = 50" should be saved with the modified record, allowing us to track changes.

- Original Amount = 10 , New Amount = 8. In the modified/derived record Amount should be displayed as Amount = -2 (8 - 10).

Modified reord should be saved as follow.

- Cost Centre = A
- Month = Jan
- Value Type = 50
- Amount = -2

As opposed to the following

- Cost Centre = A
- Month = Jan
- Value Type = 20
- Amount = 8

4. Final/Updated Records in Model

After this planning change/update, when the data is published. Planning model should have the following 2 records.

Record 1.

- Cost Centre = A
- Month = Jan
- Value Type = 20
- Amount = 10

Record 2.

- Cost Centre = A
- Month = Jan
- Value Type = 50
- Amount = -2

Please advice how we can achieve this?

Where we should write our script?

[former_member781426]

In short, we want to achieve the following.

Original record which is Cost Centre = A, Month = Jan, Value Type = 20, Amount = 10

Changed to Cost Centre = A, Month = Jan, Value Type = 50, Amount = -2

As opposed to Cost Centre = A, Month = Jan, Value Type = 20, Amount = 8

Note: Value type is not in the story layout.

[N1kh1l]

hsthind76

2. User Interaction:

hsthind76- In the planning layout, the Value Type is not visible to the user.

Not visible but the original amount of 10 is on value type 20 and you want that when this amount of 10 is changed to 8 the delta 2 or the final 8 should be posted to value type 50?

Not sure if its a derivation case as the original record of 10 itself is populated with value type 20 so no characteristic is missing. If you modify the same record it will adjust the same record and same value type. Only if you treat the adjustments separately of the original record ( posting delta) in a layout where value type is missing or assigned constant derivation can come into play with help of SAC validations.

Br.

Nikhil

[former_member781426]

Hello Nikhil,

You are right no characterstic is missing. What we want is any change should be against Value Type 50 as oppose to Value type 20.

In short, we want to achieve the following.

Original record which is Cost Centre = A, Month = Jan, Value Type = 20, Amount = 10

Changed to Cost Centre = A, Month = Jan, Value Type = 50, Amount = -2

As opposed to Cost Centre = A, Month = Jan, Value Type = 20, Amount = 8

Note: Value type is not in the story layout.

Please advise, how i can achieve this.