0 Replies Latest reply on Oct 24, 2013 12:00 AM by ae124840-6e4c-4311-816b-cff2e3e93310

    OBIEE Evaluate - "Essbase error : Repeated dimension in MDX query"

    ae124840-6e4c-4311-816b-cff2e3e93310

      Hi,

       

      I'm using OBIEE 11.1.1.6.2 BP1 on top of Essbase.

       

      I have a project dimension in Essbase with three levels - Total Project -> Project Class -> Project. I have created a new logical column in OBIEE to query two levels from project dimension, using evaluate function as below:

      Evaluate('%1.Members, %2.Members',  "Oracle Hyperion Planning"."ASOCUBE".""."Planning"."Gen2,Project" ,   "Oracle Hyperion Planning"."ASOCUBE".""."Planning"."Gen4,Project" ).

       

      The above column when used in analysis, works fine, returning "Total Project" and all the projects. It breaks however when any filter is applied on project dimension with the following error:

      "[nQSError: 96002] Essbase Error: Repeated dimension [Project] in MDX query".

       

      I donot have any MDX skills and would appreciate if anyone can explain this error and provide any workaround for this. Here's the MDX that fails:

       

      With

        set [_Project0] as '{[Project].Generations(2).Members, [Project].Generations(4).Members }'

       

      select

        {} on columns,

        {{[_Project0]}} properties GEN_NUMBER on rows

      from [ASOCUBE.Planning]

      where ([Project].[1000000-Treatment Plant])

       

      Many Thanks