Report Portal

Account Balances and retrieving the last record in Fact Tables

Everyone knows how LastNonEmpty behaves according to the official documentation, however recently I looked at a very unique situation in which I had to retrieve the last record in the fact table for a particular time period and I thought I would share this in case anyone found themselves facing the same set of user requirements. Keep in mind that under normal circumstances you would use an ETL and modelling solution to solve the issue but in this case the user requirements and technologies made available prevented it.

Lets say you are busy working with Account Balances. With some example data below:


Tags: design, mdx


2007-2015 VidasSoft Systems Inc.