Welcome to Spipp.net server Sign in | Join | Help

Kaisa's blog

On Reporting Services, Sharepoint, dotText and Larp

How to: Query an OLAP cube for processing information

Sometimes you just want a list of when were my dimensions last processed, or when was the schema updated last? You can always right click on the dimension and look at the Properties, but if you want to check for more than 1 dimension, that's kind of slow.

Once again, I've found some scripts and code from Vidas Matelis

Using SSRS to report SSAS 2008 database structure using DMVs

http://www.ssas-info.com/VidasMatelisBlog/144_using-ssrs-to-report-ssas-2008-database-structure-using-dmvs

It's a lot quicker to just fire some sql queries against a linked server to list "Last processed date" than checking one dimension at a time.

Note: Vidas Matelis blog engine changes the quotes and double quotes up a bit, so you'll need to run a find/replace on these characters in order to get it to work.

Published 18-11-2009 05:45 by kaisa
Filed Under:

Comments

No Comments
New Comments to this post are disabled

News

Random blogging about my daily work and life in general. Locations of visitors to this page

Post Calendar

<november 2009>
mtotfls
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456

Search

Go

Syndication

SkinName:iroha_Blog2
Powered by Community Server, by Telligent Systems