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 18.104.22.168), 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.