Udostępnij za pośrednictwem


Analysis Services MDX Query Designer User Interface (Report Builder)

Report Builder provides a graphical query designer for building Multidimensional Expression (MDX) queries for a Microsoft SQL Server Analysis Services data source. The MDX graphical query designer has two modes: design mode and query mode. Each mode provides a metadata pane from which you can drag members from the selected cubes to build an MDX query that retrieves data when the report is processed.

Uwaga dotycząca zabezpieczeńUwaga dotycząca zabezpieczeń

Users access data sources when they create and run queries. You should grant minimal permissions on the data sources, such as read-only permissions.

The following sections describe the toolbar buttons and query designer panes for each mode of the graphical query designer.

Graphical MDX Query Designer in Design Mode

When you edit an MDX query for a report dataset, the graphical MDX query designer opens in Design mode.

The following figure labels the panes for Design mode.

Projektant zapytań MDX usług Analysis Services, widok projektu

The following table lists the panes in this mode:

Pane

Function

Select Cube button (...)

Displays the currently selected cube.

Metadata pane

Displays a hierarchical list of measures, Key Performance Indicators (KPIs), and dimensions defined on the selected cube.

Calculated Members pane

Displays the currently defined calculated members available for use in the query.

Filter pane

Use to choose dimensions and related hierarchies to filter data at the source and limit data returned to the report.

Data pane

Displays the column headings for the result set as you drag items from the Metadata pane and the Calculated Members pane. Automatically updates the result set if the AutoExecute button is selected. .

You can drag dimensions, measures, and KPIs from the Metadata pane, and calculated members from the Calculated Member pane, onto the Data pane. In the Filter pane, you can select dimensions and related hierarchies, and set filter expressions to limit the data available to query. If the AutoExecute (Automatyczne wykonanie zapytania) toggle button on the toolbar is selected, the query designer runs the query every time that you drop a metadata object onto the Data pane. You can manually run the query using the Run (Uruchamianie zapytania) button on the toolbar.

When you create an MDX query in this mode, the following additional properties are automatically included in the query:

Member Properties   MEMBER_CAPTION, MEMBER_UNIQUE_NAME

Cell Properties   VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

To specify your own additional properties, you must manually edit the MDX query in Query mode.

[!UWAGA]

For more information about MDX and general information about the MDX query designer, see "MDX Query Editor (Analysis Services - Multidimensional Data)" in SQL Server Books Online. However, for a report to display data from an MDX query, you must build the query by using the MDX query designer that comes with Report Builder. Importing an .mdx query from a file is not supported.

Graphical MDX Query Designer Toolbar in Design Mode

The query designer toolbar provides buttons to help you design MDX queries using the graphical interface. The following table lists the buttons and their functions.

Button

Description

Edit As Text

Not enabled for this data source type.

Import

Import an existing query from a report definition (.rdl) file on the file system.

Zmienianie widoku na widok zapytania MDX

Switch to Command Type MDX.

Odświeżanie danych wyniku

Refresh metadata from the data source.

Dodawanie obliczeniowego elementu członkowskiego

Display the Calculated Member Builder dialog box.

Przełączanie w celu wyświetlenia pustych komórek

Toggle between showing and not showing empty cells in the Data pane. (This is the equivalent to using the NON EMPTY clause in MDX).

Automatyczne wykonanie zapytania

Automatically run the query and show the result every time a change is made. Results are shown in the Data pane.

Przycisk pokazywania agregacji

Show aggregations in the Data pane.

Usuń

Delete the selected column in the Data pane from the query.

Ikona służąca do wyświetlania okna dialogowego parametrów zapytania

Display the Query Parameters dialog box. When you specify values for a query parameter, a report parameter with the same name is automatically created. The value of the query parameter is set to an expression that references the report parameter.

Przycisk przygotowywania zapytania

Prepare the query.

Uruchamianie zapytania

Run the query and display the results in the Data pane.

Anulowanie zapytania

Cancel the query.

Przełączanie do trybu projektowania

Toggle between Design mode and Query mode.

Graphical MDX Query Designer in Query Mode

To change the graphical query designer to Query mode, click the Design Mode button on the toolbar.

The following figure labels the panes for Query mode.

Projektant zapytań MDX usług Analysis Services, widok zapytania

The following table lists the panes in this mode:

Pane

Function

Select Cube button (...)

Displays the currently selected cube.

Metadata/Functions/Templates pane

Displays a hierarchical list of measures, KPIs, and dimensions defined on the selected cube.

Query pane

Displays the query text.

Result pane

Displays the results of running the query.

The Metadata pane displays tabs for Metadata, Functions, and Templates. From the Metadata tab, you can drag dimensions, hierarchies, KPIs, and measures onto the MDX Query pane. From the Functions tab, you can drag functions onto the MDX Query pane. From the Templates tab, you can add MDX templates to the MDX Query pane. When you execute the query, the Result pane displays the results for the MDX query.

You can extend the default MDX query generated in Design mode to include additional member properties and cell properties. When you run the query, these values do not appear in the result set. However, they are passed back with the dataset field collection and you can use these values in a report.

Graphical Query Designer Toolbar in Query Mode

The query designer toolbar provides buttons to help you design MDX queries using the graphical interface.

The toolbar buttons are identical between Design mode and Query mode, but the following buttons are not enabled for Query mode:

  • Edit As Text

  • Add Calculated Member (Dodawanie obliczeniowego elementu członkowskiego)

  • Show Empty Cells (Przełączanie w celu wyświetlenia pustych komórek)

  • AutoExecute (Automatyczne wykonanie zapytania)

  • Show Aggregations (Przycisk pokazywania agregacji)

Zobacz także

Inne zasoby

Query Designers (Report Builder)