168 Implementing an Advanced Application Using Processes, Rules, Events, and Reports
6.1 Overview of IBM Cognos Framework Manager
IBM Cognos Framework Manager is a metadata modeling tool that drives query generation
for IBM Cognos software. This client tool for Windows workstations allows a metadata
modeler to create a business representation and “friendly” view of the metadata for report
authors and business users, who generally do not understand the underlying structure and
names of objects, such as databases, schemas or catalogs, tables, and columns that are
used in a source data system. The tool helps hide the complex structure that is used to
access and represent the data by creating package definitions that can be used across
capabilities within IBM Cognos Business Intelligence.
A
package can contain the full contents of the model or a logical subset tailored for a specific
user community or line of business. The result is an environment where tables and column
names are presented in a meaningful and logical manner in the various authoring interfaces
for the target audience.
6.1.1 Data access strategies
IBM Cognos Business Intelligence can connect various sources of data, ranging from
transactional databases, data warehouses, data marts, online analytical processing (OLAP)
systems, enterprise resource planning (ERP) systems, to web services so that business
users can extract meaningful results and answer pressing questions. This capability is
powerful, but you also need to have a viable data access strategy to make these tools useful.
When evaluating data access strategies in context of the reporting requirements and the
desired user experience, consider the following questions:
򐂰 How fresh does the data need to be?
򐂰 Is the source appropriate for reporting?
򐂰 Are there interactivity requirements from the users?
򐂰 What are expected data volumes, especially considering data growth over time?
򐂰 Is the source data movable to another system or structure?
򐂰 Is this application going to be mission critical?
򐂰 Is the source system able to handle the load this application may generate?
Answering these types of questions can help you to determine the appropriate source
requirements.
For example, if your reporting requirement calls for minute-by-minute data and data is being
updated all the time, you will likely want a transactional source. However, if the reporting
requirement is less frequent, such as daily or weekly, you can offload your data to a data
warehouse or data mart. Regardless of the data source chosen, IBM Cognos Business
Intelligence is designed to optimize the query experience against all supported data sources.
IBM Cognos Query layer generates the queries in a manner that is suited to the capabilities of
the given source system.
Our warranty sample uses IBM DB2 Universal Database™ V9.7 as a transactional database
system and IBM Cognos Business Intelligence V10.1.1 Fix Pack 1 with Dynamic Query
mode. These choices match the requirements for transactional level reporting and for the use
of Business Insight, which allows for interaction with the results.
6.1.2 Metadata model
A model is a collection of metadata that includes physical information and business
information for one or more data sources.The construction of a metadata model supports the

Get Implementing an Advanced Application Using Processes, Rules, Events, and Reports now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.