Viewing 2 posts - 1 through 2 (of 2 total)
You could try this to query a cube using TSQL
sp_addlinkedserver
@server = 'OLAP'
, @srvproduct = ''
, @provider = 'MSOLAP'
, @datasrc = 'servername'
, @catalog = 'foodmart 2000'
select * from openquery
(OLAP, 'select {[Gender].[F],...
June 20, 2005 at 11:39 am
#566827
Seen the problem, don't know of the solution but as a workaround if you use the show field list toolbox and drag a field from there to the row. ...
April 24, 2003 at 11:47 am
#455276