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.
My guess is that this is due to some problem with the dimension mappings. If you can open up an SR and provide the XML, then it should be easy to resolve. (I am assuming you are using the Oracle demo SH schema.)