SAP Knowledge Base Article - Public

3301123 - Custom property of a dimension member with "enable currency" does not take into account the members currency in a data action

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

SAP Analytics Cloud 1.0

Attachments

DA_POC3 HR Comp Model 055 create comp_2.jpg