I have a MDX statement that I display on an ASP page within one second. I
display it using code that walks through ADOMD.CellSet that I probably found
on the Microsoft site.

When I add one calculated member to this MDX and use that member in the
WHERE clause, the entire statement times out and never displays. I don't
think it is the MDS itself because both MDX statements run within one second
in the sample MDX application. Anybody have any idea? I can't figure it
out. Thanks.

MEMBER [GLPostDt].[YTDSelection] AS '[GLPostDt].[2005].FirstChild.FirstChild'
.....
WHERE ([GLBizUnitType].[Revenue], [GLPostDt].[YTDSelection] )

I beleive this issue was already discovered before in this thread:

http://groups-beta.google.com/group/...90067663dece14

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"AW" <AW (AT) discussions (DOT) microsoft.com> wrote