Member properties with DIMENSION PROPERTIES

[chewza]

Hi there,

I'm trying to return (as rows), the customer name, and the gender of the customer. I am trying to use the "DIMENSION PROPERTIES" to achieve this - see below (uses Foodmart 2000 db). Runs ok, but query result is the same regardless of whether I put in PROPERTIES [Customers].[Gender] - seems to have no effect on axes!

Help

Regards

Chris

 

[justins57]

You can use DIMENSION PROPERTIES, but I prefer to use MEMBER PROPERTIES like this

With
MEMBER [Measures].[Gender] As '[Customers].CurrentMember.Properties("Gender")'
SET RowSet As 'Descendants([Customers],[Customers].[Name])'
SET ColSet As '{[Measures].[Gender], [Measures].[Unit Sales]}'
Select
ColSet on Columns,
RowSet on Rows
From Sales

hth,

Justin