Difference between revisions of "Mdx:"
| Line 43: | Line 43: | ||
In these examples the Mdx: statement is made using other Excel references, so that when these change the grid will also be updated. | In these examples the Mdx: statement is made using other Excel references, so that when these change the grid will also be updated. | ||
| + | |||
| + | ==Adding hidden calculations== | ||
| + | |||
| + | Sometimes in a [[Grid]] you need to add and MDX: calcualtion that is used my 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== | ==See also== | ||
Revision as of 14:59, 7 September 2017
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]}
 |
 |
In these examples the Mdx: statement is made using other Excel references, so that when these change the grid will also be updated.
Sometimes in a Grid you need to add and MDX: calcualtion that is used my 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.
