Using member properties in MDX

In many cases, some textual content is not a member's data, but in order to display its content, we generally define the properties of the member, in order to
Use in Queries! For example, [Customers], whose sex, address, and telephone may be the property of a member, in an MDX query, we want to query the number
According to the amount, such as sales volume, sales amount, also want to inquire customer information, such as gender, address, telephone and so on. MDX provides several ways to get a member
's Properties.
1) DIMENSION PROPERTIES
Select
{[Measures]. Members} on columns,
{[Customers]. [All Customers]. [USA]. [CA]. [Altadena].children}
DIMENSION PROPERTIES [Customers]. [Name]. Gender,[customers]. [Name]. Address
On Rows
From Sales
You can query the customer's gender and address properties.
Note: In the MDX example application query syntax is correct, the data can not be displayed, whether through ADOMD and so on to get the correct??
2) Properties function
With
Member [Measures]. [Gender] As
' [Customers]. Currentmember.properties ("Gender") '
Member [Measures]. [Address] As
' [Customers]. Currentmember.properties ("Address") '
Select
{[Measures]. [Gender], [Measures]. [Address],[measures]. Members} on columns,
{[Customers]. [All Customers]. [USA]. [CA]. [Altadena].children} on Rows
From Sales
Displays information such as customer gender, address, and sales amount in MDX.
Note: The data is displayed normally in the MDX example application.