Skip to Content
0
May 13, 2020 at 09:58 PM

Attribute Transformation (Alert Flag)

275 Views Last edit May 14, 2020 at 09:54 PM 4 rev

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/1834135510fdec14e10000000a4450e5.html

Thanks and regards

Attachments

capturar2.jpg (36.4 kB)
capturar1.jpg (41.1 kB)
capturar1.jpg (42.2 kB)
capturar3.jpg (30.5 kB)
capturar4.jpg (24.8 kB)
capturar5.jpg (23.3 kB)
capturar6.jpg (97.6 kB)
capturar.jpg (41.7 kB)
capturar1.jpg (22.2 kB)
capturar1.jpg (42.8 kB)