COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Data Modules => Topic started by: icepick on 01 Feb 2021 10:33:41 PM

Title: Howto change datamodule when source table name changed?
Post by: icepick on 01 Feb 2021 10:33:41 PM
Hi,

I have created a data module and I am running into an issue that the source table name has changed. So the old situation was;

Tablename: Addresses_old
Columns: Name, address, city

New situation;
Tablename: Addresses_new
Columns: Name, address, city

So the columns are identical, just the tablename changed. How can I make this change show in the data module?

I tried changing the ID for the specific column in the advanced property tab but this doesn't seem to do anything. Any ideas?
Title: Re: Howto change datamodule when source table name changed?
Post by: srmoure on 14 Dec 2021 11:43:30 PM
I am looking for the same information. I know it's possible because I saw a video of someone doing it. Unfortunately, I cannot find the video :-(
Title: Re: Howto change datamodule when source table name changed?
Post by: MFGF on 15 Dec 2021 08:48:47 AM
Quote from: srmoure on 14 Dec 2021 11:43:30 PM
I am looking for the same information. I know it's possible because I saw a video of someone doing it. Unfortunately, I cannot find the video :-(

Does this post from bus_pass_man help?

https://www.cognoise.com/index.php/topic,36660.0.html

Cheers!

MF.
Title: Re: Howto change datamodule when source table name changed?
Post by: wdv72 on 30 May 2022 06:46:28 AM
I did it as follows.

MAKE A COPY OF YOUR MODULE AS BACKUP FIRST!!!

Open datamodule. Press buttons 'CTRL Q /' at the same time. Source code will appear. Copy to an external editor like Notepad++. Search and replace the old table text with new table.

Copy the changed code, edit the code in the datamodule, select the old code and replace with the edited code.