This discussion is archived
3 Replies Latest reply: Jan 26, 2013 10:43 AM by 939753 RSS

OLAP_TABLE view not working after migration from 10g to 11g (OLAP AWM)

939753 Newbie
Currently Being Moderated
We have created views using OLAP_TABLE on Analytical Workspace in 10g.

They were working fine in10g. However in 11g it throws error.

ORA 36891: ... SHSH4.HIERDIM Can not be used in LIMITMAP HIERARCHY cluase.

Steps FOLLWOED 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),
GRANSKADE DECIMAL
);
/


CREATE TYPE bg_SILUETT_GF_table AS TABLE OF bg_SILUETT_GF_type;
/


CREATE OR REPLACE VIEW Korrekt_handlagda_arenden_vw AS
SELECT TID,TID_NIVA,GRANSKADE,TID_FLDR, TID_HIER
FROM TABLE(OLAP_TABLE(
'SILUETT_GF DURATION QUERY',
'bg_SILUETT_GF_table',
'',
'DIMENSION TID FROM SH_TID WITH HIERARCHY SHSH4.HIERDIM
ATTRIBUTE TID_NIVA FROM SHSH4.LVLLABFRM
ATTRIBUTE TID_FLDR FROM SHSH4.PARENT
ATTRIBUTE TID_HIER FROM SHSH4.HIERDIM
MEASURE GRANSKADE FROM SH_GRANSKADE'))
MODEL
DIMENSION BY (TID)
MEASURES (TID_NIVA,GRANSKADE,TID_FLDR, TID_HIER)
RULES UPDATE SEQUENTIAL ORDER ();

/

IF we remove 'WITH HIERARCHY SHSH4.HIERDIM' and ATTRIBUTE clause then it shows result. But values for TID_NIVA ,TID_FLDR and TID_HIER are missing.

Could you please advice.

Thanks.

Legend

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