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!

Unable to load data to target application - Error: Invalid dimension name

SrikanaJul 20 2016 — edited Feb 7 2017

Hi,

I am new to FDMEE world. We created a new HFM Application in which we have renamed "Entity" dimension name with "CompanyCodes" name. Also the Custom1 dimension has been renamed to CCPC.

Now I am trying to load data from SAP source and it's failing in the load step.

2016-07-20 15:21:54,168 INFO  [AIF]: Load data started: 7/20/2016 15:21:51.

2016-07-20 15:21:54,168 INFO  [AIF]: Line: 2, Error: Invalid dimension name

2016-07-20 15:21:54,168 INFO  [AIF]: !COLUMN_ORDER=SCENARIO,YEAR,PERIOD,VIEW,ENTITY,VALUE,ACCOUNT,ICP,CompanyCodes,CCPC,Custom2,Custom3,Custom4

2016-07-20 15:21:54,169 INFO  [AIF]: >>>>>>CompanyCodes

2016-07-20 15:21:54,169 INFO  [AIF]:

2016-07-20 15:21:54,169 INFO  [AIF]:

2016-07-20 15:21:54,169 INFO  [AIF]: Line: 3, Error: A valid column order is not specified.

2016-07-20 15:21:54,169 INFO  [AIF]: Actual;2016;Jan;YTD;E_028;<Entity Currency>;A_1010001;[ICP None];[None];[None];[None];GL_BOTH;0

2016-07-20 15:21:54,170 INFO  [AIF]: >>>>>>

The above is the error I am getting. Not sure where or How to Change the Column Order.

Anyone can guide through this.

Regards,

Srikana

This post has been answered by Srikana on Jul 21 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2016
Added on Jul 20 2016
5 comments
1,215 views