IBM Cognos Framework Manager

Name: IBM Cognos Framework Manager
Rating: 3.8 (223 reviews)

Whether you're a beginner or a pro, there is always something new to learn in Framework Manager

Created byPackt Publishing

Last updated 11/2017

English

English [Auto],

What you'll learn

Become comfortable navigating around the Cognos BI application.
Understand the different applications in Cognos and when to use Query Studio or Report Studio
Create ad-hoc reports to achieve quick, on-the-fly reporting requirements
Master complex reports that can be used by multiple users for multiple requirements
Create charts, graphs, and dashboards for macro views of microdata… And drill into that microdata
Build professional-looking BI web applications
Automate redundant manual reporting tasks, to reduce reliance on Excel and get more time back in your day

Course content

5 sections • 29 lectures • 1h 36m total length

The Course Overview1:20
This video provides an overview of the entire course.
Navigating2:35
How do we find our way around Framework Manager?
Modeling Layers2:40
Every Framework project or model has two or three layers, what are they?
Start with the database layer and its importance
Discuss the transformation layer and best practices
Apply some finishing touches on the presentation layer
Database Layer3:18
What do we do with the database layer?
Transformation Layer3:20
What do we do with the transformation layer?
Presentation Layer4:49
What do we do with the presentation layer?

Namespaces4:10
What are namespaces?
They are similar to folders are used to facilitate security applications
Create groups in Cognos Administration
Restrict access to namespaces by group or role
Folders2:40
Let’s organize our data with folders.
Model Advisor3:14
Let’s QA our data using the Model Advisor.
Importing Data Sources2:27
More than one database? Let’s add another data source.
Joins and Cardinality3:49
Let’s get an understanding on where to apply joins and cardinality inside the model.

Creating the Three Layers3:31
Starting with a clean slate, what do we do?
Adding Data to the Data Layer3:26
We’ll learn how to add a table.
Transforming the Data3:36
We have raw data, let’s start how we can transform it.
Adding Items to the Presentation Layer3:43
Let’s finalize our data in the presentation layer.
Adding Filters2:33
We need to filter the data going to Report Studio and Workspace Advanced, how do we fix that?
Create some new filters or edit existing ones
Learn when and why to use filters
Include macros in the filters
Adding Calculations3:09
Need to add some custom fields? No problem.
Formatting Query Items4:14
Not all fields were created equal, let’s format the fields for how our report writers need them.

Creating Packages3:24
We need to create a new package, what do we do?
Create a new package by right clicking on the Packages area and clicking new package
Select some queries to publish inside the package
Learn some different options when publishing queries
Publishing Packages2:42
Now it’s time to publish the package
Editing Projects4:27
Already have an existing model? Let’s edit it.
Model Advisor2:54
As we edit our model, how do we QA our work?
Analyze the new objects we added
Analyze any new relationships
Finally, prior to publishing our package we will review again
Transaction History2:50
How do we debut errors or review what we have previously done?
Answer- transaction history
Review our transaction history
Learn how to read and correct any bad prior transactions

Users, Groups, and Roles4:11
We need to organize our Cognos users, what do we do?
Answer- group the users into various groups and roles
Let’s add users to various groups/roles
Discuss best practices with Cognos and Active Directory
Filters3:39
We need to filter the data before it can get to the report developers.
Macros2:57
What about dynamic filtering?
Use macros based on user ID’s, groups, or roles
Learn how to filter based on macros
Learn how to see what macros are picked up on our user ID
Package Security3:08
What if we need to secure our data at the package level?
Discuss package security concepts
Show you how to override package permissions
Add some groups/user to those overrides
Object Security4:09
You can also go one level deeper with security by securing objects inside a package.
Look at some best practices with object security
Secure various types of objects in the model
Discuss ways to test the security application was successful
Data Security3:39
Sometimes package and object security aren’t enough, you need data security.

Requirements

Requires some basic knowledge of SQL and the end reporting goals of the organization.

Description

Framework Manager, part of the IBM Cognos Business Intelligence suite, allows users to model data to facilitate report development and delivery. Framework Manager acts as the middleware between the database and report-writing tools such as Workspace Advanced and Report Studio. While Framework Manager can appear to be very technical and hard to understand, at its core, it's a very simple application that just requires some basic knowledge of SQL and the end reporting goals of the organization.

In this series, you'll learn how to navigate and master the components of a model or package. (Knowing your way around is crucial to understanding the application.) Then you'll design, build, deploy, and test your models. Finally, you'll apply security to the model; otherwise, users would have open access to all tables and fields published in it.

The goal of this course is to make Framework Manager easy and fast to learn. While becoming an expert takes time, this series is a great springboard into further developing or improving models that may exist in your organization.

About the Author :

Aaron Solar

With involvement in both manufacturing and service industries across multiple sectors, Aaron has 20+ years of BI, financial system, accounting, and business intelligence experience. His depth of experience from IT & MIS demands continual process improvement and automation within departmental operations as well as zero tolerance for inaccuracies in management systems. Aaron is currently a consultant for Aronson LLC, a firm based in Rockville, MD.

Specialties: Cognos Business Intelligence (BI): Query Studio, Workspace Advanced, Report Studio, Framework Manager. Cognos Impromptu. Deltek Costpoint, Deltek GCS Premier, QuickBooks, MS Dynamics NAV/Navision, Ross Systems, Crystal Reports, MS Access, SQL Server, MySQL, Oracle, Adobe Creative Suite, Joomla, WordPress, X-Cart, and so on.

Who this course is for:

This course is for anyone who requires getting up-to-speed quickly with using and maintaining various models in Framework Manager.

IBM Cognos Framework Manager

What you'll learn

Explore related topics

Course content

Getting Started6 lectures • 18min

Framework Manager Concepts5 lectures • 16min

Building Blocks7 lectures • 24min

Packages and Advanced Concepts5 lectures • 16min

Framework Security6 lectures • 22min

Requirements

Description

Who this course is for: