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!
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.