Report Portal

Rolling X month / X week calculations in MDX using NonEmpty

Implementing a rolling x month or x week calculation in MDX is relatively straightforward if you have a calendar hierarchy in the multi-dimensional cube. In some cases, you may only want to include dates where a measure is non-empty. For example, if a user selects the current month, you may not want to include any future weeks that are empty in the rolling calculation.

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.