Transcript 2008 Year in Review - LPA Software Solutions

The Webinar will begin at
12:00 pm Eastern
Audio – Webinar is using Webex
Integrated Voice, ensure your speakers
are turned on
Rich Chester
Director of Consulting
John Antonucci
Sr. Business Development Manager
Introduction to
IBM Cognos Workspace
Advanced
LPA Events Calendar
Upcoming Webinars:

7/26 @ 12:00 EST – What’s New in Cognos 10.2.1

8/1 @ 12:00 EST – Intro. to Predictive Analytics w/ SPSS Modeler

8/15 @ 12:00 EST – Customer Analytics using SPSS Modeler

8/29 @ 12:00 EST – Location Analytics using with ESRI Maps for Cognos
Previously Recorded Webinars Available at: http://www.lpa.com/resources/
» Cognos Business Intelligence
 What’s new in Cognos 10.2.1
 Introduction to Active Reports
 Location Analytics with Esri Maps for IBM Cognos
 Introduction to Cognos Dynamic Cubes
» SPSS Predictive Analytics
 Customer Analytics using SPSS Modeler
 Introduction to Predictive Analytics with SPSS Modeler
» TM1 Planning And Budgeting
 Smarter Planning and Budgeting with IBM Cognos TM1
Register here: http://www.lpa.com/events/
LPA Systems Confidential
2
IOD 2013
Early Bird: $1,895 USD per person – July 12 – September 13
Standard Fee: $2,195 USD per person - September 14 November 7
Save $100: Register for IOD 2013 with LPA
Just enter our promo code: G13LPASYS
LPA Systems Confidential
3
Founded in 2001
 Offices in Rochester, NY, Dallas, TX and Houston, TX
 Consultants located throughout U.S.
 Hundreds of active enterprise, mid-market and OEM clients
Partners
 IBM Premier Business Analytics Partner
 IBM Cognos, TM1, SPSS, and Big Data/Netezza
 Esri Silver Tier Partner
Extensive business analytics consulting experience
 2013 IBM Beacon Award Finalist
 100% IBM Business Analytics certified
 Tenured consultants with an average experience of 10+ years
 Wide variety of industry, functional and domain experience
 Expertise from Data Warehouse through Predictive Analytics with BI and
FPM in between
LPA Systems Confidential
4
LPA Business Analytics Offerings
Data
Warehousing /
Big Data
Business
Intelligence
Roadmap
Development
• Architecture & Design
• Implementation
Performance
Management
• Health Check
• Migration &
Upgrades
• SDK & Security
• Implementation
• Training
Advanced
Analytics
• IBM Cognos TM1
Planning / Budgeting
• Architecture & Design
• Health Check
• Migration & Upgrades
• Implementation
• Forecasting
• Predictive Analytics
• Esri Maps for Cognos
• BI Readiness
• Strategy & Roadmap
• Migration & Upgrade
planning
Authorized Reseller for IBM Business Analytics Software - Licensing & Renewals
LPA Systems Confidential
5
LPA Training Offerings
Cognos BI Course Offerings
Why LPA Training?

Report Studio* - 3 Days
 Location – Onsite
 Materials – High Quality,

Active Reports - 2 Days

Workspace Advanced* - 2 Days
*Customized with your Data

Workspace - 1 Day Course

Intro to Framework Manager – 1 Day

What's New in Cognos 10.2 - 2 Days

Esri Maps for IBM Cognos for End Users - 2
Days

Intro to Dynamic Cubes - 1 Day Course

Query Studio* - 1 Day Course

Analysis Studio* - 1 Day Course
 Price – Price/Student
 Trainer – LPA Consultant
 Schedule – To your needs
Contact: [email protected] with questions
Visit: http://www.lpa.com/services/training/
LPA Systems Confidential
6
Cognos Workspace Advanced
Licensed Users
Admin
 Everything below, plus:
• Framework Manager
• Administrative Console
Bi Prof
 Everything below, plus:
• Report Studio
• Event Studio
Advanced
Bus Author
Bus Author /
Analyst
Enhanced Consumer
Consumer
LPA Systems Confidential
 Everything below, plus:
• Cognos Workspace Advanced
• Cognos Insight
 Everything below, plus:
• Query Studio OR Analysis
Studio
 Everything below, plus:
• Active Reports
• Cognos Workspace
• Mobile
• View, run and schedule reports
• Answer prompts
• Use Cognos for MS Office
7
Agenda
» What is Cognos Workspace Advanced?
» How does it relate to Cognos Workspace?
» The User Interface
» Demonstration
» Questions & Answers
LPA Systems Confidential
8
What is IBM Cognos
Workspace Advanced?
» A Web-based tool…
» …which allows you to author reports and analyze data,
» …leveraging relational,
dimensional and external
data sources,
» …presenting information in
lists, crosstabs and/or charts,
» …invoked as a Studio to
create or edit new reports, or
» …from within an IBM Cognos
Workspace to perform advanced editing on a widget.
It is Report Studio Express Authoring Mode
highly enhanced & rebranded for
IBM Cognos 10
LPA Systems Confidential
9
Cognos Workspace Integration
» You can edit a Cognos Workspace report “widget” in
Cognos Workspace Advanced by selecting “Do
More…”
• The widget is opened in Cognos Workspace Advanced
• You can use the full power of CWA to customize the widget
• The widget can only be saved back to the original workspace
LPA Systems Confidential
10
Cognos Workspace Advanced
as an Authoring Studio
At a Glance: How the Studios Stack Up
Query Studio
Cognos Workspace Advanced
Report Studio
Can only have one query
Can have multiple queries, one per data
object (chart, list, etc.). No query
explorer or direct manipulation of queries
Can have multiple queries. Author has
full control. Can reuse across objects.
Can join, union, etc.
Simple Calculations
Complex calculations with limited
function library
Complex calculations with robust function
library
Default is a list report
Default could be list, crosstab or chart.
Can mix and match on report
Default could be list, crosstab, chart, map
or Active Report. Can mix and match
Generated prompts only (no
prompt page). Prompts dependent
on Framework Model definition
Generated prompts only (no prompt
page). Prompts dependent on
Framework Model definition
Highly customizable Prompt Page. Author
can override Framework Model definition
Simple Layout (chart and list or
crosstab)
Complex layout such as dashboards
Complex layout such as dashboards
Used largely for Ad-hoc analysis
Bridges the gap between Query Studio
and Report Studio
Used for Pixel Perfect Reporting
Reports can be edited in Query
Studio only. You can convert a
report to Report Studio, but once
its converted you can’t continue to
edit it in Query Studio
Reports can be edited in either Cognos
Workspace Advanced or Report Studio
interchangeably
Reports can be edited in either Cognos
Workspace Advanced or Report Studio
interchangeably
LPA Systems Confidential
11
Report Types
Cognos Workspace Advanced Supports Many
Types of Reports:
» Use List reports to show detailed information from your
data source, such as product lists and customer lists
» Use Crosstab reports to show information in a more
compact form than in a grouped list. For example,
create a crosstab report to show total sales by product
line generated by each sales representative
» Use Chart reports to show information graphically. You
can use Cognos Workspace Advanced to create many
chart types, including column, bar, area, and line charts
Maps and Active Reports cannot be authored in Cognos Workspace Advanced
LPA Systems Confidential
12
The User Interface
Tool Bar
Content
Pane
Page Navigation
LPA Systems Confidential
Work Area
Properties Pane
13
Preview Mode
» By default you see live data as you develop your report
• When using CWA as a “studio” you can switch to Page Design view which
looks and feels like IBM Cognos Report Studio
• You cannot switch to Page Design mode when editing an IBM Cognos
Workspace widget
Live
Data
LPA Systems Confidential
14
Properties Pane
» The ancestor button allows
you to select a an object and
view or edit its properties.
» The report objects are
hierarchical in nature exactly
as in IBM Cognos Report
Studio.
ANCESTOR
BUTTON
PROPERTY SHEET
LPA Systems Confidential
15
Insertable Objects
The Content Pane contains two
tabs:
• Source Tab – Shows the contents of
the package selected for the report
• Toolbox Tab – Shows the tools that
are available for use (i.e. objects for
use on a page)
You add objects to a report by
dragging them from the
insertable objects pane to the
work area.
LPA Systems Confidential
16
IBM Cognos Workspace Advanced
Demonstration
LPA Systems Confidential
17
IBM Cognos Workspace Advanced
Questions?
LPA Systems Confidential
18
IBM Cognos Workspace Advanced
Thank you!
Rich Chester
Director of Consulting
[email protected]
John Antonucci
Sr. Business Development Manager
[email protected]
LPA Systems Confidential
19