[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