[Mondrian] semi-additive measures with a shared time dimension

Manuel Aristarán manuel at jazzido.com
Mon Jan 11 16:15:26 EST 2016

I've solved that using the undocumented LastNonEmpty function. The formula, in your case, would look something like:

	([Measures].[SEMIADD_MEASURE], LastNonEmpty(Descendants([Time].CurrentMember), [Measures].[SEMIADD_MEASURE]))

Hope this helps,

Manuel Aristarán
http://jazzido.com <http://jazzido.com/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160111/121d9e13/attachment.html 

More information about the Mondrian mailing list