1
A look at few examples to write MDX Queries
2
-------------------------------------------
4
Writing a simple MDX on a SALES Schema::
7
{[partner_country].[all]} on rows,
8
{[measures].[Items Sold]} on columns
13
===================== ============
15
===================== ============
16
All partner_country [43.0]
17
===================== ============
20
Expanding the partner country to its children, we change the MDX as.::
23
{[partner_country].[all],[partner_country].children} on rows,
24
{[measures].[Items Sold]} on columns
29
===================== ============
31
===================== ============
32
All partner_country [43.0]
36
===================== ============
38
One more example bit complex with slicer::
41
{[date_order].children,[date_order].[2008].children,[date_order].[2008].[Q2].children},
42
{[measures].[Items Sold]}
44
where ([date_order].[2008])
48
===================== ============
50
===================== ============
53
===================== ============