Ever thought of supplementing enterprise data with your own or personal data file? This will allow you to create a report using an external file that contains data which is not a part of the enterprise data that your Business Intelligence tool regularly accesses. With IBM Cognos 10 BI you can link this type of scenario data with enterprise data and create a professional report easily.
The following types of files can be used:
Before importing external data, the report author should start with an existing Cognos package. Then, the report author will have to import the external data file and link the columns in the external data file to those of the enterprise data (this can be a relational or dimensional data source). As a next step, the report authors need to publish a new package that enables the users to create reports using both external data and enterprise data.
Here is a video that explains the process of using external data in IBM Cognos 10 Report Studio:
The following types of files can be used:
- Microsoft Excel spreadsheets (.xls files)
- Tab-delemeted files (.txt files)
- Comma-separated files (.csv files)
- XML data (.xml files)
Here is a video that explains the process of using external data in IBM Cognos 10 Report Studio:
Hi Rajib, Thanks for this great post. At this moment I have this need ... to get an Excel file and loaded in Report Studio but when i do so it didn’t bring to me all the data in the file, just the first row. Maybe this is explain in detail in the video but i can’t see it, could you please explain a little bit more? Thanks in advance.
ReplyDeleteJaime Garzon.