Analysis Services performance monitoring starts with one habit: take measurements before users complain. This guest post by Bill Anton explains what to measure for processing and for queries, and why the OLAPQueryLog table tells only part of the story.
SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action
SSAS actions let users open a report, a web page or drill through from cube data. Here is what actions are and how to build a Reporting Action step by step.
SQL SERVER – What is SSAS Tabular Data Model and Why to Use It – Part 2
Part 2 of my SSAS Tabular Data Model series: define measures in your tabular project and then analyze the results in Excel, step by step.
SQL SERVER – What is SSAS Tabular Data Model and Why to Use it
Tabular mode is new in SQL Server 2012 Analysis Services. Here is what the SSAS Tabular Data Model is, why to use it over multidimensional and how to start one.
SSAS Tabular vs Multidimensional: Choosing for a New Project
Compare Tabular vs Multidimensional for SSAS projects, including storage, relationships, write-back, team skills, and model checks.
Tabular Models for the SQL Developer
Tabular models for the SQL developer add relationships, measures, security, and reusable semantics above SQL tables; learn when a view is enough.
SSAS Cube Performance: Diagnosing a Sudden Slowdown
SSAS cube performance diagnosis starts with the exact slow request. Follow storage, MDX calculations, cache, processing, and resource evidence before choosing a fix.