Cognos Framework Manager

Framework Manager is a metadata modeling tool for IBM Cognos BI. Metadata is data about data. Metadata model represent the data to business users in a very simple way, which remove the complexity of data structure.

Framework Manager is a Windows-based developer tool used to accomplish the metadata modeling task. A Framework Manager model can derived data from more than one data sources.

A model structure manages data such a way which is useful for business users.
Example- a model defines business rules, data descriptions, data relationships, business dimensions and hierarchy, and administrative tasks.

The team involve in Framework Manager modeling should have knowledge of database structure and requirements of business users.

When metadata modeling is completed, package is created and then package is published.

Published package is available in IBM Cognos Connection which  makes metadata accessible to report authors. Each package must contain all the information that a specific user or group of users need to create reports.

Example- One package have human resource data and another package have sale data. User of each department can use specific package related to their departments.

Cognos Event Studio

IBM Cognos Event studio is the notification tool used to alert decision-maker in the organization, so that they can make timely and effective decisions on the occurrence of events.

Event studio used to create agent that monitor status changes, priority customers, to detect occurrence of business event, or any other factor which is important to organization or business.

When an event occurs in organization people are alerted to take required action.  Agent detect the event and perform the task like publish the detail to portal, deliver alert by email, run and distribute report based on events and monitor the status of the events.

Example of event- Cancellation of large order or return of product.

Cognos Analysis Studio

IBM Cognos Analysis Studio is the web-based analysis component within IBM Cognos Connection. User can explore, analyze and compare the dimensional data using Analysis Studio. Analysis Studio provides access to dimensional, OLAP( Online Analytical Processing) and DMR (Dimensional Modeled Relational) data sources.

You can use Analysis Studio to compare and manipulate data to understand the relation between data and its relative importance. You can view performance indicator of your business.

Example- revenue, growth, product cost, or top performer. Analysis Studio provides filter, calculations, sorting and drill up and drill down support you need for analysis.

Using Analysis Studio, you can perform following task-

• Find and focus on items which are important to your business.
• Understand the trends in the market.
• Compare the data, such as details to summaries, or actual results to budgeted results.
• Assess performance by focusing on the best or worst results.
• Establish relative importance using calculations such as rank or growth.
• Share your finding and analysis with management.

Analysis created in Analysis Studio can be opened in Report Studio and used to build professional reports.

Difference between Report Studio and Query Studio

Report Studio and Query Studio can be accessed from the cognos connection web portal. Report Studio is used to create sophisticated reports and charts with complex prompts and filters. Query Studio is used to create ad-hoc queries and simple reports and charts.

Report Studio has some special functionality like bursting, prompts and advance charts where Query Studio does not have these options.

Cognos Query Studio

Query studio is reporting tool used for creating simple queries and reports in IBM Cognos. Use of Query Studio is so easy any novice user can create report for business queries. Basically Query Studio is used for ad-hoc reports and it is the lighter version of Report Studio.

We can view data, author simple reports, change the report layout, filter and sort data, add formatting, and create charts with minimum steps. Query Studio can be also used to publish reports for audience who do not required complex layout or formatting.