COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Data Modules => Topic started by: CoolP on 20 Feb 2018 12:53:48 AM

Title: Modify a data module source from file to a database table
Post by: CoolP on 20 Feb 2018 12:53:48 AM
Hi Gurus,


We did a PoC by uploading an excel file (limited data) and creating a data module out of it. We used the data module and created some dashboards.


We now want to modify the data module so that it can read out of a database (using Database Servers functionality). Can we achieve this? This would help us a great deal as we need not make any changes to the dashboard objects.


Thanks
CoolP
Title: Re: Modify a data module source from file to a database table
Post by: Kiran P on 20 Feb 2018 02:10:26 AM
Hi,

There is no direct way to change the source for a data module. What you can do is build another data module with database as the source, make sure all the column names match to the ones in your current excel based data module and then in your dashboard, relink your selected data source to the new one.

Thanks,
Kiran