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

Is it possible to do a SQL mapping in a data load rule based on period being loaded to?

Summary:

I am trying to determine if it is possible to do a SQL mapping in a data load rule based on the period being loaded to.

Content (please ensure you mask any confidential information):

In general I know that you can do a SQL mapping dependant on the value in another dimension but cannot figure out how to do this based on period being loaded to.

As an example, we have mappings like this for the dimension assigned to UD2:

CASE
WHEN ACCOUNTX LIKE '1.1.1.111'
THEN 'No Program' ELSE UD2 END

I would like to do something like this using Period and Year but since these aren't dimensions in Data Integrator like ACCOUNT or UD2, I can't figure out how to reference them.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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