XMLA Query Editor (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

Use the XMLA Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (XMLA) language.

  • Type scripts in the query editor pane of XMLA Query Editor.

  • To execute scripts press F5, or click Execute on the toolbar, or on the Query menu, click Execute. If a portion of the code is selected, only that portion is executed. If no code is selected, the entire content of the XMLA Query Editor is executed.

  • View metadata for cubes and other objects contained in an Analysis Services database in the metadata pane.

  • For help with XMLA syntax, select a keyword in XMLA Query Editor, and then click F1.

  • For dynamic help with XMLA syntax, on the Help menu, click Dynamic Help to open the Dynamic Help component. With Dynamic Help, help topics appear in the Dynamic Help window when keywords are typed in Query Editor.

When XMLA Query Editor is open, the SQL Server Analysis Services Editors toolbar appears with the following buttons.

TermDefinition
ConnectOpens the Connect to Server dialog box, to establish a connection to an Analysis Services instance.
DisconnectDisconnects the XMLA Query Editor from an Analysis Services instance.
Change ConnectionOpens the Connect to Server dialog box, to establish a connection to a different Analysis Services instance.
New Query with Current ConnectionOpens a new XMLA Query Editor window, using the connection information from the current XMLA Query Editor window.
Available DatabasesChanges the connection to a different Analysis Services database on the same instance.
ExecuteExecutes the selected code, or if no code is selected, this option executes the entire code in the XMLA Query Editor.
ParseChecks the syntax of the selected code. If no code is selected, this option checks the syntax of the entire XMLA Query Editor window.
Cancel Executing QuerySends a cancellation request to the server. Some queries cannot be canceled immediately, but must wait for a suitable cancellation condition. When queries are canceled, delays may occur while transactions are rolled back.

The following options are available in XMLA Query Editor:

TermDefinition
Query editor windowType XMLA statements and scripts to be executed by the XMLA Query Editor. The context menu for the query editor provides the following options:

 Cut:
Copies the current selection to the clipboard and removes the selection from the query editor window.

 Copy:
Copies the current selection to the clipboard.

 Paste:
Pastes the contents of the clipboard to the current selection.

 Connect:
Opens the Connect to Server dialog box, to establish a connection to an Analysis Services instance.

 Disconnect:
Disconnects the current query editor from an Analysis Services instance.

 Disconnect All Queries:
Disconnects all open query editors.

 Change Connection:
Opens the Connect to Server dialog box, to establish a connection to a different Analysis Services instance.

 Open Server in Object Explorer:
Opens the Analysis Services instance to which the current query editor is connected in Object Explorer.

 Execute:
Executes the selected code, or if no code is selected, executes the entire code in the current query editor.

 Properties Window:
Displays the Properties window in SQL Server Management Studio for the current query window.

 Query Options:
Displays the Query Options dialog box.
Results windowDisplays the results of an XMLA statement or script in text.
Messages windowDisplays information about how an XMLA statement or script executed. For example, this window displays any errors encountered during execution or the number of cells retrieved after execution.

MDX Query Editor (Analysis Services - Multidimensional Data)
DMX Query Editor (Analysis Services - Data Mining)
Query and Text Editors (SQL Server Management Studio)
SQL Server Management Studio Keyboard Shortcuts

Community Additions

ADD
Show: