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!

Lookup Dimension in FDMEE

amith.madisettyJul 22 2017 — edited Aug 2 2017

Hi Experts!

Altogether am a new to FDMEE, recently started work on FDMEE.

Am trying to achieve a logic using lookup dimension.

I have accounts generated in an export and i want them to get mapped through fdmee staging and generated to down stream system. Mappings are being maintained and managed by Business for Accounts dimension. I cannot extract the data for the accounts defined in the mappings by the business, if they are dynamic calc in nature, due to some block explosion issues, where in essbase all possible blocks ignoring all fix and tried to get on with this issue by going with different approaches like tried making the dynamic calc to dynamic calc and store, created complete outline in ASO and pushing data from BSO to ASO etc... So the approach am trying now is if there are any dynamic calc members defined in the source accounts , then derive level0 members of it and pass it to export script through epmautomate.  So to business their mappings will not change , they will define members they wish to extract and send to down stream, we are thinking to use lookup and map these level 0 members extracted through essbase to dynamic calc and through actual mappings defined by business the dynamic calc gets changed to target system account code.

Ex: 

Account Dimension

Mapping --> Source (Total Income) -------- Target(XXXXXX)

Target Account (LookUp Dimension)

Mapping ---> Source (aaaa) -------- Target(Total Income)

                      Source (bbbb) -------- Target(Total Income)

                      Source (cccc) -------- Target(Total Income).

I have defined Target Account as dimension in Target application, and in import format i have mapped account field to account dimension and Target Account dimension(Look Up)

Any help is greatly appreciated...!!!

Cheers!

Amith

Comments

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

Post Details

Locked on Aug 30 2017
Added on Jul 22 2017
2 comments
494 views