3 Replies Latest reply: Jan 26, 2013 12:43 PM by user5799514 RSS

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

    user5799514
      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.