Category Archives: SSAS

How SSAS Cube Processing Affects Running Queries

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 , | 10 Comments

SSAS Beginner’s Guide: Storage Structure

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 , | 18 Comments

SQL Server Analysis Services (SSAS) Series

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 , | 23 Comments

Moving SSAS databases

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 | 5 Comments

SSRS filter values missing from a SSAS datasource

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