Text Measures, Last Process Time of SSAS Cube and Annotation Tables in a SSAS Cube

John L. Hall posted on October 29, 2010 12: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).

Posted in: Blog

Actions: E-mail | Permalink | Comments (0)

| Kick it! | DZone it! | del.icio.us

Comments

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

Post Comment

Only registered users may post comments.

LatestArticles

Changing Granularity of Leaf Level Calculations in SSAS Tabular by Jason Thomas

Finding Nearest Stores using SSRS Map Reports by Jason Thomas

Heat Maps for SSRS using Map Control by Jason Thomas

Parameters for Analysis Services Reporting: Introduction, Pt. 3 by William Pearson

BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 3 of the article, we continue to get hands-on practice cr...

Parameters for Analysis Services Reporting: Introduction, Pt. 2 by William Pearson

BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 2 of the article, we continue to get hands-on practice cr...

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

Using Color in SSRS Charts by Melissa Coates

Effective data presentation techniques help users interpret information quickly and reliably. Layout, formatting, sizing, labeling, and other report elements may all be used to facilitate ...

Is TOAD faster than BIDS Query Builder? by John Hall

SSRS: Unexplained Warning “This field is missing from the returned result set from the data source” And Checking a Field for Null Exception by John Hall

If you ever see the warning message “This field is missing from the returned result set form the data source” and get unexplained #Errors in columns on your report it may be from SSAS not returning a ...

Beyond Excel pivot tables: Leveraging cube formulas with MDX by Javier Guillen

PowerPivot and DAX are a powerful technologies, but there is still a good amount of work that can be done with traditional cube functions. In its current version, PowerPivot lacks the concept of ...

Privacy Statement