Results 1 to 3 of 3

Thread: OLAP Problem!

  1. #1
    Join Date
    May 2007

    Question Unanswered: OLAP Problem!

    I'm trying to retrieve calculated members from a cube using the OPENQUERY function and a OLAP linked server, the results from MDX Queries are then stored to a SQL Server DB Table.

    below is the error message I get:

    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].[first column] STATUS=DBSTATUS_E_UNAVAILABLE], [COLUMN_NAME=[Measures].[second column] STATUS=DBSTATUS_E_UNAVAILABLE]]

    When I run the same query in MDX Sample Application it works fine!

    Any help Please!

  2. #2
    Join Date
    Apr 2007

    did you find a resolution?

    Hi there i am also getting an error of the same soret, just wondering if you found the problem?

  3. #3
    Join Date
    May 2007
    No I havent yet.I will write back if I do

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts