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

Modify a data module source from file to a database table

Started by CoolP, 20 Feb 2018 12:53:48 AM

Previous topic - Next topic

CoolP

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
CoolP
Aspiring BI/Cognos Professional

Kiran P

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