Course : IBM Cognos Analytics V11/V12, Framework Manager
Practical course - 3d
- 21h00 - Ref. CGH
|
Download in PDF format
Share this course by email
 | Follow the steps to create a Framework Manager project |
| Select a data source and import the tables needed to create a package |
| Prepare the metadata to be used in reports and test it |
| Publish and Configure Package Security |
| Preparing DMR Dimensional Packages |
Intended audience
IT project managers, consultants, designers/modelers.
Prerequisites
Knowledge of relational databases (tables, SQL, joins, and modeling). Knowledge of the Cognos Analytics 11/12 reporting feature.
Practical details
Please enter the instructional description here
Course schedule
1 Introduction to Framework Manager and IBM Cognos Analytics v12 Tools
- General Product Overview.
- Architecture and Components.
- Exploring Framework Manager.
- Exploring the Framework Manager project.
Hands-on work
Explore a complete Framework Manager project.
2 Create a Framework Manager project file
- Exploring the interface and the various objects.
- Creating a new data source and importing metadata.
- Definition of the different layers in the project file.
Hands-on work
Create a new project: select a data source, import the tables into the physical layer.
3 Model the data and identify related data structures
- Objectives.
- The Role of the IBM Cognos Metadata Model.
- Distinction between operational databases and reporting (decision-making) databases.
- Identification of the functions of operational bases.
- Identification of errors encountered with operational databases.
- Study of the fundamentals of reporting (star schema).
- Creating a star schema.
- Analysis of data from operational databases and reporting (decision-support) databases.
- Analysis of fact tables and dimension tables.
- Identifying errors encountered with star-shaped diagrams.
- Definition of joins between tables, cardinality, and whether fields are required or optional.
- Analysis of OLAP data structures and objects: dimensions, hierarchies, levels, attributes, and cells.
- Identifying strategies for accessing data.
Hands-on work
Analyze data from operational databases and OLAP structures.
4 Define Modeling Requirements and Strategies
- Objectives.
- Key recommendations for data modeling.
- BI analysis and definition of data requirements.
- Organizing interviews with users and authors to identify their needs.
- Identify the reports that will be replaced by IBM Cognos reports.
- Edit the source physical database on which the work is being done.
- Identifying the business areas that need attention.
- Step-by-Step Modeling.
- Iterative modeling.
Hands-on work
Identify data sources based on the requirements definition.
5 Create a baseline for a Framework Manager project
- Objectives.
- Introduction to Framework Manager.
- Relational Model and Dimensional Model (DMR).
- Definition and exploration of a Framework Manager project and its structure: model, data sources, parameters, and packages.
- Definition and exploration of the components of a Framework Manager project in relational and dimensional models.
Hands-on work
Review the existing final project. Create a baseline project.
6 Extend the model
- Extension of the model.
- Importing Additional Data.
Hands-on work
Extend the Framework Manager (GO Operational) model by adding tables. Rearrange the diagram.
7 Preparing Reusable Metadata
- Framework Manager: Data Preparation Phase.
- Checking the joints.
- Required cardinality option.
- Checking the properties of fields/query items/
Hands-on work
GO Operational Model: Check the joins. Check and modify the properties of the fields/query items.
8 Modeling for Predictable Results – Identifying Anomalies in Reports
- Objectives.
- Metadata modeling step in the workflow.
- Defining queries on a single fact table.
- Defining queries that query multiple fact tables.
- Definition of Stitch queries: unique subqueries for each fact table, which are then merged based on common attributes from shared dimensions.
- Using Cardinality in IBM Cognos.
Hands-on work
Model results, identify and correct errors.
9 Identify the bottlenecks in reporting
- Two tables with no context and the same dimensions.
- Generation of unsolicited query outputs (full outer joins) in cases where tables are incorrectly identified as fact tables.
- Ambiguous joins.
- Using tools to analyze the model: model verification, Model Advisor, Model in Freehand.
Hands-on work
Identify two fact tables that lack a common dimension context. Identify queries that generate unintended results.
10 Modeling Virtual Star Schemas
- Modifying the query subjects of data sources.
- Creating a "query subject" template.
- From Operational Reporting Models to Decision-Making Reporting Models.
- Modeling Virtual Star Schemas.
- Why would anyone want to model star schemas?
Hands-on work
Model a star topology.
11 Use query subjects, modify queries, and consolidate metadata using virtual objects
- The benefits of using query subject models (table views).
- Using query subject templates to override and replace joins.
- Merge ORDER_HEADER and ORDER_DETAILS into a single query subject model to resolve ambiguities.
- Identifying Recursive Joins.
- The problem of recursive joins with subject query templates (shortcuts).
- Modifying joins.
- Why consolidate metadata? Example of consolidation: PRODUCT_LINE, PRODUCT_TYPE, PRODUCT.
- Creation of a virtual entity and virtual dimensions.
Hands-on work
Identify ambiguous joins. Use query subject models to create aliases and resolve ambiguous functional paths. Create a "sale fact" query subject model. Modify the joins.
12 Add calculations and filters to the model
- Creating calculated fields.
- Creating predefined filters.
- Creating settings and macros.
- Implementing a Time Dimension: Analysis of the model when the Time dimension does not exist. The need for a Time dimension.
- Create a presentation view: Populate a presentation view.
- Implement security at the framework level: The three levels of security (authentication, the Cognos namespace, capabilities, and UI profiles).
- DMR Dimensional Model: Creating Analysis Objects
- Manage OLAP Data Sources
- Use session settings, prompt macros, and security macro functions
Hands-on work
Create nested calculations in the model. Create nested and standalone filters in the model. Create a calculated field in a specific language; create parameter tables and session parameters. Implement a Time dimension. Resolve multiple ambiguous joins. Specify determinants on the Time dimension. Create a presentation view. Create analysis objects and edit metadata. Use custom session parameters. Dynamically modify the connection to the data source. Create prompt macros to filter data.
PARTICIPANTS
IT project managers, consultants, designers/modelers.
PREREQUISITES
Knowledge of relational databases (tables, SQL, joins, and modeling). Knowledge of the Cognos Analytics 11/12 reporting feature.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
IT project managers, consultants, designers/modelers.
PREREQUISITES
Knowledge of relational databases (tables, SQL, joins, and modeling). Knowledge of the Cognos Analytics 11/12 reporting feature.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Dernières places
Date garantie en présentiel ou à distance
Session garantie
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.