Chapter 4. Data modeling: End to end 139
models and resources. They often needed to manipulate the models or the
underlying data directly to provide reports. This meant those within the business
who needed to make decisions had to rely on a limited set of static reports, which
were never really able to answer all their questions.
With the introduction of reporting tools such as IBM Cognos BI, these decision
makers can now access dynamic reports directly and, more importantly, the
underlying data in views that they can both understand and manipulate. The
ability to view these reports at any location and on a multitude of devices, while
still containing the latest information and data, finally allows these decision
makers to make valid and informed choices.
In this section we demonstrate how you can integrate the modeling processes
implemented within InfoSphere Warehouse with those contained within IBM
Cognos BI, showing how you can complete the modeling lifecycle and feed back
improvements to your logical, physical, and OLAP models in the process.
Its is worth noting that this section of the book is not intended to cover the entire
IBM Cognos BI product range, or to completely cover all aspects of producing a
Cognos report. The Redbooks publication IBM Cognos Business Intelligence
V10.1 Handbook, SG24-7912, covers these topics in greater detail.
4.5.1 Cognos Framework Manager
IBM Cognos Framework Manager is a metadata modeling tool for managing
access to a range of data sources and creating a common business model.
These data sources can include InfoSphere Warehouse cubing services, DB2
databases, and additional data sources which are not covered in this book.
140 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Figure 4-35 outlines the process within IBM Cognos Framework Manager of
creating a Cognos package that represents a business model.
Figure 4-35 IBM Cognos Frameworks Manager
Cognos Framework Manager
InfoSphere
Warehouse
Cubing
Services
InfoSphere
Warehouse
DB2
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.