Is anyone using this (or dbms_olap.recommend_mv) successfully.
 
I"m getting a
ORA-30479: Summary Advisor error
QSM-00511: invalid fact-tables specified in fact-filter
 
after RTFM and battling with it for a week, i've come to the experts.  I've got a simple time table and create a time dimension, the PK are in place for all tables and the FK in place for the few tables i'm trying to get this to work on.
 
on aix 8.1.7.1
 
thanks, joe

Reply via email to