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