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

Received Response


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?

Howdy, Stranger!

Log In

To view full details, sign in.


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