3 Replies Latest reply on Sep 15, 2016 11:54 AM by USER1211

    DataLoad mapping Issue

    3308134

      I am unable to validate the above mapping

        • 1. Re: DataLoad mapping Issue
          Dayalan Punniyamoorthy

          You can also use Like mapping with * to *, will give the same result.

           

          Have you added the Target application & make sure there is no error during the addition, If added you can refresh the metadata and click on the Search Icon to select the value.

           

          HTH,

          Dayalan P.

          • 2. Re: DataLoad mapping Issue
            3308134

            Cluster name:  HFMCluster

            2016-09-15 16:53:01,625 INFO  [AIF]: Connected to: BABAAPP

            2016-09-15 16:53:05,760 ERROR [AIF]: Load data started: 9/15/2016 16:53:01.

            2016-09-15 16:53:05,760 ERROR [AIF]: Line: 2, Error: Invalid cell for Period January.

            2016-09-15 16:53:05,760 ERROR [AIF]: Actual;2004;January;YTD;HYD;<Entity Currency>;AdminExpenses;[ICP None];Cinthol;Customer1;Opening Stock;7000

            2016-09-15 16:53:05,760 ERROR [AIF]: >>>>>>

            2016-09-15 16:53:05,760 ERROR [AIF]:

            2016-09-15 16:53:05,760 ERROR [AIF]: Line: 3, Error: Invalid cell for Period January.

            2016-09-15 16:53:05,760 ERROR [AIF]: Actual;2004;January;YTD;HYD;<Entity Currency>;Advertisements;[ICP None];Cinthol;Customer1;Opening Stock;9000

            2016-09-15 16:53:05,760 ERROR [AIF]: >>>>>>

            2016-09-15 16:53:05,760 ERROR [AIF]:

            2016-09-15 16:53:05,760 ERROR [AIF]: Line: 4, Error: Invalid cell for Period January.

            2016-09-15 16:53:05,760 ERROR [AIF]: Actual;2004;January;YTD;HYD;<Entity Currency>;Purchases;[ICP None];Cinthol;Customer1;Opening Stock;11000

            2016-09-15 16:53:05,760 ERROR [AIF]: >>>>>>

            2016-09-15 16:53:05,760 ERROR [AIF]:

            2016-09-15 16:53:05,760 ERROR [AIF]: Line: 5, Error: Invalid cell for Period January.

            2016-09-15 16:53:05,760 ERROR [AIF]: Actual;2004;January;YTD;HYD;<Entity Currency>;Rent;[ICP None];Cinthol;Customer1;Opening Stock;13000

            2016-09-15 16:53:05,760 ERROR [AIF]: >>>>>>

            2016-09-15 16:53:05,760 ERROR [AIF]:

            2016-09-15 16:53:05,760 ERROR [AIF]: Line: 6, Error: Invalid cell for Period January.

            2016-09-15 16:53:05,760 ERROR [AIF]: Actual;2004;January;YTD;HYD;<Entity Currency>;Salaries;[ICP None];Cinthol;Customer1;Opening Stock;15000

            2016-09-15 16:53:05,760 ERROR [AIF]: >>>>>>

            2016-09-15 16:53:05,760 ERROR [AIF]:

            2016-09-15 16:53:05,760 ERROR [AIF]: Line: 7, Error: Invalid cell for Period January.

            2016-09-15 16:53:05,760 ERROR [AIF]: Actual;2004;January;YTD;HYD;<Entity Currency>;Sales;[ICP None];Cinthol;Customer1;Opening Stock;5000

            2016-09-15 16:53:05,760 ERROR [AIF]: >>>>>>

            2016-09-15 16:53:05,760 ERROR [AIF]:

            2016-09-15 16:53:05,760 ERROR [AIF]: Load data completed: 9/15/2016 16:53:01.

            • 3. Re: DataLoad mapping Issue
              USER1211

              What is the exact patch level of FDMEE are you on?

              You should follow Dylan advice of the refresh metadata.

              Also did you confirm HYD is a leaf level members?

              Also you have to ensure that the combination which the data exist is a valid intersection in HFM else the data will not load. If the intersection is not valid then you have to go back to the the business team and let them know so they can work with the necessary teams to correct the data.