If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Catalog object ownership change

Started by slylock, 23 Nov 2009 09:19:20 AM

Previous topic - Next topic

slylock

I developed a catalog which points to an Informix datasource. The tables in the database were owned by various groups and so had different prefixes for the tables (alpha.customers, beta.products, gamma.order_hist) and this is the way they showed up in the catalog (although you could qualify the tables with less detail which would remove that prefix). We have moved the system to SQL Server where dbo is the owner of all the objects, however when looking at the objects in the catalog, it still retains the reference to the original table owner ... this really causes a problem/confusion when working on joining (new) tables...is there a way (utility or other method) to rename the object owner reference in the catalog? I don't want to rebuild the catalog from scratch using the new SQL db as the source just to eliminate the invalid name references.

slylock

think I got it....updating the impromptu.ini file with "Schema Leveling Mode=1" gives you access to a hidden feature which allows you to modify the object owner info.