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:
- Microsoft Excel spreadsheets (.xls files)
- Tab-delemeted files (.txt files)
- Comma-separated files (.csv files)
- XML data (.xml files)
To work with external data the administrator should first grant the
permission Allow External Data capability (under the Report Studio
capability) to report authors considering the report authors can already
access Report Studio and Business Insight Advanced (you cannot use
external data in Business Insight).
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.