This discussion is archived
0 Replies Latest reply: Nov 14, 2012 8:11 AM by 797321 RSS

Show OLAP hierarchy based on values ​​in OBIEE 11g

797321 Newbie
Currently Being Moderated
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points