Re: Product dimension with SKU and Product Name?
- From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
- Date: Tue, 05 Jul 2005 16:05:41 -0700
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/microsoft.public.sqlserver.olap/msg/
f8766b64255a1d2c
>>
Newsgroups: microsoft.public.sqlserver.olap
From: Deepak Puri <deepak_p...@xxxxxxxxxxxxxxx>
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 ***
.
- References:
- Product dimension with SKU and Product Name?
- From: Olav Tollefsen
- Product dimension with SKU and Product Name?
- Prev by Date: Re: Action to reporting services
- Next by Date: Re: Cubes
- Previous by thread: Product dimension with SKU and Product Name?
- Next by thread: Re: Action to reporting services
- Index(es):
Relevant Pages
|
