June 13, 2016 at 8:36 am
Hi
I have to migrate cube from SSAS Enterprise version to Standard Edition. I also have few semi-additive measures. In order to address the issue i am planning to Create the Calculated Measures.
What should be my approach ????
1) What Additive property should be set in the property window panel.
2) Is sufficient to have Calculated measure with OpeningPeriod/ClosingPeriod function.
DO i need any other consideration while downgrade from EE to SE version related to cube ..
PLEASE HELP
Veneet !!!!!
June 14, 2016 at 1:48 am
vineet_dubey1975 (6/13/2016)
HiI have to migrate cube from SSAS Enterprise version to Standard Edition. I also have few semi-additive measures. In order to address the issue i am planning to Create the Calculated Measures.
What should be my approach ????
1) What Additive property should be set in the property window panel.
2) Is sufficient to have Calculated measure with OpeningPeriod/ClosingPeriod function.
DO i need any other consideration while downgrade from EE to SE version related to cube ..
PLEASE HELP
Veneet !!!!!
Why not consult the chart here: https://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#SSAS
Broadly speaking, you have already identified the non-additive measures restriction, but you should also be aware that perspectives and writeback is also unavailable.
From the same page:
The LastChild semi-additive measure is supported in standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.
From my experience if you try to restore a cube that has any restricted features then it will fail outright, not just ignore the incompatible features (though the last time I did that was on 2008 R2 so it might be different now, I doubt it though).
To answser your questions more succinctly:
1) That really depends on what you are trying to do. Last Non Empty can be replicated with some SQL/MDX trickery, as described here: http://www.purplefrogsystems.com/blog/2008/04/semi-additive-measures-using-sql-server-standard/
2) No, because that's not suppoted by Standard Edition.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply