Difference between revisions of "Mdx:"

(Created page with "The Mdx: or Mdx Colon feature allows you to easily combine snippets of mdx with your existing XLCubed Grids and other report objects.")
 
Line 1: Line 1:
 +
==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: or Mdx Colon feature allows you to easily combine snippets of mdx with your existing XLCubed [[Grids]] and other report objects.
 +
 +
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.
 +
 +
{| 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.
 +
|}

Revision as of 17:35, 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.

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.
Yes Puts a user friendly caption against the member when it is returned.
Mdx No The Mdx snippet to run.