XL3MdxDataSeries

Revision as of 09:41, 7 October 2010 by Antonio.remedios (talk | contribs) (Created page with 'Returns the set of values given by the specified MDX. Often used to provide a OLAP data source for MicroCharts functions. ==Syntax== {{Code|XL3MdxDataSeries( Connection, MdxExp…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Returns the set of values given by the specified MDX. Often used to provide a OLAP data source for MicroCharts functions.

Syntax

XL3MdxDataSeries( Connection, MdxExpression, Measure, Hierarchy1, Member1,…, Hierarchy13, Member13 )

Parameters

Parameter Description
Connection Connection number to use
MdxExpression The MDX expression to run
Measure The measure to use
Hierarchy1,…, HierarchyN Name of the hierarchy that the following member applies to e.g. "Measures" or "[Customer].[Customer Geography]"
Member1,…, MemberN Either a single member unique name or an XL3Member formula

Examples (based on the Bicycle Sales cube)

Returns the a set of 12 Revenues for January 2004 to December 2004

=XL3MdxDataSeries( 1, "{LASTPERIODS(12,Time.[December 2004])*KeyFigures.Revenue}", "Value" ) )

Returns a column chart for a set of 12 Revenues for January 2004 to December 2004 (only available with MicroCharts installed)

=MicroColumns( XL3MdxDataSeries( 1, "{LASTPERIODS(12,Time.[December 2004])*KeyFigures.Revenue}", "Value" ) ) )

See Also