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...