SQL Server Performance Forum – Threads Archive
Semi- Additive Measures
If i want to define a semi additive measure across the time dimention ,how will it appear across other dimentions.If i use Last Child function as the aggregate function to define semi additive behaviour…..what function will b used to aggregate the mesaure across the rest of the dimentions.Hi,
Check this Blog, this clear some of your doubts about defining LastNonEmptyChild as aggregate function
http://blogs.conchango.com/christia…itive-Measures-in-Analysis-Services-2005.aspx
thanks rajit……the link made things a lot clearer
]]>