Flat File format as data source in cognos

[swarupa]

Hi Everyone,

I have requirement that there are two flat files as data sources, I need to develop report combination of few columns from one flat file & few from other. I got one file in EBCDIC format.

Now my question is that whether cognos reads EBCDIC format file? or it reads only CSV file with comma/tab?
Can anyone please answer..

[schrotty]

Hi,

Sorry I didn't understand your Question?!

EBCDIC is a character set and csv-file is a file wherein you use a character set?!
Maybe you'll need to encode your EBCDIC-file to another character set.

schrotty

[swarupa]

OK. Let me re-frame my question.
I have requirement of designing a cognos report which should pull a combination of data from two different flat files and a DB table.
eg: two columns from text file1 and 2 columns from text file2 and 1 column from DB. (there is common key columns in each file/table).
Can you please confirm is it possible in cognos? If so please suggest steps.

[Lynn]

OK. Let me re-frame my question.
I have requirement of designing a cognos report which should pull a combination of data from two different flat files and a DB table.
eg: two columns from text file1 and 2 columns from text file2 and 1 column from DB. (there is common key columns in each file/table).
Can you please confirm is it possible in cognos? If so please suggest steps.

Yes, you can create a Framework Manager model that combines data from different data sources, as long as they are supported sources.

You will need to create a data source connection for each of your sources. Refer to Chapter 8 of the administration and security guide for details on different types of data sources and connections.

You should take the size of these flat files into consideration as there may be performance implications. There are also performance ramifications by reporting across disparate sources since separate queries are required to retrieve the data which the Cognos server then needs to put together.

Once you have data source connections defined you can refer to the framework manager user guide for details on creating your model. You'll likely need to post more specific questions about modeling for your scenario in order to get more specific responses.

I would highly recommend professional training for Framework Manager.