Post Author: firstname.lastname@example.org
CA Forum: Authentication
I try to build up a universe with BO XI Designer. First I create a connection to connect Designer to my Oracle 10 Database. The User used by this connection has access to all my Oracle Schema. When I import all the table to build my universe, I can see all the tables from all the schema my user can access. I need to use table from two of these schemas to do my universe.
My probleme starts here. When I try to see the table values of the tables coming from the first schema, evey thing is working fine and I can see them. But when I try to see the table values of a table coming from the second one I got this message: Exception: DBD, ORA-00942, Table or view does not exists. I try to rename the table entering the Owner of the table and now I have the error: Exception: DBD, ORA-00903, Invalid table name.
Someone can help me to fix this problem?