The query below returns several member properties for the Customer Cedric Wang.
|
|
WITH
MEMBER Measures.MemName AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Name')
MEMBER Measures.MemUniqName AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Unique_Name')
MEMBER Measures.MemVal AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Member_Value')
MEMBER Measures.MemKey AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Key')
MEMBER Measures.MemID AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('ID')
MEMBER Measures.MemCaption AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Caption')
MEMBER Measures.MemAddress AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Address')
MEMBER Measures.MemPostCode AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Postal Code')
MEMBER Measures.MemPhone AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Phone')
MEMBER Measures.MemFirstPurch AS [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Date of First Purchase')
SELECT {Measures.MemName,
Measures.MemUniqName,
Measures.MemVal,
Measures.MemKey,
Measures.MemID,
Measures.MemCaption,
Measures.MemAddress,
Measures.MemPostCode,
Measures.MemPhone,
Measures.MemFirstPurch
} ON COLUMNS
FROM [Adventure Works] |
|
|
|
|
|
|
The query below returns the Internet Order Count for all Customers that have a Postal Code property of 91940. |
|
SELECT {[Measures].[Internet Order Count]} ON COLUMNS,
FILTER([Customer].[Customer Geography].[Customer].Members, [Customer].[Customer Geography].CurrentMember.Properties('Postal Code') = '91940') ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|