1 Reply Latest reply: Sep 30, 2013 9:17 AM by Celvin Kattookaran RSS

    Members rejected during dimension load

    ragavhere

      Hi,

       

      I am trying to deploy an application from Essbase studio. It loads few members and rejects few members. And it does not load any member to scenario and Version dimensions. I have the source in Parent, child relationship and the top most parent being #root for every dimension.

       

      And when I preview the hierarchy, it shows in correct parent child relationship. But after the cube deploy, in the outline it is in random order. All parents are created under the dimension itself. And the error during cube deploy in Essbase studio is

       

      Member load for dimension Account started at: Sep 30, 2013 12:34:15 AM PDT. Records processed: 2,424. Records rejected: 1,770.

      Member load for dimension CostCenter started at: Sep 30, 2013 12:34:16 AM PDT. Records processed: 2,865. Records rejected: 1,271.

      Member load for dimension Period started at: Sep 30, 2013 12:34:17 AM PDT. Records processed: 16. Records rejected: 12.

      Member load for dimension Year started at: Sep 30, 2013 12:34:17 AM PDT. Records processed: 9.

      Member load for dimension Product started at: Sep 30, 2013 12:34:17 AM PDT. Records processed: 254. Records rejected: 156.

      Member load for dimension Project started at: Sep 30, 2013 12:34:18 AM PDT. Records processed: 1,503. Records rejected: 56.

      Member load for dimension Scenario started at: Sep 30, 2013 12:34:18 AM PDT. Records processed: 9. Records rejected: 9.

      Member load for dimension Version started at: Sep 30, 2013 12:34:18 AM PDT. Records processed: 15. Records rejected: 15.

      Member load for dimension State started at: Sep 30, 2013 12:34:19 AM PDT. Records processed: 102. Records rejected: 85. Member load elapsed time:  5 Seconds.

      Data load started at: Sep 30, 2013 12:34:21 AM PDT.  Records processed: 50,854. Records rejected: 50,854. Data load elapsed time:  6 Seconds.

       

      \\Record #17 - Member name (REAL ESTATE STATS) already used

      REAL ESTATE STATS 31104

      \\Record #18 - Member name (REAL ESTATE STATS) already used

      REAL ESTATE STATS 31201

       

      All data records are rejected as well.

       

      Regards,

      Ragav.