29

Annotation tables and the fact that SSAS formula engine allows non numeric measures can be a very powerful tool to show just about anything as a measure in a cube.  I just published an article that show how to put non-numeric measures in a cube using annotation tables.  The sample show you how to  display a good approximation of the last processed date of the cube or any other text you would like to display.  Using Annotation Tables in SSAS to Show Last Processed Time and Latest Data Updates as a Measure in a Cube (  http://www.msbicentral.com/Blogs/JohnHall/tabid/132/articleType/ArticleView/articleId/127/Using-Annotation-Tables-in-SSAS-to-Show-Last-Processed-Time-and-Latest-Data-Updates-as-a-Measure-in-a-Cube.aspx).

powered by metaPost
Posted in: Blog

Comments

There are currently no comments, be the first to post one.

Post Comment

Only registered users may post comments.
  Minimize

picture of John Hall

John Hall


Our Blog Friends Minimize

Advertisement Minimize

Copyright 2004-2012 MSBICentral.com Terms Of Use Privacy Statement