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

---

]]>