Report Portal

Using Annotation Tables in SSAS to Show Last Processed Time and Latest Data Updates as a Measure in a Cube

Annotation Tables and leveraging the fact the formula engine of SSAS support non numeric calculation results is a very strong feature that can be leveraged to show just about anything as a measure in a cube.

In this article I am going to walk through how you can expose two pieces of useful information to end user as simple measures in a cube. The two are Cube Last Processed Date and Latest Data Update Date.

Read more...

 

Tags: design, mdx

 

2007-2015 VidasSoft Systems Inc.