Hello,
I am having a problem refreshing a universe in Designer. Some underlying Sybase tables were changed (i.e. new fields added) but the table names were not changed. However, when I try to refresh the universe in Designer, I get a message that some tables were not found and ALL of the tables are flagged. I am positive that no table name was changed and that all of the tables in the universe still exist.
I tried creating a new universe from the same tables and noticed that when Designer brings the tables into the universe, the table names are now prefixed by the database name and owner name (i.e. database name.ownername.table name) whereas in the original universe, the table names stood alone. So, I figured that when I try to refresh the universe, Designer is looking for tables without the database name.owner name prefix and not finding them even though they are there. Has anyone ever experienced this? The original universe was developed under Sybase 10 and BO 4.0x and when we upgraded to Sybase 11 and BO 4.1, the universe and reports still worked. I am not sure if this is a function of Sybase 11 or of Business Objects.
Does anyone have any suggestions?
I have seen this before, but I am using Microsoft SQL Server. The answer for me was to modify my database parameter file in BusinessObjects\ODBC (in my case it was sqlsrven.prm file), so that the owner of the tables doesn’t show up at all. That is what I have done. I’m not sure which file Sybase will be using. By looking my my BusinessObject\ODBC directory I don’t see one for Sybase. Maybe someone else on this list can help with that part. Once you know which file to use, look for the parameter:
OWNER=N
Yours is probably set to Y. Changing this to N will cause the owner not to show up in Designer. I hope this helps.
Judith,
Is your universe still pointing to the same database ?I think you need to check the connect string in Universe File->Parameters .If its still pointing to the same database ,just do a refresh structure ,you should get message 'Refresh Out of Date Columns ’ and on saying ‘yes’ all tables should be modified .This will be only when the schema and names of those tables are not changed .If they are changed then you need to do rename table and change owner/tablename there and again you should go for refresh structure …If it asks ‘Do you want to remove joins ?’ say ‘No’ to be on the safer side …
Thanks,
Vikas
Judith :
I am having a problem refreshing a universe in Designer. Some underlying Sybase tables were changed (i.e. new fields added) but the table names were not changed. However, when I try to refresh the universe in Designer, I get a message that some tables were not found and ALL of the tables are flagged. I am positive that no table name was changed and that all of the tables in the universe still exist.
I tried creating a new universe from the same tables and noticed that when Designer brings the tables into the universe, the table names are now prefixed by the database name and owner name (i.e. database name.ownername.table name) whereas in the original universe, the table names stood alone. So, I figured that when I try to refresh the universe, Designer is looking for tables without the database name.owner name prefix and not finding them even though they are there. Has anyone ever experienced this? The original universe was developed under Sybase 10 and BO 4.0x and when we upgraded to Sybase 11 and BO 4.1, the universe and reports still worked. I am not sure if this is a function of Sybase 11 or of Business Objects.
Does anyone have any suggestions?
Marian,
Thanks for for the info. I knew there was something that controlled how table names appeared in the universe. I found that I also had to change the QUALIFIER parameter to N.
Thanks again – that saved me a lot of re-design work! Judith Dotson
I have seen this before, but I am using Microsoft SQL Server. The answer for me was to modify my database parameter file in BusinessObjects\ODBC (in my case it was sqlsrven.prm file), so that the owner of the tables doesn’t show up at all. That is what I have done. I’m not sure which file Sybase will be using. By looking my my BusinessObject\ODBC directory I don’t see one for Sybase. Maybe someone else on this list can help with that part. Once you know which file to use, look for the parameter:
OWNER=N
Yours is probably set to Y. Changing this to N will cause the owner not to show up in Designer. I hope this helps.