Crn-framework Manager V1

COGNOS REPORTNET Framework Manager 1.1

R.Vijay Bhaskar DWH TEAM 2007

Center of Excellence Data Warehousing

Framework Manager Architecture Managing Projects Preparing Metadata Publish Metadata

Framework Manager Meta Data Modeling Tool Model – Business presentation of information Model is packaged and published to Report authors and Query users

Architecture – Framework Manager Architecture 1

User Interfaces

Architecture 2

User Interfaces

Framework Manager

FIREWAL L

FIREWAL L

FIREWAL L

Web Serve r

Framework Manager

Content Manager

Dispatcher

FIREWAL L

Web Server

Content Manager

Dispatcher

Order of Study Architecture Managing Projects Preparing Metadata Publish Metadata

Project? Set of models, packages and related information for maintaining and sharing information

Demo of Open Project, Project Page Components, Create Project

Project

Query Subject

Project

Namespac e

Import Metadata  Can import metadata from  RDBMS (DB2, Oracle, SQL Server)  SAP BW Data Sources  Existing Cognos ReportNet models  Architect Models and Impromptu Catalogs  Decision Stream Models  Third-party metadata sources  XML as a data source

Demo of Import Metadata

Data Source  A project, model, package can attach to multiple data sources  Objects with the same name from different sources cannot be imported under one namespace  Importing metadata automatically creates data source  Modeling can be done with multiple data sets and multi lingual data sources

For Oracle the Schema column is Case-Sensitive

Export Metadata  Export to a Common Warehouse Metamodel (CWM) file.  CWM is used for exchanging metadata between different DWH tools and repositories.  Output is an .xml file

Manage Projects Copy/Move/Rename/Delete Segments Links Repository Control

Segmenting Models Organize a project according to business rules and organizational requirements Share and reuse project information

Segments can be created at Folder or Namespace level

Linking Models Shortcut to existing project, segment, folder or namespace Help organize work across large projects Provides consistency Reuse Information Project 1 Go Sales Products

Project 2 Inventory Products

Any Change in Inventory Products, the changes will be reflected in Go Sales Products The project you link must have same languages and same design

Repository Control Visual Safe Source (VSS) Concurrent Version Systems (CVS)

Framework Manager Architecture Managing projects Preparing Metadata Publish Metadata

Preparing Metadata Verifying Relationships  Cardinality

Create Relationships Query Subjects  Prompt Control

Adding Business Rules  Calculation  Filter  Prompts  Session parameters Demo on all the above bulleted points

Preparing Metadata Relationships

Preparing Metadata - Query Subject

Prompt Control Prompt Types

Calculation Standalone Embedded

Filter Expression that satisfies the condition that rows or instances must meet to be retrieved for the query subject or report to which the filter is applied  Standalone  Embedded

 Prompt values to filter data

Filter on Indexed Column will be more efficient than a non-indexed

Parameter Map To create conditional query subjects that allow for substitution when the report is run

 For Example Company stores Product and Customer Information in both French and English, whereas Orders are stored in English only

Framework Manager Architecture Managing projects Preparing Metadata Publish Metadata

Package?  Subset of Query subjects and other objects defined in the project  To Create & Publish package  Verify  Set Governors  Controlling Access  Data  Object  Package

 Publish Demo of Packages

Verify package

Governors

Control Access

Publish Package

Questions/ Comments