Friday
Jun012007

Tech Questions? Frame with AdventureWorks

I receive a lot of technical questions via email, often involving complex topics. Unless your question is general in nature, it's unlikely I can provide useful feedback unless you frame the question in AdventureWorks context, especially if it involves MDX.

I'm glad to field questions, but please be patient if I don't reply right away. 

Thursday
Oct302003

Getting Time Right in Analysis Services

Add June 1, 2007: This 2003 article is still pertinent with Analysis Services 2005.
________________________________

Rare is the OLAP cube that does not include a so-called Time dimension – a dimension that allows data to be analyzed over time. Though often named simply Time, the typical Time dimension is actually a date dimension, with a hierarchy consisting of Year-Quarter-Month-Day or the like. Despite the unique ever-presence of Time, this is the one dimension that developers who are new to SQL Server Analysis Services often get wrong. This article will explain the correct way to implement Time dimensions in Analysis Services, and the benefits thereof.

The full article is available at SQLJunkies.com.

Tuesday
May202003

AS2000 Cube Documentation Tool

This is a cube documentation utility for Analysis Services 2000, developed in Excel.

I have received many requests to update this tool for Analysis Services 2005. I hope to find time for this task some time soon.  

Thursday
Nov072002

Creating Calculation Dimensions

This is an example of a calculation dimension built in Analysis Services 2000. A calculation dimension is a special dimension for the sole purpose of containing MDX calculations.

Click to read more ...

Page 1 2 3