Archive

Archive for July, 2011

Last Ever Non Empty – a new, fast MDX approach (via Chris Webb’s BI Blog)

July 13, 2011 Leave a comment

Last Ever Non Empty - a new, fast MDX approach The last non empty semi-additive measure aggregation functionality in SSAS enterprise edition is very useful, but it doesn’t support one common business requirement: while it will give you the last non empty value within any given time period, it doesn’t handle the variation where you want to get the last non empty value of a measure from all preceding time periods (this is what I’m calling the ‘last ever non empty’ value). There are a number of … Read More

via Chris Webb’s BI Blog

Advertisements
Categories: Sql Server Analysis Services Tags: