Hi Group

I am trying to create a calculated member which counts distinct dimension properties. Is this possible??? Here is an example of my MDX query:

DistinctCount ( [TripNumber].members.Properties ("TripDateTime") ) * TripCapacity



Does this look possible??? Any help would be greatly appreciated :-)

Thanx

Tom


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...