StripCalculatedMembers (MDX)

Returns all members filtering out calculated members.

In our example, the set {[Measures].[V], [Measures].[Amount]} is transformed into {[Measures].[Amount]}

Query

WITH
    MEMBER [Measures].[V] AS FALSE
SELECT
    StripCalculatedMembers({[Measures].[V], [Measures].[Amount]}) ON 0
FROM
    [Sales]

Result

Assertion : MDX Equals

SELECT
    [Measures].[Amount] ON 0
FROM
    [Sales]

StripCalculatedMembers can be applied to a set of tuples. All tuples with at least one calculated members are filter out of the new set.

Query

WITH
    MEMBER [Measures].[V] AS FALSE
SELECT
    StripCalculatedMembers(
    {
        ([Geography].[Geo].[Spain], [Measures].[V]),
        ([Geography].[Geo].[Spain], [Measures].[Amount])
    }) ON 0
FROM
    [Sales]

Result

Assertion : MDX Equals

SELECT
    ( [Geography].[Geo].[Spain], [Measures].[Amount] ) ON 0
FROM
    [Sales]

Function cannot be applied to the string parameter.

Query

StripCalculatedMembers("hello")

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : StripCalculatedMembers() : argument (0) type mismatch: expected:'set', got:'string'

Returns NULL if applied to a NULL entity.

Query

StripCalculatedMembers( NULL )

Result

{}