Cognos Course Content

IBM Cognos Report Studio: Author Professional Reports Fundamentals

• Examine Report Studio and its interface
• Explore different report types
• Create a simple, sorted, and formatted report
• Explore how data items are added to queries

Create List Reports

• Format, group, and sort list reports
• Describe options for aggregating data
• Create a multi-fact query
• Create a report with repeated data

Focus Reports Using Filters

• Create filters to narrow the focus of reports
• Examine detail and summary filters
• Determine when to apply filters on aggregate data

Create Crosstab Reports

• Format and sort crosstab reports
• Convert a list to a crosstab
• Create complex crosstabs using drag and drop functionality
• Create crosstabs using unrelated data items

Present Data Graphically

• Create charts containing peer and nested items
• Add context to charts
• Create and reuse custom chart palettes
• Present key data in a single dashboard report

Focus Reports Using Prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt items
• Customize prompts to facilitate users’ choices
• Navigate between pages
• Display users’ prompt selections in the report

Extend Reports Using Calculations

• Create calculations based on data in the data source
• Add run-time information to the reports
• Create expressions using functions

Use Additional Report Building Techniques

• Reuse objects within the same report
• Share layout components among separate reports
• Discuss report templates
• Add pages to a report
• Choose options to handle reports with no available data

Customize Reports with Conditional Formatting

• Create multi-lingual reports
• Highlight exceptional data
• Show and hide data
• conditionally render objects in reports

Drill-Through From One Report to Another

• Let users navigate from a specific report to a target report
• Pass parameter values to filter the data in drill-through targets

Drill-through Definitions

• Parameter-driven drill through
• Steps to enable drill-through access for a package
• Drill through Assistant

Enhance Report Layout

• Force page breaks in reports
• Modify existing report structures
• Apply horizontal formatting
• Specify print options for PDF reports
• Combine data containers displaying data from different queries
• Format data and report objects

IBM Cognos Report Studio: Author Professional Reports Advanced

Create Query Models

• Build query models and then connect them to the report layout
• Add filters and prompts to a report using the query model
• Edit an SQL statement to author custom queries

Create Query Reports Based on Relationships

• Create reports by merging query results
• Create reports by joining queries
• Combine data containers based on relationships from different queries
• Create query containers containing a single data value

Distribute Reports through Bursting

• Distribute reports using bursting
• create burst keys
• Identify report recipients and data items using burst tables
• Distribute reports using email and IBM Cognos Connection

Design Effective Prompts

• Control report displays using prompts
• Specify conditional formatting values using prompts
• Create a report that formats based on prompts selection
• Create a sorted and filtered report based on prompt selection

Enhance User Interaction with HTML

• Create tooltips that clarify report data
• Create a popup window that contains prompts
• Send emails using links in a report

Create Additional Advanced Reports

• Create a report that displays summarized data before detailed data
• Highlight alternate rows in a list report
• Create a report using an external data file
• Use single data items to summarize report information

Examine the Report Specification

• Examine the report specification structure
• Save and edit reports locally
• Discuss considerations for modifying a report specification

IBM Cognos Report Studio: Author Active Reports

Introduction to IBM Cognos Active Reports

• Discuss the value of active reports
• Examine an active report and its controls
• Convert an existing report to an active report
• Debug and save an active report
• Explore interactive properties

Use Filter and Select in Active Reports

• Distinguish between filter and select
• Examine decks and cards
• Explore properties to use in active reports
• Examine master-detail relationships and decks

Use Advanced Features with Active Reports

• Drill through on an active report
• Drill up an down on an active report
• Create cascading prompts in an active report

Query studio:

• Types of reports
• Query studio templates
• User interface
• Operation on list report
• Data formatting
• Expand and collapse group
• Custom groups
• Filters and calculations
• Conditional formatting

 Analysis studio:

• Introduction to analysis studio
• Types of analysis
• Rows columns and context
• Suppress zeros and nulls
• Filters and calculations
• Top and bottom rows
• Sorting
• Drill up and drill down
• Convert to chart
• Replacing columns and rows
• Open in report studio

Event studio:

• Benefits of event studio
• Process flow
• Specify event condition
• Tasks
• Task execution rules
• Agents
• Scheduling an agent

Framework Manager

IBM Cognos Framework Manager: Design Metadata Models

 Create a Baseline Project

• Examine the IBM Cognos BI and Framework Manager Workflow processes
• Define a project and its structure
• Describe the Framework Manager environment
• Create a baseline project
• Enhance the model with additional metadata

Prepare Reusable Metadata

• Verify relationships and query item properties
• Ensure efficient filters by configuring prompt properties

Calculations and Filters

• Use calculations to create commonly-needed query items for authors
• Use static filters to reduce the data returned
• Use macros and parameters in calculations and filters to dynamically control the data

Returned

Specify Determinants

• Use determinants to specify multiple levels of granularity and prevent double-counting

Create the Presentation View

• Identify the dimensions associated with a fact table
• Identify conformed vs. non-conformed dimensions
• Create star schema groupings to provide authors with logical groupings of query subjects

Work with Different Query Subject Types

• Identify key differences and recommendations for using data source, model, and stored

Procedure query subjects

• Identify the effects on generated SQL when modifying query subjects, SQL settings and Relationships

Set Security in Framework Manager

• Examine the IBM Cognos BI security environment
• Restrict access to packages
• Create and apply security filters
•  Restrict access to objects in the model

Create Analysis Objects

• Apply dimensional information to relational Metadata to enable OLAP-style queries
• Sort members for presentation and predictability
• Advanced Generated SQL Concepts and Complex Queries
• Governors that affect SQL generation
• Stitch query SQL
• Conformed and non-conformed dimensions in generated SQL
• Multi-fact/multi-grain stitch query SQL
• Variances in Report Studio generated SQL
• Dimensionally modeled relational SQL generation
• Cross join SQL
• Various results sets for multi-fact queries

Use Advanced Parameterization Techniques in Framework Manger

• Identify session and model parameters
• Leverage session, model, and custom parameters
• Create prompt macros
• Leverage macro functions associated with security

Model Maintenance and Extensibility

• Perform basic maintenance and management on a model
• Remap metadata to another source
• Import and link a second data source
• Run scripts to automate or update a model
• View lineage
• Create a model report

Optimize and Tune Framework Manager Models

• Identify and implement techniques to optimize and tune your Framework Manager models Work in a Multi-modeler Environment
• Implement repository control
• Segment and link a project
• Branch a project and merge results

Manage OLAP Data Sources

•  Connect to an OLAP data source (cube) in a Framework Manager project
• Publish an OLAP model
• Publish a model with multiple OLAP data sources
• Publish a model with an OLAP data source and a relational data source

Manage Framework Manager Packages

• Specify package languages and function sets
• Control model versioning
• Nest packages

IBM Cognos BI Administration

• Describe IBM Cognos architecture at a high level
• Define IBM Cognos groups and roles
• Explain how to extend IBM Cognos BI

Introduction to IBM Cognos BI Administration

• Describe the role of the Administrator in relation to the IBM Cognos BI administration workflow process.
• Describe the role of IBM Cognos Administration and IBM Cognos Configuration user interface components

Identify IBM Cognos BI Architecture

• Identify features of the IBM Cognos BI architecture
• Identify an example of Cognos BI request processing
• Performance planning and installation options and configurations
• Perform IBM Cognos BI on a single machine

Secure the IBM Cognos BI Environment

• Identify the IBM Cognos BI security model
• Define authentication and authorization in IBM Cognos BI.
• Identify security policies
• Secure administrative capabilities (access to functionality)
• Specify security settings after installation.
• Implement security in IBM Cognos Framework Manager and IBM Cognos Transformer

Administer the IBM Cognos BI Server Environment

• Overview of administrative tasks that can be performed in IBM Cognos Administration
• Monitor system metrics
• Manage dispatchers and services
• Tune server performance
• Identify issues while troubleshooting the server environment
• Formulate the IBM Cognos BI backup strategy

Manage Run Activities

• Manage current, past, and upcoming run activities
• Manage schedules

Manage Content in IBM Cognos Administration

• Add and manage a data source
• Distribute data and create a distribution list and contacts
• Deploy IBM Cognos BI content
• Maintain the IBM Cognos BI content store
• Customize the appearance of IBM Cognos BI

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us