0 Replies Latest reply on Nov 14, 2012 4:11 PM by 797321

    Show OLAP hierarchy based on values in OBIEE 11g

      Hi all

      I have an OLAP cube with three dimensions, in a dimension I have a hierarchy of levels and a value-based hierarchy (parent-child).
      I do the import cube metadata and all its dimensions from the Administration Tool.

      When I want to do a report on analytics (OBIEE, the hierarchy levels displayed correctly, but when I show the hierarchy based on values shown the following error:

      [nQSError: 27037] Unresolved level: "BI_PROEZA"."COMPANIA - COMPANIA_VAL"."COMPANIA - COMPANIA_VAL"."Grand Total". (HY000)

      I hope you can help me, regards.