Guest_imported
New member
- Jan 1, 1970
- 0
Hi all,
I have set up a linked server in SQL Server 2000 to an instance of Analysis Service (runs on the same box as SQL) and am now trying to use (in query analyzer on the server) :
SELECT * FROM OpenQuery(mylinkedserver, 'SELECT {[Measures].Members} ON COLUMNS, {[Business Units].Members} ON ROWS FROM [CEO_VIEW]')
According to stuff I've found on the MS site this is supported. However, I'm getting an error :
OLE DB provider 'MSOLAP' reported an error.
[OLE/DB provider returned message: Cannot open cube 'CEO_VIEW'.]
The MDX query runs fine in the MDX sample application, and I have added 'Everyone' to a role to access the cube.
Any help would be much appreciated...
Thanks,
Andrew
I have set up a linked server in SQL Server 2000 to an instance of Analysis Service (runs on the same box as SQL) and am now trying to use (in query analyzer on the server) :
SELECT * FROM OpenQuery(mylinkedserver, 'SELECT {[Measures].Members} ON COLUMNS, {[Business Units].Members} ON ROWS FROM [CEO_VIEW]')
According to stuff I've found on the MS site this is supported. However, I'm getting an error :
OLE DB provider 'MSOLAP' reported an error.
[OLE/DB provider returned message: Cannot open cube 'CEO_VIEW'.]
The MDX query runs fine in the MDX sample application, and I have added 'Everyone' to a role to access the cube.
Any help would be much appreciated...
Thanks,
Andrew