Cognos is business intelligence and performance management software suit designed for users to extract corporate data, analyse and extract reports. It is user-friendly and facility to explore big-data information. components that model uses framework manager, report studio like query studio, analysis studio, event studio and reports. It is a fast and efficient technique to deliver multidimensional business intelligence data.
It is a web based component used to create simple reports (or) Adhoc reports (or) self service reports (or) Instant reports. It is end users (client) studio. The full query is types of reports can be generated by using query studio. 1. List report 2. Crosstab report 3. Chart report. Ex: Create a simple list report with order year, order month, qty and revenue by using query studio. •Open the IE browser to access the query studio. •Enter the following URL http://IBM Cognos •From welcome page select “Query my data” (query studio) •Select the package go sales and retailers. •Drag order year, order month, qty •Drop on work area.
It is a web based component used to create professional reports or more advanced reports or complete reports. Use browser to access report studio. The following types of reports can be created by using report studio List reports Cross tab reports Chart report s Repeater table reports Dash boards Active reports Balance reports to create dashboards Map reports ……etc. Folders are used to organize the reports. There are two types of folders in cognos Public folder (default) My folder A report which is saved in a public folder can be accessed by any folder A report which is saved in my folder is specific to that particular user
Schema: A schema is nothing but a collection of objects. Designing a dWH is nothing but designing the schema. A data ware house tables are contain dimensional tables and fact tables. Database models follows dimensional modeling to design dWH schema Dimensional modeling is a process of creating dimensional tables and fact tables with proper relation Types of schemas: Star schema Snow flake schema Galaxy schema (or)integrated schema (or) constellation schema
It is nothing but a condition to restrict the data to be displayed on the report There are two types of filters 1. Model filter 2. Report filter Model filter: If a filter is created at the time of designing model then it is called a model filter Model filters are reusable Report filter: A filter which is created at the time of generating the report is called a report filter Report filter is specific to that particular report only
And Also Issues Interview Questions How to’s For More Cognos Free Tutorials Please Visit: http://bit.ly/1sSGSAb