How do people handle semi-additive measures with SSAS Standard edition? (other than switching to Enterprise edition). I'm using SSAS 2008 R2 (but it applies to 2005 & 2008 as well).
If you try to set a measure to 'Last non-empty value', you get the 'Error 31 Errors related to feature availability and configuration: The 'Semi-additive measures' feature is not included in the '64 Bit Standard Edition' SKU.' error when trying to deploy to a SSAS standard edition.
FactCompany has a monthly granularity, by company and an inventory count of number of trucks. In creating the measure, I want the usage to be the 'Last non-empty value'. Unfortunately this isn't an option supported by the Standard edition. I can change it to Sum so that the measure group will process, but the total number of trucks for a year really isn't the sum of all of the months, but the last value.