View created on Analytical workspace using OLAP_TABLE not working after migration form 10g to 11g
Hello,
CREATE TYPE bg_SILUETT_GF_type AS OBJECT (
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
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),
0