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

Importing data to Cognos 10.1 from CSV file

Started by Anna711, 12 Sep 2013 03:10:44 AM

Previous topic - Next topic

Anna711

Hello,

I need for the user to be able to import data to Cognos. Ideally I would like to build a "report" in reporting studio that will have a place to upload a CSV file and then will return the report itself. In other words, I would like to use the CSV file as a parameter. I also need the "report" to update the CSV data into the relevant table in Oracle DB.

I realize roughly how to do this: I need to create a procedure that will merge/insert the data from the CSV. Connect the procedure to the report via Framework manager and then return the report itself (that includes imported data and existing data). However I have no idea how to actually do this. Maybe someone can point me in the right direction (if this is even possible).

Sorry for the long question.
Thanks in advance!

MFGF

Hi,

It sounds very much like you're trying to somehow use Cognos BI as an ETL tool. In my experience this is not a good approach to take. I'd recommend you use an appropriate ETL process to import the csv data into Oracle, then use BI to report off the data from there.

Best regards,

MF.
Meep!