Attribute Transformation (Alert Flag)

[vinicius_moura]

Hi experts

We are trying to set an Attribute Transformation in order to use it as a Filter in our Planning View (Addin Excel) so it displays only the combinations Product - Location that have been trigged an alert. In other words, we are trying to set an Attribute whose value is equal to a Key figure value. According to SAP help, this is something possible to achieve, however, there is no modeling example to follow. After several tests, we created 3 Key figures and an Attribute Transformation as following but we are getting a error message.

Key Figure 1 (VTMTESTE1111): Stored Key figure used in the Key Figure 2 (VTMTESTE4444) calculation after attribute transformation.

Key Figure 2 (VTMTESTE4444): Alert Key Figure (If "Key Figure 1">1,1,0)

Key Figure3 (VTMTESTE222): Key figure used in the Attribute Transformation calculation as a condition for the Attribute Value

Attribute Transformation (ALERTFLAG2): Attribute' value based on Key Figure 2 (VTMTESTE4444)

The planning level is Month-Prod-Loc. (In MTHPRODLOCFLAG and MTHPRODLOCFLAGTRANSF the FLAG and FLAGTRANSF are just names used exclusive for the tests.)

Error message (excel addin) when value is 1:

(We have followed theses steps but this message still displays)

Error message (excel addin) when value is 0

Documentation about Attribute Transformation (Alert Flag):

Link: https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2005/en-US/1834135510fdec14e10000000a44...

Thanks and regards

[former_member194529 · Accepted solution]

Hi Vinicius,

This error message is usually displayed when there are abandoned combinations on the planning objects table for which the corresponding Master Data type do not exist anymore. You can run the Purge Non-Conforming data Application Job Template for the Planning Area to delete the invalid combinations and check if the error message is gone.

Best,

Ivan