OLAP Analysis Services Dimension Hierarchies and OWC 9

Home | Articles | Resources | Humor | Feedback

OLAP Analysis Services Dimension Hierarchies and OWC 9

Posted by scott on Tuesday, February 10, 2004

A bug in OWC 9 can prevent the display of all dimensions in a cube.

Although I cannot find any knowledge base or support article about this bug, I did confirm there is a problem with Office Web Components version 9. OWC 9 ships with Office 2000. I recently closed a case with Microsoft Support which confirmed the bug. The only workaround is to use OWC 10 (XP) or OWC 11 (Office 2003).

I designed about 8 cubes, each with 3 to 6 time dimensions. Each time dimension needed a calendar date and fiscal date variant, so I would create the fiscal and calendar dimensions as a hierarchy of a dimension. In the Analysis Service wizard, you can do this by selecting the checkbox shown below.

If you do this for more than one “pair” of dimensions, only the first “pair” will display in the pivot table field list in OWC 9. The only fix seems to be to upgrade OWC. The dimensions do appear properly in the MMC cube browser, in Data Analyzer, and in later version of OWC.

More information

Office 2003 Add-in: Office Web Components Download

Office XP Add-in: Office Web Components Download

HOW TO: Find Office Web Components (OWC) Programming Documentation and Samples

How to Deploy the Office 2003 Web Components in an Office 2003 Program

The Blogs
Subscribe to the OdeToCode blogs for the latest news, downloads, new articles, and quirky commentary.

New Articles
C# 3.0 and LINQ
C# 3.0 introduced a number of new features for LINQ. In this article we'll examine the new features like extension methods, lambda expressions, anonymous types, and more.

Introduction To LINQ
This article is an introduction to LINQ and provides examples of using LINQ to query objects, XML, and relational data.

What ASP.NET Developers Should Know About JavaScript
This article looks at JavaScript from the perspective of a C# or Visual Basic programmer. See how to apply object oriented techniques to your JavaScript code.

Most Popular Articles
ASP.Net 2.0 - Master Pages: Tips, Tricks, and Traps
MasterPages are a great addition to the ASP.NET 2.0 feature set, but are not without their quirks. This article will highlight the common problems developers face with master pages, and provide tips and tricks to use master pages to their fullest potential.

Table Variables In T-SQL
Table variables allow you to store a resultset in SQL Server without the overhead of declaring and cleaning up a temporary table. In this article, we will highlight the features and advantages of the table variable data type.

AppSettings In web.config
In this article we will review a couple of pratices to keep your runtime configuration information flexible.

Contribute Code
Privacy
Consultancy