COGNOS 10 SOFTWARE LEARNING MATERIAL

Cognos 10.1 is a complete web based dynamic business intelligence reporting solution from IBM •          A BI is a broad category of applications & technology which allows the users to query, reporting and analyzing the data from databases •          A BI provides following core functionalities      * Query      *Reporting      * Analysis      * Distribution       BI 80/20 Concept: In BI environment 80% of the development time is allocated to design model/interface to fulfill the user requirements and 20% of the time is allocated to create reports Cognos Architect/Modeler: 5-6 years exp Report Developers/Testers       Servers: 1)Application Server: Cognos Server 2)Web Server: IIS/Apache 3)Database Server: Content Store 4)Authentication Pro...

Cognos 10.1 is a complete web based dynamic business intelligence reporting solution from IBM •          A BI is a broad category of applications & technology which allows the users to query, reporting and analyzing the data from databases •          A BI provides following core functionalities      * Query      *Reporting      * Analysis      * Distribution BI 80/20 Concept: In BI environment 80% of the development time is allocated to design model/interface to fulfill the user requirements and 20% of the time is allocated to create reports Cognos Architect/Modeler: 5-6 years exp Report Developers/Testers   Servers: 1)Application Server: Cognos Server 2)Web Server: IIS/Apache 3)Database Server: Content Store 4)Authentication Provider:      AD (Act...

COGNOS 10.1 Cognos Architect: •        Is responsible to understand metadata and security •        Report Requirement Template •        Design the interface(Projects) •        In most of the cases the tables which are in DWH are not directly used to generate the reports

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...