I'm attempting to query a cube from ISQLW

SELECT a.*
FROM OPENROWSET( 'MSOLAP.2', 'DATASOURCE=myDB; USER ID=; PASSWORD=;Initial
Catalog=SalesDWH;',
'select [Measures].[members] on columns, [OppRegion].[All Opp Region]
on rows from [SalesCube] '
) AS a

Here's there error it returns:
OLE DB provider 'MSOLAP.2' reported an error. Access denied.

I'm logged into ISQLW with Windows Authentication. My login has all
permissions for the cube. Any help is appreciated.

Doug

I've tried the following (very similar) query in QA and it works:

SELECT a.*
FROM OPENROWSET( 'MSOLAP.2', 'DATASOURCE=<Analysis Server Name>;Initial
Catalog=Foodmart 2000;',
'select [Measures].members on columns, {[Store].[All Stores]} on rows
from [Sales] '
) AS a

You should replace <Analysis Server Name> with the name of your Analysys
Server.
Notice that square brackets should be removed from Members, since it is an
MDX functions, and curly brackets should be added to [OppRegion].[All Opp
Region], to convert it to a set. Otherwise, even if access were granted, MDX
syntax errors would be returned.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Doug Stiers" wrote: