calculated members from a cube using the OPENQUERY

We have a DTS package that runs once a month. It has been working for more than four years now, but all of the sudden it started to fail. The package starts with loading data from an sql database and then updating the cube and then send the calculated results to a SQL2000 server table.

the problem starts at the last part when reading from cube into sql2000 table. below is my select which fails:

select

convert(decimal(18,2), replace("[Measures].[Sales]", ',', '.')),

convert(decimal(18,2), replace("[Measures].[Cost]", ',', '.')),

convert(decimal(18,2), replace("[Measures].[Hours A1]", ',', '.')),

convert(decimal(18,2), replace("[Measures].[Data]", ',', '.'))

convert(decimal(18,2), replace("[Measures].[Orderlines A3]", ',', '.')),

convert(decimal(18,2), replace("[Measures].[Invoices E3]", ',', '.'))

from openquery

( GONS021_OLAP, 'select

{[Measures].[Sales], [Measures].[Cost], [Measures].[TB], [Measures].[TG], [Measures].M1, [Measures].[M2], [Measures].[A1], [Measures].[A2], [Measures].[A3], [Measures].[A4], [Measures].[A5], [Measures].[A6], [Measures].[A7], [Measures].[A8],[Measures].[T1], [Measures].[L1], [Measures].[L2], [Measures].[L3], [Measures].[E1], [Measures].[E2], [Measures].[E3], [Measures].[E4], [Measures].[E5],[Measures].[Hours A1],[Measures].[Data],[Measures].[Orderlines A3],[Measures].[Qty Returned A8],[Measures].[Invoices E3] } on columns,

{[Customer].[All Customer], [Customer].[Customer No].Members} on rows

from TotalTable where ([Time].&[2007])')

The error message:

The MDX queries executed through the OPENQUERY function returns the following error messages for some members of the dimension used to construct them:

Could not get the data of the row from the OLE DB provider 'MSOLAP'.

OLE DB error trace [OLE/DB Provider 'MSOLAP' IRowset::GetData returned 0x80040e21:Data status returned from the provider: [COLUMN_NAME=[Measures].[Data] STATUS=DBSTATUS_E_UNAVAILABLE], [COLUMN_NAME=[Measures].[Invoices E3] STATUS=DBSTATUS_E_UNAVAILABLE]]

The same MDX Queries execute without any problems through the MDX Sample

Application!

OBS: I have SP4 on both SQL and Analysis

Hi there i am wondering if you managed to solve this, as I had exactly the same problem? A query that worked previously, is now not working. I am also on SQL Server 2000 Analysis SP 4