View source for Mdx:

==Description==

The Mdx: or Mdx Colon feature allows you to easily combine snippets of Mdx with your existing XLCubed [[Grids]] and other report objects.

The Mdx: statement could be a fixed piece of text, or created by using an Excel formula.

You can use this to create members or sets depending on your requirements.

[[Query Generators]] can be useful in creating MDX snippets or creating a start point to work from.

==Syntax==

The Mdx: statement is made up of two or three parts.

{| class="wikitable"
! Part
! Optional?
! Description
|-
| {{Code|Mdx:}} or {{Code|MdxSet:}}
| No
| Select based on whether your mdx snippet returns a single member or a set of members.
|-
| {{Code|Caption}}:=
| Yes
| Puts a user friendly caption against the member when it is returned.
|-
| {{Code|Mdx}}
| No
| The Mdx snippet to run.
|}

==Examples==

Valid examples may be:

* Mdx:nextYear:=[Date].[Calendar].[Calendar Year].&[2002].NextMember
** Creates a member called "nextYear" using the MDX expresssion
* Mdxset:{[Date].[Calendar].[Calendar Year].&[2001]:[Date].[Calendar].[Calendar Year].&[2003]}
** Creates a set with no name that gives the years from 2001 to 2003

{| class="wikitable"
|-
| [[Image:MdxColon.png|350px|centre]]
| [[Image:MdxSetColon.png|350px|centre]]
|}

In these examples the Mdx: statement is made using other Excel references, so that when these change the grid will also be updated.

You can then reference these cells using the standard Excel member picker:

[[Image:MdxColonPick.png|350px|centre]]

==Adding hidden calculations==

Sometimes in a [[Grid]] you need to add an MDX: calculation that is used by another calculation, but is not displayed itself. As of [[Version 9.1]] you can do this by picking a range of cells containing MDX: statements which will be added to the query. This is done from the MDX tab of the properties screen.

==See also==
* [[XL3Member#XL3Member using MDX|MDX: in XL3Member formulae]]
* [[Calculations Overview]]
* [[MDX Calculations]]

[[Category:Grid Reporting]]
[[Category:OLAP Operations]]