SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
Tools and Utilities Reference
User Interface Reference
Analysis Services F1 Help
Analysis Services Designers and Dialog Boxes
Add Cube Dimension Dialog Box
Add Reference Dialog Box
Add Table Dialog Box
Add/Remove Tables Dialog Box
Analysis Server Properties Dialog Box
Assembly Properties Dialog Box
Attribute Data Translation Dialog Box
Backup Database Dialog Box
Browse Data Source Dialog Box
Browse Data Source View Dialog Box
Browse for Remote Folder Dialog Box
Calculation Properties Dialog Box
Change Settings Dialog Box
Connection Manager Dialog Box
Copy Aggregation Design Dialog Box
Create/Edit Named Calculation Dialog Box
Create/Edit Named Query Dialog Box
Create/Edit Relationship Dialog Box
Create Polling Query Dialog Box
Create Processing Query Dialog Box
Cube Designer
Cube Properties Dialog Box
Data Exploration Options Dialog Box
Data Mining Model Designer
Data Sample Viewer Dialog Box
Data Source Designer Dialog Box
Data Source Properties Dialog Box
Data Source View Designer
Data Source View Properties Dialog Box
Database Designer
Database Properties Dialog Box
DataItem Collection Editor Dialog Box
Define Relationship Dialog Box
Delete objects and files Dialog Box
Dimension Designer
Dimension Properties Dialog Box
DMX Query Editor
Duplicate Role Dialog Box
Enable/Disable Writeback Dialog Box
Explore Data Dialog Box
Filter Members Dialog Box
Find Table Dialog Box
Generate Named Query Dialog Box
Impact Analysis Dialog Box
Impersonation Information Dialog Box
Incremental Update Dialog Box
Level Naming Template Dialog Box
Locate Database Files Dialog Box
MDX Builder Dialog Box
MDX Query Editor
Measure Group Bindings Dialog Box
Merge Partition Dialog Box
Mining Model Properties Dialog Box
Mining Structure Properties Dialog
New Database Dialog Box
New Measure Dialog Box
New Measure Group Dialog Box (Cube Designer)
Object Binding Dialog Box
Partition Properties Dialog Box
Partition Source Dialog Box
Process Dialog Box
Process Progress Dialog Box
Refresh Data Source View Dialog Box
Register Server Assembly Dialog Box
Relational Objects Dialog Box
Remote Partitions - Advanced Settings Dialog Box
Rename Instance Dialog Box
Replace Table with Other Table Dialog Box
Restore Database Dialog Box
Role Designer
Save File As Dialog Box
Security Context Dialog Box
Select Language Dialog Box
Select Parent Member Dialog Box
Show Table Dialog Box
Storage Options Dialog Box
Storage Settings Dialog Box
User Selection Dialog Box
View Details Dialog Box
XMLA Query Editor
Expand Minimize
This topic has not yet been rated - Rate this topic

XMLA Query Editor (SSAS)

SQL Server 2005

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.

Term Definition

Connect

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

Disconnect

Disconnects the XMLA Query Editor from an Analysis Services instance.

Change Connection

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

New Query with Current Connection

Opens a new XMLA Query Editor window, using the connection information from the current XMLA Query Editor window.

Available Databases

Changes the connection to a different Analysis Services database on the same instance.

Execute

Executes the selected code, or if no code is selected, this option executes the entire code in the XMLA Query Editor.

Parse

Checks 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 Query

Sends 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:

Term Definition

Query editor window

Type XMLA statements and scripts to be executed by the XMLA Query Editor.

For more information about the query editor pane, see Editing Scripts and Files in SQL Server Management Studio.

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.
Term Definition

Results window

Displays the results of an XMLA statement or script in text.

Messages window

Displays 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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.