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?.
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.
Thanks MFGF,
i think move the data into real database is a good idea.i will follow that.
sekhar!!!