5 Replies Latest reply on Jul 28, 2016 6:04 PM by SSN01

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

    Srikana

      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