Measures

Dimensional Model Components: Dimensions Part II

Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.

Enabling Drillthrough in Analysis Services 2005

Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.

Check List for Performance Optimisation in SQL Server Analysis Service 2005

This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.

Measures

The Unpopular SELECT Statement

SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.

Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets

Join BI Architect Bill Pearson as he continues his examination of parameterization within Analysis Services reports. In this article, we provide a solution for supporting parameter defaults that represent the last periods of data entry within our cube.

Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP

This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few product limitations, as well as enterprise considerations. It is based on a real-world implementation by Microsoft Business Intelligence Center of Excellence.

Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source

Learn how to use an Analysis Services cube as a data source by using parameterized MDX queries, as well as how to localize label strings in a report, in SQL Server 2005.

Set Functions: The .AllMembers Function

Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples.