Skip to main content

Introduction to cognos



IBM COGNOS

  SQL Query

 User Business Query---àInterface/Gateway---DWH/DM

Reports

 

 

 Business Model:

Contains user requirements

                      SQL Interface           OLAP Interface(Project in cognos)

 Oracle              DW                BI Tool-Cognos

 

Types of OLAP

•       DOLAP (Desktop)

•       ROLAP (Relational)

•       MOLAP (Multidimensional/Hierarchical)

•       HOLAP (Hybrid)-ROLAP+MOLAP

  Cube/MDDB           ROLAP/Table     

                                             
 Cube / Multidimensional

       Year

 Quarter

 Month

    

 OLAP: An OLAP is a technology/specification

which allows the users in retrieving the data

from data sources like RDBMS,Cubes

1)DOLAP: DOLAP is used to query the data from the sources which are constructed by using any of the desktop databases like D-Base, FoxPro, MS-Access, Excel, Clipper etc;

 

2)ROLAP: It is used to query the data from the relational sources like Teradata, Oracle, SQL Server

•       It do not supports data sources like cubes

3)MOLAP: It is used to query the data from multidimensional data sources like cubes

4)HOLAP: It combines the properties of ROLAP and MOLAP. By using HOLAP technology, we can query the data from relational sources as well as multidimensional sources

Ex: Cognos – Supports ROLAP + MOLAP  

 

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