Does the ADOMD.CELLSET object support the dimension properties statement?
If so, how to use it?

An other task, can i conditional format in Excel a value cell depending on
the value of a member on the column axis (ie the day from the time
dimension) and a property value of a member on row axis (ie contact_date of
client dimension)?
For example, I want to mark in red all the sales for a certain client who
purchased before the contact date.

Thanks in advance

Massi

The DIMENSION PROPERTIES is included in the MDX query sent to the server.
Here's an example that request the intrinsic member property MEMBER_TYPE and
the user defined property Gender. (This sample works on Foodmart 2000.)

select Head(Customers.[Name].Members, 10) DIMENSION PROPERTIES MEMBER_TYPE,
Customers.[Name].Gender on 0 from Sales

You can then find the properties requested in the Properties collection on
the Member objects in Adomd. Note that for user defined member properties
you need to qualify the property with the level to which it applies.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Massi" <massi (AT) tiscali (DOT) it> wrote