ValTypeName (MDX+)

Returns the type of the argument when evaluated.

Parameters

Return

string

Description

Allows to retrieve the type of the MDX entity passed as parameter when evaluated. For example, if the argument is a measures member then this function will return the type of the measure when evaluated.

        VarType   ( [Measures].[Amount] ) => "measure"
        ValueType ( [Measures].[Amount] ) => "double"
        

See Also

VarTypeName

Examples

WITH
    MEMBER [mesV] AS ValTypeName( [Measures].defaultMember )
    MEMBER [mesT] AS VarTypeName( [Measures].defaultMember )
SELECT
    { [mesV], [mesT] } ON 0
FROM
    [Sales]

WITH
    MEMBER [mesV] AS "numeric"
    MEMBER [mesT] AS "measure"
SELECT
    { [mesV], [mesT] } ON 0
FROM
    [Sales]

Since Version

6.5.1

XMLA Properties

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