Error 80004005 An unexpected internal error has occured -
10-21-2003
, 10:09 AM
Hi all,
I'm trying to open a cellset and this error message returns after a
certain amount of time (~20 secs). The MDX I'm executing is:
SELECT NON EMPTY([Measures].Members) ON COLUMNS, NON EMPTY
(Descendants ([Company].[All Company], [Company].[(All)], AFTER) *
Descendants ([Counterparty].[All Counterparty],
[Counterparty].[(All)], AFTER) * Descendants ([Account].[All Account],
[Account].[Parent Accounts], AFTER)* Descendants ([Currency].[All
Currency], [Currency].[(All)], AFTER)) ON ROWS FROM ChildTemp WHERE
([Period].[Jan 03])
Admittedly I have a lot of dimensions on one axis, but I do need them
there.
I'm presuming that this is some problem with the amount of data I'm
trying to return. Any ideas of how to get around this problem? Will I
have to try and split up my MDX so as not to crossjoin so many
dimensions on the rows?
Regards
Terry Maguire |