Category Archives: SSAS

How SSAS Cube Processing Affects Running Queries

Posted on May 29, 2009 by Clay Lenhart

SSAS cube processing can kill running queries. That’s right, it may kill queries in order to commit changes to the cube.

Here is what happens during SSAS cube processing. Continue reading →

Posted in SSAS | Tagged , | 11 Comments

SSAS Beginner’s Guide: Storage Structure

Posted on April 7, 2008 by Clay Lenhart

This is a second entry in a series on SQL Server Analysis Services (SSAS). To see the other blog entries on this tutorial, click on the SSAS Beginner’s Guide on the top bar. Relational Databases Let’s take a quick look … Continue reading →

Posted in SSAS | Tagged , | 21 Comments

SQL Server Analysis Services (SSAS) Series

Posted on April 1, 2008 by Clay Lenhart

I am going to use this blog to convince a friend to use SQL Server Analysis Services (SSAS) in his projects because it makes it easier to write reports on as compared to relational databases. Part of the challenge is … Continue reading →

Posted in SSAS | Tagged , | 27 Comments

Moving SSAS databases

Posted on December 10, 2007 by Clay Lenhart

Here is an article on moving SSAS databases. The only thing to add is to be sure to set the file permissions on the folder. http://www.ssas-info.com/ssas_faq/ssas_management_faq/q_how_do_i_move_analysis_services_database_to_a_different_folder.html

Posted in SSAS | 6 Comments

SSRS filter values missing from a SSAS datasource

Posted on December 10, 2007 by Clay Lenhart

I recently ran into a problem where the list of values in a filter were missing for a dimension. It was due to having a fact relationship from the dimension to a very small fact table. In fact, the table … Continue reading →

Posted in SSAS, SSRS | 5 Comments