Retrieve all cubes in the current SSAS database.
SELECT [Catalog].[Name] FROM $system.DBSCHEMA_CATALOGS
MDX – List All Cubes
MDX – Top 10 Products by Sales
Shows the ten best‑selling products for the current year.
SELECT TOPCOUNT(
[Product].[Product].Members,
10,
[Measures].[Sales Amount]
) ON ROWS,
{[Measures].[Sales Amount]} ON COLUMNS
FROM [Adventure Works]
DAX – Year‑to‑Date Sales
Calculate YTD sales for the current context.
CALCULATE(
SUM('FactSales'[SalesAmount]),
DATESYTD('Date'[Date])
)
MDX – Generate Query Plan
Returns the query plan XML for a given MDX statement.
SELECT
{ [Measures].[Internet Sales Amount] } ON COLUMNS,
{ [Date].[Calendar].[Calendar Year].Members } ON ROWS
FROM [Adventure Works]
FORMAT XMLA
DAX – Same Period Last Year
Compares current period sales with the same period last year.
CALCULATE(
SUM('FactSales'[SalesAmount]),
SAMEPERIODLASTYEAR('Date'[Date])
)