cognos8qs

8/7/2019 Cognos8QS

1/60

BusinessObjects XIBusinessObjects XI

Cognos 8Query Studio

8/7/2019 Cognos8QS

2/60

integration * intelligence * insight

Query Studio:Query Studio:

Query Studio is the reporting tool for creating simple queries and

reports in Cognos 8, the Web-based reporting solution.

Use Query Studio to:

explore the corporate information that is available to you

create ad hoc reports that can be viewed by others

customize ad hoc reports that have been saved

compare and analyze data

8/7/2019 Cognos8QS

3/60


Using Query Studio:Using Query Studio:

8/7/2019 Cognos8QS

4/60


Using Query Studio:Using Query Studio:

8/7/2019 Cognos8QS

5/60


Create an Ad Hoc ReportCreate an Ad Hoc Report

You can create a new report by inserting items from a package

into an empty report.

8/7/2019 Cognos8QS

6/60


Open Existing Ad Hoc Reports:Open Existing Ad Hoc Reports:

You can open an existing report to: view the most current data in the report

make changes to the report

use it as the basis of a new report

Open the report in Query

Studio by clicking the report

link or the Edit with Query

Studio icon.

Click the Run with

Options button to

open the report

with the Report

Viewer tool.

8/7/2019 Cognos8QS

7/60


Add Data to Ad Hoc Reports:Add Data to Ad Hoc Reports:

You can add data to an empty report by choosing the report items fromthe package.

You can expand the scope of an existing report by inserting additionalreport items, or you can focus on specific data by removingunnecessary report items.

8/7/2019 Cognos8QS

8/60


Save Ad Hoc Reports:Save Ad Hoc Reports:

Save your reports to preserve any changes. You can also save a report using a different name or location to

use it as the basis of a new report.

8/7/2019 Cognos8QS

9/60


View Data in Ad Hoc Reports:View Data in Ad Hoc Reports:

You can open a report in Report Viewer to look at the most recent datafrom the data source.

You can also look at the most recent data while you are editing thereport in Query Studio.

HTML Report in EnglishPDF Report in German

8/7/2019 Cognos8QS

10/60


Print Ad Hoc Reports:Print Ad Hoc Reports:

Print your report to obtain a paper copy.

You can print a report directly from Query Studio, or from CognosConnection.

8/7/2019 Cognos8QS

11/60


Understand Report Types:Understand Report Types:

Use different report types to look at data in different ways or toanswer different business questions.

List Report Grouped List Report

Crosstab Report

8/7/2019 Cognos8QS

12/60


Examine Charting:Examine Charting:

Create a chart to present information graphically. A report requires at least one measure and non-measure to

produce a chart.

Pie Chart (100% Stacked)

This chart contains one non-numericreport item (Product line).

8/7/2019 Cognos8QS

13/60


CREATING REPORTS USING QUERY STUDIO

8/7/2019 Cognos8QS

14/60


Display Data With List Report:Display Data With List Report:

Create a list report to show information in a list, such as productsor customers.

A list report shows data in rows and columns.

8/7/2019 Cognos8QS

15/60


Create Grouped List Report:Create Grouped List Report:

Group a list report to suppress duplicate values.

You can organize the grouped data by row headings or sectionheadings.

Data Grouped by Row Headings

Data Grouped by Section Headings

8/7/2019 Cognos8QS

16/60


Expand and Collapse Data Groups:Expand and Collapse Data Groups:

You can expand or collapse grouped data in a report to show moreor less detail.

Fully expanded grouped report

Grouped report collapsed one level

Grouped report collapsed two levels

Grouped report collapsed three levels

8/7/2019 Cognos8QS

17/60

8/7/2019 Cognos8QS

18/60


Swap rows and columnsSwap rows and columns

You can interchange rows and columns in a crosstab, a chartbased on a crosstab, or both. For example, if you have a crosstabreport that has few rows and many columns, you can swap therows and columns to make the report easier to read.

If you have multiple rows or columns in a crosstab report, theoutermost rows become the outermost columns, and theoutermost columns become the outermost rows.

Crosstab Report Before Swapping

Crosstab Report after Swapping

8/7/2019 Cognos8QS

19/60


Sort Data in Ad Hoc Reports:Sort Data in Ad Hoc Reports:

You can sort your data in either ascending or descendingalphabetical or numeric order.

When sorting grouped data, you can choose to sort the detailvalues or you can sort the summary values in the footers.

8/7/2019 Cognos8QS

20/60


Display Data Graphically withCharts:Display Data Graphically withCharts:

Create a chart to present information graphically. Charts are useful for seeing patterns and trends in data.

8/7/2019 Cognos8QS

21/60


Specify a Chart Type:Specify a Chart Type:

Consider what you want the chart to illustrate before you choose achart type.

Use a pie chart to highlight proportions rather than actual

values.

Use a column chart to show how data changes over time.

Use a bar chart to place less emphasis on time and focus on

comparing values.

8/7/2019 Cognos8QS

22/60


Specify a Chart Type (Contd):Specify a Chart Type (Contd):

Consider what you want the chart to illustrate before you choose achart type.

Use an area chart

to show how muchthe value of a

measure changes

over time.

Use a column line

chart to compare

two different

measures in thesame chart.

Use a radar chart

to comparemeasures using a

radial figure.

Use a line chart to

plot many

measures.

8/7/2019 Cognos8QS

23/60


Enhance the Display of Charts:Enhance the Display of Charts:

Consider what you want the chart to illustrate before you choose achart variation.

Use the standard

variation to plot

actual value of dataseries from a

common axis.

Use the stacked chart for

comparing the proportionalcontribution within a

category.

In the 100% stacked

variation, the top of eachstack represents 100%.

useful for comparing

proportional contribution

across all category.

Use the 3D display toenhance the chart

with a three-

dimensional visual

effect.

8/7/2019 Cognos8QS

24/60


Filter Data in Ad Hoc Reports:Filter Data in Ad Hoc Reports:

Create a filter to retrieve a subset of records in a report.

Any data that does not meet the criteria of the filter is eliminatedfrom the report.

8/7/2019 Cognos8QS

25/60


Filter Data Based on Report Details:Filter Data Based on Report Details:

You can filter the values that appear in the detail rows of yourreport. This filtering eliminates detail rows that do not meet thespecified criteria.

8/7/2019 Cognos8QS

26/60


Filter Data Based on Group Summaries:Filter Data Based on Group Summaries:

You can filter on values in the footers of your ad hoc reports. Thisfiltering eliminates groups from your report that do not meet thespecified criteria.

8/7/2019 Cognos8QS

27/60


Filter Data Based on individual RecordsFilter Data Based on individual Records

You can use a filter based on individual records in the underlyingdata source, even if the report contains only aggregated data.

8/7/2019 Cognos8QS

28/60


Specify Filter Criteria withPrompts:Specify Filter Criteria withPrompts:

Create a prompt if you want to use different criteria for the samereport item each time the report is run.

Using prompts is faster and easier than repeatedly changing thefilter.

8/7/2019 Cognos8QS

29/60


Create New Report Items withCustom Groups:Create New Report Items withCustom Groups:

Create custom groups to produce new report items that containvalues that are meaningful to you.

8/7/2019 Cognos8QS

30/60


You can use predefined formats to change the appearance ofnumbers, dates, and times in your reports.

Using these formats does not change the underlying data.

Format Data in Ad Hoc Report

8/7/2019 Cognos8QS

31/60


Use calculations to add data items to your report that do not existin the underlying data source.

Calculation results are not stored in the underlying data source.

Instead, Query Studio reruns the calculation each time you run thereport.

The results of a calculation are always based on the most currentdata in the data source.

You can create calculations directly in an ad hoc report, or addpredefined calculations from the package.

Add Calculated Data to Ad Hoc Reports

8/7/2019 Cognos8QS

32/60


Create Calculated ColumnsCreate Calculated Columns

You can add value to your reports by calculating the data in one ormore columns.

8/7/2019 Cognos8QS

33/60


You can use predefined summaries to calculate the total, count,maximum, minimum, or average of the values in individual report

items.

Add Summarized Data to Ad Hoc Reports

On average, each order of AloeRelief in Germany consisted of

88 units. The total of theaverage sales for Aloe Relief

across all three countries is154.

8/7/2019 Cognos8QS

34/60


When you run a report, you can change the way the data is

processed by automatically: summarizing measures in the footer summarizing detail values and suppressing duplicates

To access these options, open a report in edit mode and click theRun Report section. Then click the Advanced Query Options link.Note that these options are selected automatically, becauseapparently most people want to see the data shown in this way.

Specify Advanced Query Options

We are not summarizing detail values. Each sale of everyproduct is shown in the report.

8/7/2019 Cognos8QS

35/60


Drill up and drill down is available only whenyou are using dimensionally structured data

viewing the report in HTML format

you can drill only on members in a level

Drill Up or Drill Down

8/7/2019 Cognos8QS

36/60


Navigate to Another TargetNavigate to Another Target

You can navigate from a Query Studio report to another target.

You can navigate to the following targets:

1. a Query Studio report

2. a Report Studio report

3. an Analysis Studio analysis

4. a Cognos Series 7 PowerCube action

5. a Microsoft Analysis action

Before you can navigate to another target, a drill-throughdefinition must be created in the package.

8/7/2019 Cognos8QS

37/60


8/7/2019 Cognos8QS

38/60


Define Conditional StylesDefine Conditional Styles

Y

ou can define conditional styles to highlight key information in areport. You can use conditional styles with numeric data, textdata, and date values.

8/7/2019 Cognos8QS

39/60


Specify the RowsPer PageSpecify the RowsPer Page

You can specify the maximum number of rows of data to appear onthe page.

By default, Query Studio shows 20 rows of data. The more rowsthat are retrieved, the more time that is needed to retrieve data.You can improve performance by showing fewer rows.

8/7/2019 Cognos8QS

40/60

8/7/2019 Cognos8QS

41/60

8/7/2019 Cognos8QS

42/60


Specify Run OptionsSpecify Run Options

You can run your reports with all of the data, some of the data, or none

of the data.

8/7/2019 Cognos8QS

43/60


Specify Properties for Ad Hoc ReportsSpecify Properties for Ad Hoc Reports

In Cognos Connection, you can specify unique properties for each

ad hoc report that you create in Query Studio.

8/7/2019 Cognos8QS

44/60


View Ad Hoc ReportsView Ad Hoc Reports

We can view the reports in following formats.

1. HTML

2.P

DF3. Excel 2000 Single Sheet

4. Excel 2002

5. Delimited Text (CSV)

6. XML

8/7/2019 Cognos8QS

45/60


View Ad Hoc Reports in PDFFormatView Ad Hoc Reports in PDFFormat

You can render ad hoc reports in Adobe Acrobat format before

distribution and printing.

8/7/2019 Cognos8QS

46/60


Specify Column Order in Ad Hoc ReportsSpecify Column Order in Ad Hoc Reports

You can delete one or more columns from a report.

You can re-order columns in a report by using cut and pastefunctionality.

8/7/2019 Cognos8QS

47/60

8/7/2019 Cognos8QS

48/60


Specify the Language of Ad Hoc ReportsSpecify the Language of Ad Hoc Reports

You can set the default language to be used when a report is run.

You can also select additional or different languages for the reportby changing the run options when the report is run.

8/7/2019 Cognos8QS

49/60


Create Customized ReportsCreate Customized Reports

Create a report view to produce a customized version of an

existing ad hoc report.

A report view shares the same report specification as the sourcereport, but other properties, such as prompt answers, areindependent of the source report.

8/7/2019 Cognos8QS

50/60


View Previous Report OutputsView Previous Report Outputs

You can analyze older data in your ad hoc reports by viewing

previous report outputs.

8/7/2019 Cognos8QS

51/60


View the Run History of ReportsView the Run History of Reports

You may choose to run reports in the background, without anyone

waiting to view them.

You may want to verify if these reports were run successfully orhow often the reports were run in the background.

You can view the run history of a report to examine:

when the report was requested

the start time and completion time for the report

whether the report executed successfully

8/7/2019 Cognos8QS

52/60


Distribute Ad Hoc ReportsDistribute Ad Hoc Reports

You can distribute ad hoc reports to other users to shareinformation with them.

You can distribute ad hoc reports by:

saving them where other users can access them

sending them to other users by email

printing them

8/7/2019 Cognos8QS

53/60


Save Ad Hoc ReportsSave Ad Hoc Reports

You can share ad hoc reports with

others by saving them in a location

that is accessible to other users,

such as the public folders.

Public folders typically contain

reports that are of interest to many

users.

The other ways do save the reports are:

copy the report

move the report

create a shortcut to the report Create a report view to the report

8/7/2019 Cognos8QS

54/60


Send Ad Hoc Reports by EmailSend Ad Hoc Reports by Email

You can share an ad hoc report with others by sending the report

by email.

8/7/2019 Cognos8QS

55/60


Print Ad Hoc ReportsPrint Ad Hoc Reports

You can print a PDF version of an ad hoc report to obtain a hard

copy of the information.

Print a report if your computer is not available, or if you want totake a copy of a report to a meeting.

8/7/2019 Cognos8QS

56/60


Schedule Ad Hoc ReportsSchedule Ad Hoc Reports

You can schedule reports to run at a time that is convenient foryou, such as during off hours when demands on the system arelow.

You can schedule reports individually or by using a job.

You can schedule reports to run by minute, hourly, daily, weekly,monthly, or yearly.

After you create a schedule, the report or job runs at the date andtime specified.

8/7/2019 Cognos8QS

57/60


Schedule a Single Ad Hoc ReportSchedule a Single Ad Hoc Report

You can schedule a single report to run it at a later time or at a

recurring date and time.

8/7/2019 Cognos8QS

58/60


Schedule Multiple Ad Hoc ReportsSchedule Multiple Ad Hoc Reports

You can set the same schedule for multiple reports by creating a

job. A job identifies a collection of reports, report views, and other jobs

that are scheduled to run together and share the same schedulesettings.

8/7/2019 Cognos8QS

59/60


View and Manage SchedulesView and Manage Schedules

You can use the Schedule Management tool to view and manage

the schedules you have created.

8/7/2019 Cognos8QS

60/60

cognos8qs

Documents