COGNOS 10 SOFTWARE LEARNING MATERIAL

A package may contain multiple models   Data Source--- à Project-----Model/s-----Package   •         Tables in Database are called as Query Subjects in Cognos •         Columns in Database are called as Query Items in Cognos       Project Def: A project is a set of files that describes the metadata in one or more models •        A project contains well organized metadata defined according to the business rules •        It is a business/logical/metadata/presentation layer         Model Def: A model represents business requirements and data source •        A project can contain one or more models     Query Subject: •        Maps to the table in the data source •      ...

FM workflow process diagram: A windows based tool used to design metadata Models                        import Datasource------ à FM design and create the project Prepare the metadata project(Presentation layer)--Prepare  the project business view--Create & manage package---setup  security— Publish package---Content store(Metadata)---Reporting interface   Metadata source-Cognos Application •        Cognos impromptu •        Cognos 10.1 model •        Cognos Architect •        Decision stream •        Data Manager •        IBM Data Source   Third party metadata source: •        ERWIN •     ...

Framework Manager: •         FM is a windows based metadata modeling tool to build models for designing reports •         It is used to create projects •         Use FM to access the metadata from one or more data sources •         The data source may be homogenous ore heterogeneous •         When we are working in FM we work with the projects     •         Project includes model, namespace, query subject, query item, folders, shortcuts, parameter map, packages, data source, filters and calculations •         Project is a store in file system with extension .cpf ( Cognos Project File ) •         A project is a set of files that describes the metadata in one or more models • ...