cognos Module 3 filtering data

33 %
67 %
Information about cognos Module 3 filtering data
Technology

Published on March 8, 2014

Author: SandeepSharma65

Source: slideshare.net

Description

Cognos report training module 3

BI Administrators Fast Track Cognos Impromptu Cognos PowerPlay

Impromptu User

Module Objectives Filter reports by using Easy Filter functionality and by building filter expressions. Use prompts as a dynamic means of filtering reports. Create conditional formats to highlight exceptional data.

Easy Filtering Country Customer Type Country Customer Type Australia Independent Australia Independent Mass Marketer Mass Marketer Mass Marketer Mass Marketer Mass Marketer Mass Marketer Belgium Camping Chain Belgium Camping Chain Independent Independent Mass Marketer Mass Marketer Canada Camping Chain Canada Camping Chain GO Outlet GO Outlet Independent Independent Mass Marketer Mass Marketer Sports Chain Sports Chain Camping Chain Camping Chain Mass Marketer Mass Marketer Camping Chain Customer Name Customer Name Backwoods Equipment Backwoods Equipment OutBack Pty 1 OutBack Pty 1 OutBack Pty 3 OutBack Pty 3 Total Sales Total Sales $4,010.90 $4,010.90 $9,763.36 $9,763.36 OutBack Pty 4 OutBack Pty 4 Vacation Central 1 Vacation Central 1 OutBack Pty 2 OutBack Pty 2 OutBack Pty 1 OutBack Pty 1 OutBack Pty 4 OutBack Pty 4 Vacation Central 1 Vacation Central 1 Rock Steady 4 Rock Steady 4 Wilderness Wilderness Vacation Central 2 Vacation Central 2 Wally Mart 3 Wally Mart 3 Supras Camping Supras Camping GO Outlet Montreal GO Outlet Montreal Excellence en Montagne Excellence en Montagne Clear Valley Waters 2 Clear Valley Waters 2 Kay Mart 4 Kay Mart 4 Laperier Sportifs 5 Laperier Sportifs 5 New Wave Wilderness 2 New Wave Wilderness 2 Supras Camping Supras Camping $27,753.66 $27,753.66 $10,875.70 $10,875.70 $9,412.74 $9,412.74 $47,564.07 $47,564.07 $16,193.36 $16,193.36 $6,553.53 $6,553.53 $16,259.30 $16,259.30 $17,527.90 $17,527.90 $27,365.61 $27,365.61 $6,649.60 $6,649.60 $9,174.95 $9,174.95 $10,629.89 $10,629.89 $19,801.63 $19,801.63 $10,548.20 $10,548.20 $23,646.95 $23,646.95 $9,235.04 $9,235.04 $9,140.67 $9,140.67 $12,269.16 $12,269.16 $26,011.22 $26,011.22 Clear Valley Waters 3 Clear Valley Waters 3 Andes Camping $16,614.91 $16,614.91 $20,893.95 Step 1 Step 1 Select Data Item Select Data Item

Easy Filtering Country Customer Type Country Customer Type Australia Independent Australia Independent Mass Marketer Mass Marketer Customer Name Customer Name Backwoods Equipment Backwoods Equipment OutBack Pty 1 OutBack Pty 1 OutBack Pty 3 OutBack Pty 3 Total Sales Total Sales $4,010.90 $4,010.90 $9,763.36 $9,763.36 Step 2 Step 2 $27,753.66 $27,753.66 Click the Filter or 4Easy Filter OutBack Pty 4 $10,875.70 Click the Filter or Easy Filter OutBack Pty $10,875.70 Vacation Central 1 $9,412.74 Vacation Central 1 $9,412.74 Drop DownOutBack Pty 2 to Drop Marketer OutBack Pty 2 to Down Arrow Arrow Mass Marketer $47,564.07 Mass $47,564.07 Mass Marketer OutBack Pty 1 $16,193.36 Mass Expression $16,193.36 Build Marketer OutBack Pty 1 Build Expression 4 OutBack Pty 4 $6,553.53 OutBack Pty $6,553.53 Vacation Central 1 Vacation Central 1 Belgium Camping Chain Rock Steady 4 Belgium Camping Chain Rock Steady 4 Independent Wilderness Independent Wilderness Mass Marketer Vacation Central 2 Mass Marketer Vacation Central 2 Wally Mart 3 Wally Mart 3 Canada Camping Chain Supras Camping Canada Camping Chain Supras Camping GO Outlet GO Outlet Montreal GO Outlet GO Outlet Montreal Independent Excellence en Montagne Independent Excellence en Montagne Mass Marketer Clear Valley Waters 2 Mass Marketer Clear Valley Waters 2 Kay Mart 4 Kay Mart 4 Sports Chain Laperier Sportifs 5 Sports Chain Laperier Sportifs 5 Camping Chain New Wave Wilderness 2 Camping Chain New Wave Wilderness 2 Supras Camping Supras Camping Mass Marketer Clear Valley Waters 3 Mass Marketer Clear Valley Waters 3 Camping Chain Andes Camping Camping Chain Andes Camping Andes Camping $16,259.30 $16,259.30 $17,527.90 $17,527.90 $27,365.61 $27,365.61 $6,649.60 $6,649.60 $9,174.95 $9,174.95 $10,629.89 $10,629.89 $19,801.63 $19,801.63 $10,548.20 $10,548.20 $23,646.95 $23,646.95 $9,235.04 $9,235.04 $9,140.67 $9,140.67 $12,269.16 $12,269.16 $26,011.22 $26,011.22 $16,614.91 $16,614.91 $20,893.95 $20,893.95 $12,481.33

Easy Filtering Expression Logic Branch Cd =‘BOS’ OR Sale Amt > 1000 Branch Cd =‘BOS’ AND Sale Amt > 1000

 Filter a report using Easy Filtering techniques.

Building Filter Expressions

Security Information for Filters

 Filter a report using the Expression Editor.

Prompt Manager The Prompt Manager lists all prompts that have been created in the Report and indicates how they are referenced. Details regarding Cascading Prompts can be viewed in the Cascading Prompts dialog box.

Type In Prompts Filter Expression Prompt Definition Prompt Dialog

Picklist Prompts Catalog Picklist Report Picklist File Picklist Branch list.csv

Creating Picklist Prompts

Cascading Prompts Country.imr Select the Country Branch.imr Customer Invoice.imr Select the Country Select the Country Select the Branch Select the Branch Select the Customer

 Create a Cascading Picklist Prompt.

Conditional Formats Sales Amount > 3000

 Create and apply a Conditional Format.

Module Review Filtered reports by using Easy Filter functionality and by building filter expressions. Used prompts as a dynamic means of filtering reports. Created conditional formats to highlight exceptional data.

Add a comment

Related presentations

Related pages

Cognos 10.1 - Filtering a data Item or member - Report ...

Cognos 10.1 - Filtering a data Item or member ... I don't now exactly what is invalid the filter but I have 3 ... Populate table in Cognos report studio. 0 ...
Read more

OCFS Data Warehouse Reporting: PowerPlay - New York State ...

What is Cognos PowerPlay? PowerPlay is a data analysis tool that utilizes OLAP ... PowerPlay Module 3: ... PowerPlay Filtering Reports
Read more

Report Studio - Princeton University - Home

Filtering on a Single ... Cognos system outages and downtimes 3. Data loading ... Once logged into Cognos Connection (Cognos), Report Studio users will see ...
Read more

DataClarity Corporation - WF Course: IBM Cognos Report ...

An email has been sent to the email address associated with Your DataClarityCorp.com account. The email contains a verification code. Please enter your ...
Read more

IBM Cognos software - IBM - United States

Cognos Business Intelligence and Financial Performance Management software for better business decisions. All data, reports, ... IBM Analytics Technology ...
Read more

COGNOS Query Studio - Amazon Web Services

COGNOS_Query_Studio_GA.doc 3:08:31 PM 8/24/11 Page 3 of 34 Query Studio ... Filtering Data, Step by Step 1. Select the Edit Data menu item.
Read more

Template information: read and remove this page

... IBM Rational Insight Data Warehouse Module 3: IBM Rational ... The main purpose of Cognos Data Manager is to create data warehouses and data ...
Read more

IBM Cognos Proven Practices: IBM Cognos BI - Global ...

This document assumes experience with IBM Cognos Connection and IBM Cognos Report ... create 3 reports all based on the GO Data ... different filtering ...
Read more

Filter Date in Cognos 8 Report Studio - Toolbox for IT Groups

I'm new to Cognos and Report Studio. ... Cognos 8.3 Report Studio ... Data Center. Data Center. Development.
Read more