Business intelligence metadata

When you import BI metadata into the metadata repository, you can study the components of BI reports and BI models and how they are related. You can track database tables and columns that the BI reports reference, and the jobs that use the columns.

Business intelligence reporting is the means of publishing, distributing, and reviewing data results and information. Analysts must be able to understand the meaning and authenticity of BI reports, which are generated against data sources such as marts or warehouses. You might need to know when the content that feeds a BI report was last updated, and which InfoSphere® DataStage® and QualityStage® jobs or other processes were sequenced during the update. Lineage and analysis reports in InfoSphere Information Governance Catalog can display the complete data flows that transform and populate the source data that underlies the BI reports, thus satisfying requirements for data governance and data trust.

For a full list of supported BI bridges, see Supported import bridges and versions. Not all BI bridges import BI reports.

BI reports are the report templates that are created within BI reporting tools such as the following:
  • IBM® Cognos® Report Studio or Query Studio
  • SAP BusinessObjects Desktop Intelligence, Web Intelligence, or Crystal Reports
  • Oracle Business Intelligence Report Publisher
  • MicroStrategy
  • Microsoft SQL Server Report Builder and Report Designer
BI report assets are also created in the metadata repository when you use the IBM Cognos TM1 bridge to import views.

BI reports include BI queries and query members, which source and aggregate the information to display from BI models. BI models are created within modeling tools such as Cognos Framework Manager and BusinessObjects Designer.

In InfoSphere Information Governance Catalog, you can assign stewards and glossary terms to business intelligence reports, and edit the business names and descriptions of the reports.

For best results when you import BI metadata, familiarize yourself with the following concepts and functionality:
To answer this question Read this
How do I ensure that my imports are efficient and successful? Importing and managing assets by using InfoSphere Metadata Asset Manager
Which assets are imported and used by suite tools, and how are they organized? Common metadata assets
Which BI assets are imported and used? Business intelligence assets
How do I view and report on the relationships between the imported BI metadata and the InfoSphere DataStage and QualityStage jobs that use the database tables and columns that reports are based on?. Reporting data lineage and business lineage