I am running an ASP page to retrieve all base levels for 7 Dimensions. It
works perfect until I increase the number of leaves in a specific dimension
(train).

MDX:

SELECT {[Time].[2004.OCT], [Time].[2004.NOV], [Time].[2004.DEC],
[Time].[2005.JAN], [Time].[2005.FEB], [Time].[2005.MAR], [Time].[2005.APR],
[Time].[2005.MAY], [Time].[2005.JUN], [Time].[2005.JUN], [Time].[2005.AUG],
[Time].[2005.SEP]} ON COLUMNS , { Hierarchize(Descendants([RESCENTER].[" &
AC1 & "],1,LEAVES)) * Hierarchize(Descendants([ACCOUNT].[840300],999,LEAVES))
* Hierarchize(Descendants([BUSLINE].[All_BL],999,LEAVES)) *
Hierarchize(Descendants([FUNCTN].[All_FN],999,LEAVES)) *
Hierarchize(Descendants([LOCATION].[All_LC],999,LEAVES)) *
Hierarchize(Descendants([TRAIN].[All_RT],3,LEAVES)) *
Hierarchize(Descendants([CATEGORY].[Budget],1,LEAVES))} ON ROWS FROM [FIS]
WHERE ( [Measures].[SIGNEDDATA] )


The error that I am getting back from the server is:

Microsoft® OLE DB Provider for Analysis Services error '80004005'
An unexpected internal error has occurred.

I am assuming that I have some kind of an error in my MDX syntax. Could
somebody please take a look at this.

Thank you.

Paste that MDX into the sample app and run it. What is the error you get, if
any?

"Dejan R." wrote:

In the case "Hierarchize(Descendants([TRAIN].[All_RT],1,LEAVES)) *" it works
fine, once I increase the leaves
"Hierarchize(Descendants([TRAIN].[All_RT],3,LEAVES)) *" it gives me this
error:

Microsoft® OLE DB Provider for Analysis Services error '80004005'
An unexpected internal error has occurred.

"SQL McOLAP" wrote: