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