1 Reply Latest reply: Mar 27, 2012 6:26 AM by DavidGreenfield RSS

    AWM Error while Enabling MViews

    RaviR
      Hi Experts,

      I have created a Product Dim on SH Schema. Below is the detailed Information

      Levels:
      Total_Product
      Product_Category
      Product_SubCategory
      Product

      Heirarchy:
      PROD_ROLLUP

      I have mapped all the attributes and made sure that in the Materialized Views tab all the checklist is in the Green Status. I then Maintained the Dimension and is able see the data on right-click event.

      However, when i tried to enable the Materialized View option. It gave me following error.
      Your metadata changes have been saved, with the following errors
      CREATE MATERIALIZED VIEW "SH"."CB$PRODUCT_DIM_PROD_ROLLUP"
      ORA-00979: not a GROUP BY expression

      I have SH users privileges.
      Role: OLAP_USER
      System Priveleges: Create Dimension. Create Materialized View, Query Rewrite.


      Please Help.......

      Regards,*
      RaviR*

      Edited by: Ravi R on Mar 22, 2012 2:02 AM