Difference between revisions of "Mdx:"

(Examples)
(Examples)
Line 33: Line 33:
 
Valid examples you be:
 
Valid examples you be:
  
* {{Code|Mdx:nextYear:=[Date].[Calendar].[Calendar Year].&[2002].NextMember}}
+
* Mdx:nextYear:=[Date].[Calendar].[Calendar Year].&[2002].NextMember
* {{Code|Mdxset:{[Date].[Calendar].[Calendar Year].&[2001]:[Date].[Calendar].[Calendar Year].&[2003]} }}
+
* Mdxset:{[Date].[Calendar].[Calendar Year].&[2001]:[Date].[Calendar].[Calendar Year].&[2003]}
  
 
{| class="wikitable"
 
{| class="wikitable"

Revision as of 17:40, 31 January 2013

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.

Syntax

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

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

Examples

Valid examples you be:

  • Mdx:nextYear:=[Date].[Calendar].[Calendar Year].&[2002].NextMember
  • Mdxset:{[Date].[Calendar].[Calendar Year].&[2001]:[Date].[Calendar].[Calendar Year].&[2003]}
MdxColon.png
MdxSetColon.png

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