Cognos Online Training by Quontra solutions

1
Contact info Call44 (0)20 3734 1498 / 99 Mail
info_at_quontrasolutions.co.uk
2
What is Cognos?

• Web Based Reporting Tool-Zero foot print( has a
  few client based
• components like Office plug-in)
• Allows user to create, modify, and distribute
  reports to user
• community.
• Allows user to schedule and burst reports
• We are licensed to run a few Cognos products of
  which these will be
• heavily used based on the User Role
• Query Studio allow you to create simple list
  reports, for casual or
• novice users
• Report Studio allows you to create more complex
  reports (prompts,
• advanced formatting, advanced charting, etc)
• Analysis Studio- multi dimensional analysis.
• Interfaces with the ODS/EDW system

3
Cognos Process Flow
Presentation Layer
Client Model Tools-Develop Models Publish
Content as Packages
ODS/ED/Other Data Sources
4
Demo

• Quick exploration of Query Studio and ( time
  permitting-Report Studio)

5
(No Transcript)
6
A list of recently used packages
Additional packages
7

• Toolbar contains most commonly used functions
• Main menu contains menu options and all functions

8

• Insert Data
• Select data from package
• Edit Data
• Change display of query items
• Change Layout
• Edit properties of your report
• Run Report
• Processing or preview data
• Export data in various formats
• Manage File
• Create and save report and view a report
  definition

9

• Package - A logical collection of data tables

10

• Query Subject - A single table that holds
  multiple Query Items
• Query Item - A field in the Query Subject table
  (Entity UID, ID, Name, etc.)
• Measure Quantitative data such as revenue or
  quantity

11

• Insert
• Single-click a query item and click the Insert
  button
• Double-click a query item
• Click and drag a query item
• Click and drag a query subject to add all of its
  query items

CTRLClick to select multiple items
12
Meet the Undo Button!!!

• Undo the last several things youve done
• Redo available

13
Data Element Dictionary

• Helpful resource available to users
• Structure mirrors data package hierarchy
• Data Packages highest level of data
  organization
• Query Subjects (equivalent to database table)
• Query Items (equivalent to database field)

14
Questions?
15
Thank You