Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Complex Logic - Custom Script - Some other solution?

MFUFeb 9 2011 — edited Feb 9 2011
Evening All,

FDM v11.1.1.3
Goal:_ To have conditional mapping based on a currency column. Original accts translate to summary account plus specific C2 member based on the currency. Solution is needed to aid in Currency Exposure reporting.

I have been trying to use complex logic with no luck.

Dimension Background:_
Custom2 dimension has been built with duel purpose. For P&L accounts it provides Cost Center detail. For Balance Sheet it will provide Currency Exposure Detail. For any P&L accounts C2 is either the exact matching member from the file or C2#0000 if no Cost Center applies.

So the intent was to read the Account/Currency combination and if Acct=<focus aact> then change C2#0000 to hard-coded C2 value as depicted in the example below.

Example:_
Curr=USD A#1020?? -> A#102001.C2#USD_USD
Curr=AUD A#102038 -> A#102001.C2#USD_AUD
Curr=GBP A#102047 -> A#102047.C2#USD_GBP
Curr=GBP A#102051 -> A#102051.C2#USD_GBP

Attempted Solution:_
I previously had various Explicit/Between/In/Like definitions. I have tried to create Complex Logic accounts. When I IMPORT the source file. It creates the proper Logic Account records with the proper C2. But two issues emerge:

1> I have one logical record and one original record
2> When I VALIDATE I get converted dimension as per normal mapping not the hard coded value (C2#USD_AUD).

I tried the following but still not getting expected results:
Explicit Map 102038 -> IGNORE
Explicit Map L102001_AUD -> 102001
Any advise would be greatly appreciated.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 9 2011
Added on Feb 9 2011
1 comment
157 views