Hello everybody,

I developed a Sales Cube in Analysis service, I linked it
with Excel 2003, right now I´m using de sales cube in
excel, I have the next scenerio

SALES$ by year
Product 2001 2002 2003
X1 5 4 3
X2 8 5 3
X3 1 2 1
. . . .
. . . .
. . . .
Xn 1 3 7


HOW CAN I SEE THE MEMBERS PROPIERTES OF X3 OR Xn?.

FOR EXAMPLE IF A GET THE CELL WHERE IS X1 I WANT TO KNOW
THE MEMBER PROPERTIES OF IT IN THIS CASE X1 (PRICE: 2$,
BRAND: 34)

Pay attention that I defined the member propierties
(Price, Brand) of the dimension Product in Analysis
service.

Best regards!
Patrick.

Drop down the "Pivot Table" menu on the left of the Pivot Table toolbar,
and select "Property Fields..". This opens a dialog where you select
which properties to display:


http://msdn.microsoft.com/library/de.../en-us/dnexcl2
k2/html/odc_xlsql.asp
OLAP Member Property Fields are Supported

OLAP databases support a feature called Member Property Fields. Member
property fields are additional fields of information about a particular
member in the OLAP database, but information that is not part of the
dimension of information. For instance, a dimension may consist of the
levels: Customer State, Customer City, and Customer Name. And for the
field Customer Name, there might be several different other related
pieces of information about the customer that are not part of the levels
of the dimension, such as age, gender, occupation, income, and so on.
These additional related pieces of information are called Member
properties in the OLAP database, and you can use the menu item on the
PivotTable drop-down menu on the PivotTable toolbar called Property
Fields to access them.

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!