Description

The Framework Manager tool allows you to create “package” models which will be used by users to create reports with Cognos 10 BI studios. Through the different stages of package creation, you will learn, using a database, to present business data to users.

Who is this training for ?

For whom ?

IT project managers, consultants or technical administrators.

Prerequisites

Training objectives

Follow the steps for creating a Framework Manager project

Choose a data source and import the tables necessary to create a "package"

Prepare the metadata that will be used in the reports and test them

Publish and set package security Prepare DMR dimensional packages

Training program

• Introduction to Framework Manager and Cognos 10 BI tools
  • Overall view of the architecture and the different studios.
  • The stages of creating a Framework Manager project.
  • Structure of the database and definition objects.
  • Establish the differences between transactional databases and reporting.
  • Taking into consideration good practices.
  • Exchanges Questions to multiple choice.
• Create a Framework Manager project file
  • Discover the interface and the different objects.
  • Create a new data source and import metadata.
  • Define the different layers of the project file.
  • Exercise: Multiple choice questions.
  • Create a new project.
  • Choose your data source.
  • Import the tables in the physical layer.
• Prepare metadata
  • Import and create query subjects.
  • Edit query item properties.
  • Edit and set relationships between query subjects and their cardinalities.
  • Create specific calculations.
  • Define parameter tables and apply them in macros.
  • Define filters.
  • Exercise : Set query item properties.
  • Usage and aggregation.
  • Relationships between tables.
  • Modify a query subject.
  • Expression calculation of multiple query elements.
  • Test the query.
• Prepare and publish packages
  • Create a package from business layers.
  • Prepare combined query subjects and dimensional views.
  • Specify determinants.
  • Exercise: Create a package.
  • Include the business layer.
  • Publish to the portal.
• Prepare DMR dimensional packages
  • Defining dimension objects, hierarchies, and attributes.
  • Create measures and apply scope.
  • Exercise: Create a multidimensional model.
  • Define dimensions and their levels.
  • Define measurements.
• Implement security
  • Cognos Security Principles 10.
  • Secure access to the package.
  • Define access to objects and data.
  • Exercise : Apply security to a package.
  • Define rights on objects and data.
• Managing OLAP cubes
  • Creating a Framework Manager project using an OLAP source.
  • Differences between Framework dimensional model and OLAP cube.