I’m looking for some help. I have a universe pointing to an Oracle 7.3 database. Each table just has the table name - no owner - and everything is working fine. I am in the process of porting this universe to SQL Server. All of the tables are there, and I have no problem accessing the data through the universe (view column values) or in reports. However, I made a change to a view, and when I tried to refresh the structure was told that the selected table was not found. I tried to refresh the structure on other tables, and got the same error. If I put dbo in as the owner of the table, the refresh structure works fine. However, this does not work on the view.
My questions are:
How can I get the view to refresh?
Is there anyway I can refresh the overall structure WITHOUT putting dbo in as the owner of the tables.
I really want to be able to use the same universe with Oracle and SQL Server with the only change being the connection. Any help would be greatly appreciated.
Thanks for your suggestion - but I don’t think that SQL Server has public synonyms. I tried granting select on a table and the view to public but that still didn’t work.
Thanks for your suggestion - but I don’t think that SQL Server has public synonyms. I tried granting select on a table and the view to public but that still didn’t work.
Marian
Look in your *.prm file in the database directory under BusinessObjects – mine is Oracle, yours will be Sql Server or something like that. Change the line that says ‘Owner=Y’ to ‘Owner=N’. You might also need to change ‘Qualifier=Y’ to ‘Qualifier=N’. This will remove checking for table owners in BusinessObjects.
If you are using ODBC then go to ODBC folder in C:\program files\Businessobjects directory or whichever directory you have set up Business object client in. Change the file SQlSrven.prm to read OWNER = N and QUALIFIER = N as follows:
Thanks for your suggestion - but I don’t think that SQL Server has public synonyms. I tried granting select on a table and the view to public but that still didn’t work.