Add a Query to a Dimensional Report

You can create multiple queries in Query Explorer to suit your particular needs. For example, you can create a separate query for each data container in a report to show different data.

Tip: The Briefing Book sample report in the GO Sales (analysis) package and the Top 10 Retailers for 2011 sample report in the GO Data Warehouse (analysis) package include multiple queries.

Procedure

Click the Queries icon , and click Queries.

Click the Toolbox icon

and drag one of the following objects to the work area.

Object	Description
Query	Adds a query.
Join	Adds a join relationship.
Union	Adds a union operator.
Intersect	Adds an intersect operator.
Except	Adds an except (minus) operator.
SQL	Adds SQL commands.
MDX	Adds MDX commands.

Note: When adding queries to the report

right-click the work area and click Show Package Sources to see the queries that use data items from a package
right-click the work area and click Expand References to see the relationships that exist between queries in the report, which is useful when you are creating complex queries

Select an object, click the Show properties icon , and in the Properties pane, set the object properties.

Note: The Maximum execution time property for a report query applies only to compatible query mode.
Double-click a query.
Click the Insertable objects icon , click the Source tab , drag data items to the Data Items pane.

Tip: You can add data items to the query that you do not want to appear in the layout. For example, to filter on Product line code and show Product line in the layout, you must add both data items to the query.
To create a new data item, click the Toolbox icon and drag Data Item to the Data Items pane.
To add a filter, click the Toolbox icon and drag Filter to the Detail Filters or Summary Filters pane and define the filter expression.

Tip: You can also create a filter by dragging a data item from the Source tab to one of the filters panes and completing the filter expression. When working with a dimensional data source, you can quickly filter data by dragging a member to a filter pane instead of dragging the level to which the member belongs. For example, dragging the member 2012 from the Years level will filter data for the year 2012. This method is quicker than dragging the Years level and specifying data only for the year 2012 in the filter expression.