I want to create a Product dimension of a table which contains a SKU column.
The SKU is also linked to another table which contains Product names for
each SKU.

I would like to build the cube in a way that when a user using the Office
PivotTable Web Component drags in the SKU and the Product Name into the
table, both the SKU and the Product Name will be visible at the same level
without having to drill down from the SKU to see the Product Name like this:

SKU Product Name
10001 T-shirt
10002 Jeans

How do I create the Product dimension to allow this? I have tried having
Product Name in a level below SKU, but then you have to drilldown to see the
Product Name.

Olav

You can define the Name as a Member Property - which can be added to an
OWC Pivot Table as listed in this post. If you can use AS 2005 (Yukon),
then SKU and Product Name can both be "stacked", as attributes of the
Product dimension.

http://groups-beta.google.com/group/...rver.olap/msg/
f8766b64255a1d2c
From: Deepak Puri <deepak_p... (AT) progressive (DOT) com>
Date: Fri, 10 Jun 2005 18:49:08 -0700
Subject: Re: OWC11 - display other properties on the PivotTable

Hi Elena,

There are a couple of ways to access Item Properties in the OWC Pivot
Table

- As I mentioned, if you right-click on a Field (on rows or columns),
the Context Menu includes an option; "Show Properties in Report", which
is only enabled if that Field has any (custom) Properties.

- The Commands and Options... Menu can be used.

This is an excerpt from the OWC Pivot Table Help:

About item properties

You can display additional information about items by displaying the
custom properties of a row or column field.

For example, if the database administrator has made available two custom
properties, Manager and Phone Number, for the Store field, you can
choose to display the property values for each item in the Store field,
either in the PivotTable list or as ScreenTips.

The following illustration shows how the Employees report will look with
the custom properties Education and Yearly Income displayed in the
report.

The users of a PivotTable list cannot create custom properties. However,
they can show or hide properties, and choose whether the properties are
displayed in the report or as ScreenTips.

The following illustration shows the Education property displayed in the
report and the Yearly Income property displayed in the ScreenTip.

The users of the PivotTable list can also format the property captions
and values, and specify the order in which the properties are displayed
in the report or ScreenTip.

Non-OLAP data sources do not support custom properties.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***