[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