Query Studio

Creating a Query Studio Report: Adding Data

A new report contains no data. You choose the report items that you want to include in the report from the list of data in the Presentation package for your enterprise. For more information on the Presentation package, see Reporting Data Model.

Items added from the presentation package to your report are called report items. Report items appear as columns in list reports, and as rows and columns in crosstab reports. In charts, report items appear as data markers and axis labels.

You can also add calculations to a report.

Data Source Icons

Each object in the data source has a representative icon. You can insert all of the following objects in a report, except for packages.

Icon	Object
	Package, which contains the objects you can insert in a report.
	Query subject, which represents a table in the database.
	In relational data sources, query item, which represents a column of qualitative data in the database, such as product name or country. In dimensional data sources, level attribute, which represents a property of a level.
	Measure or fact, a query item that represents a column of quantitative data in the database, such as revenue or quantity.
	Measures folder, which contains hierarchical measures.
	Model filter.

To add data to a report:

Open a report in Query Studio.
The Insert Data menu is opened by default. A tree hierarchy of the Reporting Data Model appears in the left pane.
Expand the Presentation Menu to view the data types that can be added to the report.
In the left pane, double-click the items you want to add.
Note: To insert multiple items at once, Ctrl-click the items and then click Insert at the bottom of the left pane.
The items appear in the work area.

Tips

By default, each new report item follows the last report item, but you can insert an item in a different position. Click an existing heading in your report. The next item you add from the package precedes this heading.
You can also control the order of items by dragging them to the work area. For example, you can drag an item between two columns that are already in your report.
To remove data from your report, click the report item heading, then click the delete button on the toolbar.