Difference between revisions of "Mdx:"
(→Examples) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (13 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
==Description== | ==Description== | ||
| − | The Mdx: or Mdx Colon feature allows you to easily combine snippets of Mdx with your existing | + | The Mdx: or Mdx Colon feature allows you to easily combine snippets of Mdx with your existing FluenceXL [[Grids]] and other report objects. |
The Mdx: statement could be a fixed piece of text, or created by using an Excel formula. | 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. | 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== | ==Syntax== | ||
| Line 31: | Line 33: | ||
==Examples== | ==Examples== | ||
| − | Valid 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" | {| class="wikitable" | ||
| Line 43: | Line 47: | ||
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. | ||
| + | |||
| + | 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]] | ||
Latest revision as of 09:27, 4 July 2023
Description
The Mdx: or Mdx Colon feature allows you to easily combine snippets of Mdx with your existing FluenceXL 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.
| 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 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
 |
 |
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:
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.
