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.