IBM Cognos Framework Manager is the metadata model development environment for IBM Cognos BI. It is a Windows-based client tool that you can use to create simplified business presentations of metadata that are derived from one or more data sources. With IBM Cognos Framework Manager, you can publish that metadata to IBM Cognos BI in the form of a package. You can also use it to add dimensional information to relational data sources that allow for OLAP-style queries. This type of model is known as a Dimensionally ModeledRelational (DMR) model.
Reporting requirements and data access strategies
Before creating an IBM Cognos Framework Manager project, it is important for the modeler understand the reporting requirements. This knowledge allows the modeler to make better decisions regarding data access strategies, metadata model design, and report package delivery to IBM Cognos BI.
Reviewing sample or mock reports that meet the business needs is a good start, followed by identifying which data sources contain the information that is required. The modeler also needs to consider the following types of questions:
The answers to these types of questions can affect dramatically the data access strategy that you choose.
For example, if you require up-to-the-minute data in your reports, then going with the transactional database might be the only option. This choice, however, can increase the metadata modeling work drastically, because transactional systems are typically quite complex. If the intervals of data freshness are greater, by the hour day, week, or month for example, then using data warehouses or data marts that are refreshed at the required interval is a better choice.
IBM Cognos bases its algorithms around industry-standard star schema designs that consist of fact tables and related dimension tables. For larger warehouses that have slower response times due to the sheer volume of data, consider using some form of materialization in which views are created with pre-aggregated results.
You can also use OLAP sources, which can by pass the requirement for metadata modeling in IBM Cognos Framework Manager. This method can reduce response times dramatically as well, because the data is already calculated and aggregated. OLAP sources provide the added bonus of dimensional analysis and reporting, which allow users to navigate through the data and to apply powerful dimensional functions.
Also ask the following questions before creating an IBM Cognos Framework Manager project:
These types of questions allow you to investigate what can be done at the data source level rather than in the IBM Cognos Framework Manager model. As a general rule, it is better to off-load to the extract, transform, and load(ETL)process that populates a warehouse to avoid that processing time when running reports. In addition, it is better to push more processing to the data source, such as filters, sorting, grouping, and so on, because vendor databases are typically optimized for those types of operations.
Give special attention to planning and scope before you embark on a business intelligence project to avoid rework down the road.
Before we continue, we need to define a metadata model in the context of IBM Cognos BI. A metadata model is a collection of metadata that is imported from a database. It describes the tables, columns, and relationships in the database. This metadata is published as a package to the IBM Cognos BI portal, and is used to generate appropriate SQL requests to the database when reports or analysis are run.
In most cases, the metadata is altered in IBM Cognos Framework Manager to ensure predictable results when reporting and to meet reporting and presentation requirements. The model can hide the structural complexity of underlying data sources and provide more control over how data is presented to IBM Cognos BI users. You can also choose which data to display to users and how that data is organized. The overall goal of modeling the metadata is to create a model that provides predictable results and an easy-to-use view of the metadata for authors and analysts.
The IBM Cognos Framework Manager UI
The user interface includes the following panes:
All panes can be hidden except the Project Info pane, which is the main work area. To restore a pane, use the View menu or use the toggles on the toolbar. You can also detach and rearrange the Project Viewer, Properties, and Tools panes.
In IBM Cognos Framework Manager, there are several objects with which you interact in either the Project Viewer or the Project Info panes. For simplicity, we examine the objects in the Properties pane, with the exception of relationships.
The Project Viewer pane includes the following reporting objects:
Model objects in the Project Viewer pane
Data Source query subjects
Model query subjects
You might also work with the following types of objects:
The Data Source folder
The Parameter Maps folder
The Packages folder
IBM Cognos Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|IBM DB2 Interview Questions||Data Warehousing Interview Questions|
|SQL Interview Questions||IBM Cloud Computing Infrastructure Architect V1 Interview Questions|
|Framework7 Interview Questions||IBM BPM Interview Questions|
|IBM Cognos TM1 Interview Questions||Cognos ReportNet (CRN) Interview Questions|
|Structured Query Report (SQR) Interview Questions||IBM DataPower Interview Questions|
Ibm Cognos Tutorial
Introduction To Ibm Cognos Business Intelligence
Overview Of The Ibm Cognos Business Intelligence Architecture
Business Scenario And Personas Used In This
Create Reporting Packages With Ibm Cognos Framework Manager
Business Intelligence Simplified: An Overview
Individual And Collaborative User Experience
Self Service Interface For Business Users
Actionable Analytics Everywhere
Enterprise Ready Performance And Scalability
Ibm Cognos System Administration
Integrating Ibm Cognos Bi With Ibm Cognos Business Analytics Solutions
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.