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!

Data Load into different Plan Types using FDMEE

JanGLiOct 18 2016 — edited Oct 18 2016

Hi,

Guys really need your help on this issue.

I have two plans; "Plan1" and "Plan2". I have dimension "Employee" opened only for "Plan2".

I am trying to load data into plan1 using open interface adapter.

I haven't mentioned dimension employee while creating source adapter (open interface); by this i mean the alias you give to column of aif_open_interface table.

I have left dimension employee empty in import format.

I have used like mapping for employee dimension (*->IGNORE).

I am getting a validation error for No Source UD5.

My target application dimension mapping in FDMEE screenshot:

pastedImage_0.png

Below is a screen shot of my Open Interface source columns:

pastedImage_2.png

My Import Format:

pastedImage_3.png

My data load mapping for employee dimension:

pastedImage_5.png

Validation error screenshot:

pastedImage_4.png

I could not map employee dimension in target application but the issue is i have to upload data for plan2 too using different mapping.

What to do? how can i ignore employee dimensions?

Regards and thanks for help in advance.

This post has been answered by ThinkFDM on Oct 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2016
Added on Oct 18 2016
4 comments
937 views