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

creating model from flat files

Started by Raj, 04 Jun 2015 04:30:03 AM

Previous topic - Next topic

Raj

How we will create a model in framework manager from the flat files i.e the data is in csv and xls format. How can we get the data in FM and how to give the relation between them?.

MFGF

Quote from: sekhar1988 on 04 Jun 2015 04:30:03 AM
How we will create a model in framework manager from the flat files i.e the data is in csv and xls format. How can we get the data in FM and how to give the relation between them?.

It's really not a good idea to do this. Cognos BI is designed to work over tables in a relational database, and/or OLAP cubes. Flat files do not have the ability to have indexes defined, and do not have embedded functions and a query optimizer like a relational database does.

If you really need to keep the data in flat files, you could use either an ODBC Text driver or ODBC for Excel. Don't do it, though. Move the data into a real database.

MF.
Meep!

Raj

Thanks MFGF,
   i think move the data into real database is a good idea.i will follow that.


sekhar!!!