Skip to Content
0
Former Member
Apr 08, 2010 at 04:30 AM

Conditional mapping in the transformation file

109 Views

Hi

Can anyone tell me if it is possible to perform more complex mapping when loading transactional data? I have 2 requirements:

1. When the Profit Centre is invalid, set it to a default value of "9999". Where an invalid Profit Centre is a Profit Centre that does not exist as a valid dimension member.

2. When the Profit Centre is null, then set it to a default value based on the Entity value.

For example:

When the Profit Centre is null and the Entity = 100, set the profit centre to 1000.

When the Profit Centre is null and the Entity = 200, set the profit centre to 2038. etc

Ideally I would like to define the mapping rules in either transformation or conversion files.

Regards, Sharon