Summary advisor question

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Mon, 20 Aug 2001 10:02:22 -0700
Message-ID: <F001.00371303.20010820101241@fatcity.com>

Is anyone using this (or dbms_olap.recommend_mv) successfully.

I"m getting a
ORA-30479: Summary Advisor errorQSM-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 Received on Mon Aug 20 2001 - 12:02:22 CDT