Skip to main content

Different objects in cognos



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

•       A query subject uses an SQL to retrieve the data from data sources

Query Item:

•       Represents column of the database table

•       A query subject contains the query items

 

Namespace:

•       A namespace is a container which holds query subjects

•       It uniquely identifies query subjects and query items

•       We can import different database into separate namespace to avoid duplicate names

 

 

DM1

T1                                                           DWH

T2         

T5

                   

DM2

T3

T4

T5                         Wrong

 

 

Generally project will have 3 layers

DB layer

Business layer

Preparation layer

But we will talk about only 2 layers

-DB Layer

-Preparation Layer

 

Folders:

Folders are used to organize query subject and

other objects based on function or subject

•        In model same objects can not be accepted in different folders

 

Model

                                    Folder1

                                                            Emp

                                    Folder2

                                                            Emp X Not accepted

                                   Namespace1

                                                                 Folder1        Emp

                       Namespace2          

 

                                                                   Folder2      Emp

 

 

Shortcuts:These are logical pointers to an alternate table name

•         These are used to resolve loops

                          Customer

                    Cid    Loop      Cmid

                 

          Order                   Countries

                                Conid

Cust-------------àCountries

Order---------Countries  shortcut

Loop occurs when more than one path exists from one table to another table

In database

 

Parameter Map:

•         It is used to substitute runtime objects

Joins:

•         A join is a relationship that explains how the data of one query subject relates to data of another query subject

•         The relationships can be defined using inner/outer joins

Package:

•         A package contains a set of query subjects and other related metadata which is available for publishing to report authors/developers

 

 

Preparing Business View:

•         Creating namespace

•         Model based query subjects

•         Filters/calculations as per the business requirements

Model:

Represents it belongs to the database                        Represents it  is created on the interface        


Create & Manage package:

•         Include

•         Exclude

•         Hide

Setup Security:

•         Package level security

•         Object level security

•         Data level security

Publish Package: It is moving the package to the content store

Content Store: It is a relational container which is used store package.

•         It holds report specifications, connection information, user account Information

 

 

 

Usage property of query items:

              

              Identifier---à Indexed/Date fields

 

 

 

              Attribute---Descriptive

 

 

                            Fact-----Numeric values

 

Note: To change usage property select query

item in the project viewer

-            Go to properties

-            Usage – Change it to fact if query item is non addictive

 

 

Labels:

Comments

Post a Comment

Popular posts from this blog

Data modeling

Data Modeling: Model: Model is business representation of information in one or more data sources OLTP                                    DWH   Model          Model                 Model E-R Model    (modify wih ETL)       Dimensional model (Design based on              (Design based on facts and Measures) Entities&Relationships)   Dimensional Modeling: Is a design methodology for designing a DWH It consists of following 3phases to design the Database 1)Conceptual Modeling: •          Understanding the requirements •     ...
Post a Comment
Read more

FM workflow diagram

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 •     ...
Post a Comment
Read more

Book on IBM Cognos 10 written by me-

Here is a book written by me on IBM Business Intelligence Tool COGNOS which is published at the following link- http://www.amazon.com/dp/B00KKSVGPA/ref=rdr_kindle_ext_tmb Anyone who is having prior knowledge in database like oracle can easily learn to develop the business reports by following the screenshot assisted examples. This book will be a good resource for the students who wish to self learn IBM Cognos software.
Post a Comment
Read more