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)

See Also

MatrixA MatrixN Vector VectorA VectorN

Examples

XMLA Properties

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