SSAS Partition wise Processing Report
SSAS Cube gets data and do pre aggregation from OLTP systems when we process the cube. We can divide the…
Category: SSAS
SSAS Measure Group wise Query performance Report
While monitoring the performance of SSAS Cube, we can drill down the performance monitoring at Measure group levels. Cube contains…
SSAS Query Performance Detail Report
The objective of this article is provide information on how to monitor Cube performance by logging their query logs and…
SSAS Multi-Dimensional Cube Storage Modes
Below is the SSAS cube storage table which is helpful in choosing the right storage mode for your application based…
SSAS 2012 – Multi-Dimensional Handout
Topics Dimensional Modeling Building a Cube Dimension Usage Namedset Calculated Member KPI Drill Through Partition Design Aggregation Perspective Translation Browsing…
SSAS – XMLA script to restore the Analysis database
This script provides an easier way of restoring the analysis DB and it is useful when replica or snapshot of…
SSAS – XMLA script to Backup Analysis Database
This XMLA script that supports SQL Server Analysis Service is used to take the backup of Analysis database. Change the…
How to process OLAP Cube using SQL Server Agent Job
1. Background The purpose of this document is to describe a way of processing OLAP cube using SQL Server Agent…
Overview of SQL Server BI Model
SQL Server Business Intelligence Model basically consists of four main services i.e. SQL Server Relational services, Integration Services, Analysis Services…
SSAS – How to create Analysis Database Snapshot or Cube Snapshot
1. Background The purpose of this article is to provide detail information about how to create an Analysis Database Snapshot…
How to design calculated members in SSAS
1. Background The purpose of this document is to describe how to create Calculated Members in the cube and how…
SSAS –Design Aggregation and Usage Based Optimization
1. Background The purpose of this document is to provide details on importance of aggregation, how effectively we can design…