June 28, 2016 at 12:59 am
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
June 28, 2016 at 1:56 am
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.
June 28, 2016 at 2:19 am
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
June 28, 2016 at 2:35 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply