Cognos 简明教程

Cognos - Ad-hoc Reports

使用即席报表,用户可以创建查询或报表,用于即席分析。即席报表功能允许用户在数据仓库中的事实表和维度表中创建简单查询和报表。

Using ad-hoc reporting, a user can create queries or reports for ad-hoc analysis. Ad-hoc reporting feature allows business users to create simple queries and reports on the top of fact and dimension table in data Warehouse.

Cognos BI 中的 Query Studio 提供以下功能:

The Query Studio in Cognos BI, provides the following features −

  1. View data and perform ad-hoc data analysis.

  2. Save the report for future use.

  3. Work with data in the report by applying filters, summaries and calculations.

  4. To create ad-hoc report using query studio, login to IBM Cognos software and click on Query my data.

ibm cognos software

选择报表包。下次访问此页面时,您将在近期使用的包中看到您的选择。点击包名称。

Select the report package. Next time you visit this page; you will see your selection under the recently used packages. Click on the package name.

select package

在下一个屏幕中,您可以添加维度元素、筛选和提示、事实和计算等等。

In the next screen, you can add Dimension elements, filters and prompts, facts and calculation, etc.

insert data

您应按此顺序插入对象。要在报表中插入对象,您可以使用底部的插入按钮。

You should insert the objects in this order. To insert object in the report, you can use Insert button at the bottom.

  1. Insert and filter dimension elements

  2. Insert filters and prompts

  3. Insert facts and calculations

  4. Apply finishing touches

  5. Save, run, collaborate, and share

顶部为工具栏,您可以在其中创建新报表、保存现有报表、剪切、粘贴、插入图表、向上和向下钻取等。

At the top, you have the tool bar, where you can create a new report, save existing report, cut, paste, insert charts, drill up and down, etc.

new report

将所有对象都插入到报表中后,您可以在顶部单击运行选项()。

When you insert all the objects to a report, you can click on the Run option () at the top.