PDA

View Full Version : Table Not found in Schema



seeyem
10-23-2008, 03:36 PM
Its a very interesting issue where on JDBC explorer it is able to fetch tables from the schema but when i create a cube it does throw an error indicating that table doesn't exist in the schema. Its a confusing error because due to that i was not able to create a dim tables.

Error: Fact table "f_prod" does not exist in database schema "dw_bidw".

I am using admin login ie root to connect to and it does have all the privs assigned to it.

any help would be greatly apprecaited.

Manasa_InfoAxon
10-24-2008, 02:27 AM
First make sure that ur connection is correct & then make the tables in the dimension "public".