Cannot Create Value-Based Hierarchies (VBH) From OWB 11.2 To Load a MOLAP Dimension

(Doc ID 1175353.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Creating value based hierarchies to load to a MOLAP dimension fails with:

LOAD_FIN_DIM_ENTITY 2
2010-07-13 16:57:35.0 3
ORA-37162: OLAP error
'TGT_112.FIN_ENTITY_DIM': XOQ-01995: Object
"IM_TARGET.OWB$SRCVIEW_FIN__STANDA_10AB3E.STANDARD_PARENT_ENT_ID" does not
exist.
'TGT_112.FIN_ENTITY_DIM': XOQ-01995: Object
"IM_TARGET.OWB$SRCVIEW_FIN__STANDA_10AB3E" does not exist.
XOQ-01400: invalid metadata objects
ORA-00936: missing expression

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms