Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Table Not found in Schema

  1. #1
    Join Date
    Mar 2008
    Posts
    18

    Default Table Not found in Schema

    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.
    -SEE#YEM

  2. #2

    Default

    First make sure that ur connection is correct & then make the tables in the dimension "public".
    Mr. Manasa Ranjan Panda
    Hyderabad,INDIA
    E.Mail-:manasaranjan.panda@gmail.com
    M.No-+91 9392923252

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.