Home   |  Articles   |  Resources   |  Humor   |  Feedback       

  Login   Register 


SQL
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


Copyright 2004 OdeToCode.com 
The Blogs
Subscribe to the OdeToCode blogs for the latest news, downloads, new articles, and quirky commentary.
New Articles
A Software Developer's Guide to HTTP Part V– State & Security
An overview of cookies and authentication protocols for HTTP and web programming.

A Software Developer's Guide to HTTP Part IV– Web Architecture
Proxy servers, caching, and the flexibility of the web are the focus for this article as we view HTTP from an architectural perspective.

A Software Developer's Guide to HTTP Part III–Connections
In this article we'll look at HTTP from a networking perspective, and talk about HTTP connection optimizations like persistent connections and parallel connections.

Most Popular Articles
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.

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.

Contribute Code
Privacy
Consultancy