You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Management - Calculate data column based on mapped dimension column

in Planning 1 comment

Hi,

I want to calculate a data column based on a LOOKUP dimension that was already calculated with multi-dimension mapping.

See below, this LOOKUP Dimension (Conversion), is mapped through multi-dimension mapping. So, the mapped values there I want to use them in another dimension mapping (Data). This lookup dim is UD10, I understand that mapped dim is UD10X. In my SQL Statement for the Data Column, I put like DATA = UD10X, but it does not work.

The lookup dimension as source column is empty, given that I just mapped on the target expression.

Is there any way to do it?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!