Is there any way we can use the transformation profile one to one mappings in a data table. Preferable to use in a connecter Drill back code. Is there any Data base table for the same.
If not, we have a create a custom XFC table in application DB to refer the same that replicates the transformation profile.
Hi
You don't need to reverse map using transformaiton rules for a drill back. The "vStageSourceAndTargetData" view you use for drill back, already has all the columns you need for drill back.
If a column ends with a T it is the target. E.g. Et is source and EtT is traget, this works for all dimensions.
I hope this helps.
But, if you still need the mapping table, it is "StageRules" with rule type 1 = one-to-one mapping and rule type 100 = transformation rule.
Please be careful accessing the database directly.
Cheers
Christian
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.