Tuesday, March 12, 2013

Using Fully Qualified Table Names in OBIEE

Problem Description

1.  You have created a read-only user on your Oracle production database, to use as a reporting user that OBIEE can connect as.
2.  You've used the Admin Tool to successfully map the tables in
3.  However as soon as you try and do anything more you get an error ORA-00942 table or view does not exist

Why ?

Solution :   OBIEE needs to be told to qualify the table names with the Schema Owner.

Go back to the Connection Pool definition and tick the box "Use Fully Qualified Table Names", and save the repo.

Problem Solved.



No comments: