Kaisa's blog

november 2009 - Posts

• More on DMV

  Learning how to read cube metadata through SQL Server queries sparked a few ideas, so today I had to find more information about this. Once again, Vidas Matelis provides interesting information. SSAS 2008 DMVs – querying from the SQL Server and Read More posted 19-11-2009 10:40 by kaisa | 0 Comments Filed Under: MDX and Analysis Services

• 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 Read More posted 18-11-2009 05:45 by kaisa | 0 Comments Filed Under: MDX and Analysis Services

• My first experience with Joomla

  Since January this year, I've been responsible for running a website for Od@ -nettverk, a network / community for women working in IT in Norway. By now we have more than 900 members. Our web site runs Joomla 1.5. Coming from a strictly Microsoft Read More posted 18-11-2009 05:27 by kaisa | 0 Comments Filed Under: Joomla

• How to: process only dimensions in batches with a PowerShell script

  Sometimes, you want to process all your dimensions in one go, before processing your cube. This isn't an option in SSMS, you either do the dimensions one after the other manually, or you go for the whole database. Fortunately, Vidas Matelis has Read More posted 18-11-2009 04:52 by kaisa | 0 Comments Filed Under: MDX and Analysis Services

• How to: create an SSAS Project from a live SSAS Database

  Sometimes you might need to download a live SSAS database into a Visual Studio project. Like if someone build an SSAS solution and then deleted the development project. Here's an explanation on how to do it: How to: Create an Analysis Services Read More posted 18-11-2009 04:45 by kaisa | 0 Comments Filed Under: MDX and Analysis Services