Database DataWarehousing (MOSC)

MOSC Banner

View created on Analytical workspace using OLAP_TABLE not working after migration form 10g to 11g

edited Jan 17, 2013 4:47AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓
Hello,

We created VIEWS using OLAP_TABLE option. They were working fine in 10g. However after migration to 11g it throws error 'Can not use SHSH4.HIERDIM in LIMITMAP'

We tried to remove HIRARCHY clause then it throws error for 'ATTRIBUTE'

If we remove all attribute and HIRARCHY cluase in LIMITMAP, view returns data. But values for these ATTRIBUTES is missing.

Can anyone help me with this problem?

Steps followed to create view


 CREATE TYPE bg_SILUETT_GF_type AS OBJECT (
            TID   VARCHAR2(100),
            TID_NIVA   VARCHAR2(100),
            TID_FLDR   VARCHAR2(100),
            TID_HIER   VARCHAR2(100),
            FKNR       VARCHAR2(200),
            FKNR_NIVA  VARCHAR2(200),
            FKNR_BESK  VARCHAR2(200),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center