Symptom
A model has a default currency (USD for example)
A generic dimension within this model has currency switched on in the attributes and a particular member has currency set to EUR.
A new property of type "Integer" is created and the value 500 is entered.
This value is then used to calculate a value for an account dimension member.
If the data action refers to this property with [d/Employee].[p/Currency] the value is converted from USD to EUR, even though the currency attribute for this member is already set to EUR.
It appears that the attribute of a public dimension by default picks up the currency of the model rather than the currency defined in the attributes of the public dimension.
Environment
SAP Analytics Cloud, all versions
Cause
The attribute value of a dimension by default uses the default currency of the model, so by default the data action will consider the attribute value to be in USD.
Resolution
If you wish to reference the public dimension currency property in the data action there is an option to set the Currency conversion Option on the Data action trigger panel to be based on the selected Currency conversion option to be based on the currency of the dimension member.
Keywords
KBA , LOD-ANA-PL-DA , Data Actions , Problem
Product
Attachments
DA_POC3 HR Comp Model 055 create comp_2.jpg |