Wednesday, September 16, 2015

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.