LIST of MDX function not supported in SQL Server Standard Edition

  • Hi All,

    Are there any MDX Functions which are not supported in the SQL Server standard edition ?

    Would be great , if i can get a list of those function which are supported in Enterprise Edition only.

    Thanks

    veenet

  • vineet_dubey1975 (6/28/2016)


    Hi All,

    Are there any MDX Functions which are not supported in the SQL Server standard edition ?

    Would be great , if i can get a list of those function which are supported in Enterprise Edition only.

    Thanks

    veenet

    As far as I know there are no MDX function limitations based on SQL Server Edition.


    I'm on LinkedIn

  • Thanks for being so nice.. i was just downgrade my Enterprise Version Cube to SE Edition ...

    Cube processes successfully

    1- set semi-additive Aggregation function Sum/Count

    2- Created Calculated Members using Standard functions..

    with the help of below DMV SQL

    SELECT [CATALOG_NAME] as [DATABASE], CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],[MEASURE_CAPTION] AS [MEASURE],[MEASURE_IS_VISIBLE]

    FROM $SYSTEM.MDSCHEMA_MEASURES

    WHERE CUBE_NAME ='Adventure Works'

    Though all the Calculated members are showing semi-additive but its working fine Standard Edition

    Thanks

    veneet

  • vineet_dubey1975 (6/28/2016)


    Thanks for being so nice.. i was just downgrade my Enterprise Version Cube to SE Edition ...

    Cube processes successfully

    1- set semi-additive Aggregation function Sum/Count

    2- Created Calculated Members using Standard functions..

    with the help of below DMV SQL

    SELECT [CATALOG_NAME] as [DATABASE], CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],[MEASURE_CAPTION] AS [MEASURE],[MEASURE_IS_VISIBLE]

    FROM $SYSTEM.MDSCHEMA_MEASURES

    WHERE CUBE_NAME ='Adventure Works'

    Though all the Calculated members are showing semi-additive but its working fine Standard Edition

    Thanks

    veneet

    Yes, there are limitations in Standard Edition (non-additive measures, perspectives etc.), just not in MDX. Another way of analysing a cube for things like non-additive measures prior to a downgrade is the Non-Default Properties report in BIDSHelper: https://bidshelper.codeplex.com/wikipage?title=Non-Default%20Properties%20Report&referringTitle=Documentation


    I'm on LinkedIn

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply