The easiest MDX request?

Question

What is the easiest MDX request ?

I want to check if the MDX endpoint answers a very simple request correctly.
In SQL, I would saySELECT 1;

Answer 1

This query will display your first dimension against the top level of the first dimension that it finds. All you need to specify is the name of your cube. He will return a single number.

 SELECT {Dimensions(0).defaultMember} ON ROWS, 
 {[Measures].defaultMember} ON COLUMNS 
 FROM [NameOfCube]

Answer 2

I think the simplest MDX query is: SELECT FROM cubeName

Answer 3

, MDX- - . , - , .

SELECT [MeasureGroup].[Measure]
  FROM [Cube]

- MS MDX.

Answer 4

WITH MEMBER Test AS 1
SELECT Test ON COLUMNS FROM [Cube]

.

Answer 5

MDSchema. select * from $system.Discover_Schema_Rowsets, . :

TOP 0 [CATALOG_NAME] $system.DBSCHEMA_CATALOGS

1 , XMLA.

; ( ), . :

PS C: > Invoke-ASCmd -Query "CREATE MEMBER [mycube].x AS 1" -Server myserver -Database mydatabase

< return xmlns = "urn: schemas-microsoft-com: xml-" < root xmlns = "urn: schemas-microsoft-com: xml-analysis: empty" > </root> </ >