Are you sure that no records were rejected during your cube load? The total number of rejected records will show up in olapsys.XML_LOAD_LOG table.
Check these three things:
(1). Do the following type of query between your FACT table and each olap dimension to confirm that there are no "extra" dimension members (or keys) in fact table which are not present in your olap dimensions.
SELECT PRODUCT_ID FROM FACT_TABLE MINUS select product_id from TABLE(OLAP_TABLE(
*'SCHEMA.AWNAME DURATION QUERY',null,null,*
*'DIMENSION product_id as varchar2(250) from PRODUCT'))*
(2). Also check the number of dimension members for each dimension in the AW. Maybe one of the dimensions was not loaded properly and has less members in it.
exec DBMS_AW.Execute('AW Attach schema.aw_name RO'); exec DBMS_AW.Execute('SHOW OBJ(DIMMAX ''dim_name'')'); -- two single quotes
*.... repeat for all dimensions in this AW*
This will give you an idea, how many dimension values exist in your AW.
(3). In the AWM cube viewer, make sure that you have selected the right dimension members.