Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)

There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.

Exploded Pie Chart for Analysis Services Data

MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.

How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)

I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?

Stacked Bar Chart for Analysis Services Data

Put the stacked bar chart to work in your own business environment. BI Architect Bill Pearson continues his hands-on introduction to Reporting Services charts based upon Analysis Services data sources.

Overview of the Analysis Services Development and Management Environments

SQL Server 2005 introduces a rich set of tools supporting the development and management of Business Intelligence applications. This includes applications using Analysis Services (OLAP and Data Mining), as well as Reporting Services and Data Transformation Services (DTS).

Attribute Discretization: Using the “Equal Areas” Method

Get hands-on exposure to the use of the "Equal Areas" discretization method in Analysis Services. Join BI Architect Bill Pearson as he continues to explore Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.

Attribute Discretization: Using the Automatic Method

Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.

Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO

This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.

The LEVEL_NUMBER Member Property

BI Architect Bill Pearson introduces the LEVEL_NUMBER intrinsic member property, supported by SQL Server 2005 Analysis Services, and leads a hands-on exercise providing sample uses.

SQL Server Analysis Services