|
rip.murdock
Starting Member
4 Posts |
 Posted - 08/31/2005 : 20:58:46
|
I’m trying to issue a refresh cube command to Analysis Services from SQL Server prior to issuing an MDX query.
When I use OPENQUERY like so,
SELECT * FROM OPENQUERY(mylinkedserver, 'Refresh Cube C7')
I get this error:
OLE DB provider 'MSOLAP.2' reported an error. Command was not prepared.
OLE DB error trace [OLE/DB Provider 'MSOLAP.2' IColumnsInfo::GetColumnsInfo returned 0x80040e4a: Command was not prepared.].
Any ideas on how I should prepare the command?
|
|
REFRESH CUBE command to Analysis Services from SQL
