| 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] |
| |
| |
| |
|
| |
|