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

Change data module source - issues

Started by K1245, 31 Jan 2023 07:40:10 AM

Previous topic - Next topic

K1245

Hi,

I'm trying to relink the existing data module to a new source(Cognos 11.1). I am able to do this using "Relink" option and get no Validation error but Cognos does not use the correct tables for the whole module. For a few tables, he connects to random tables and I can't figure out why.


Example_1:
The table name in the old data source: user . The table name in the new data source: t_user .  Cognos replaces tables correctly.
Example_2
The table name in the old data source: work. The table name in the new data source: t_work - Cognos does not link these two tables. It uses some random table t_customer which has similar columns.


Is there a way where I can manually fix this? For example, choose the existing table in the data module and point it to the right table.

bus_pass_man

I think you lucked out getting anything to work.   

I don't think I've read anywhere that IBM says it could magically figure out how to map tables of different names when it relinks. 

In FM you can remap model query subjects to use tables or columns of completely different names but that was a manual process.  I have not seen that functionality in data modules.

You will need to make sure the tables and columns of both schemas are the same.  My question is why are you trying to relink to a schema with different metadata?

I relinked a schema to something which has some, but not all, tables in common with another schema and I got validation errors for the tables which do not exist in the relinked schema and for columns which do not exist in tables which do exist.