Matrix (MDX+)

Returns a Matrix.

Parameters

Name	Type	Cardinality	Default value
set	set-expression	two
value	numeric-expression	one

Return

value

Description

This function creates a matrix object of numerical values (double). Two syntax might be used :

- Matrix( {Column-Set}, {Row-Set}, [Measures].[Amount])

Once the matrix has been created you might call different methods :

Matrix(...)->value(col,row) -> returns the 0-based col,row element (note this is inverse as a regular matrix annotation Aij where i represents a row)
Matrix(...)->inverse() -> returns the inverse of the matrix (an error if it's a singular matrix)
Matrix(...)->solve(Vector) -> solves the algebraic equation (an error if it's a singular matrix)

Examples

Matrix(set,set,numeric)

A matrix can be build as a crossjoin of two sets. The numerical expression specified as parameter is applied to each tuple. The first set define the rows of the matrix, the second one the columns.

Query

WITH
    MEMBER [Measures].[val] AS Matrix({[Time].[Calendar].[2010],[Time].[Calendar].[2011]}, {[Geography].[Geo].[Switzerland],[Geography].[Geo].[France]}, [Measures].[Amount] )
SELECT
    [Measures].[val] ON 0
FROM
    [Sales]

Result

val
[[248.0, 0.0], [4.0, 0.0]]

val

[[248.0, 0.0], [4.0, 0.0]]

Assertion : Cell Equals

WITH
    MEMBER [col1] AS  VectorN( ([Geography].[Geo].[Switzerland],[Time].[Calendar].[2010],[Amount]), ([Geography].[Geo].[France],[Time].[Calendar].[2010],[Amount]) )
    MEMBER [col2] AS  VectorN( ([Geography].[Geo].[Switzerland],[Time].[Calendar].[2011],[Amount]), ([Geography].[Geo].[France],[Time].[Calendar].[2011],[Amount]) )
    MEMBER [Measures].[val] AS MatrixN( [col1].value(), [col2].value() )
SELECT
    [Measures].[val] ON 0
FROM
    [Sales]

Matrix - Inverse()

	Corporate	Partnership	Personal	Startup
United States	0.0013020833333333335	-0.001953125	5.767392335715099E-19	6.510416666666651E-4
France	0.003906250000000002	-0.05794270833333328	1.0000000000000002	-2.4459635416666674
Spain	-0.005208333333333336	0.0494791666666666	-1.0000000000000004	2.955729166666668
Switzerland	-0.0	0.010416666666666666	-0.0	-0.010416666666666666

Matrix - Inverse() II

matrix-i
[[1.0, 0.0, 0.0, 0.0], [0.0, 1.0, 0.0, 0.0], [0.0, 0.0, 1.0, 0.0], [0.0, 0.0, 0.0, 1.0]]

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.