Table Names in Universe

Hi,

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:

  1. How can I get the view to refresh?
  2. 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.

Marian Cooney
HBO & Company
Malvern, PA


Listserv Archives (BOB member since 2002-06-25)

Marian,

try creating public synonyms for all tables. No owner prefix is needed in that way.

regards,
Jeroen Noordeman


Listserv Archives (BOB member since 2002-06-25)

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


Listserv Archives (BOB member since 2002-06-25)

“Cooney, Marian” wrote:

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.

Good luck!


Listserv Archives (BOB member since 2002-06-25)

Marian,

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:

[RDBMS]
(GENERAL)
STG= STSRVen
SORT_BY_NO=NO
GROUPBYCOL=NO
EXT_JOIN=YES
LEFT_OUTER=$*
RIGHT_OUTER=*$
CONCAT=+
UNION=UNION
INTERSECT=
MINUS=
OWNER=N
QUALIFIER=N
COMMA=+’ '+
REFRESH_COLUMNS_TYPE=Q
CHECK_OWNER_STATE=N
CHECK_QUALIFIER_STATE=N
KEY_INFO_SUPPORTED=Y
OUTERJOINS_GENERATION=USUAL

Manoj

______________________________ Reply Separator _________________________________

Author: Business Objects Query Tool BUSOB-L@LISTSERV.AOL.COM at INTERNET

Date: 12/15/1998 11:25 AM

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


Listserv Archives (BOB member since 2002-06-25)

Manoj - thanks very much!!!

Marian


Listserv Archives (BOB member since 2002-06-25)

Michael,

Thanks for your reply - I found that parameter file late Tuesday afternoon, and it worked.

Marian


Listserv Archives (BOB member since 2002-06-25)