OLAP Linked Server Problem

Is this really working ?
here is the error message I am getting, I have this 'FoodMart 2000' DB on
OLAP Server
OLE DB provider 'MSOLAP' reported an error.
[OLE/DB provider returned message: Database 'FoodMart 2000' does not exist.]
OLE DB error trace [OLE/DB Provider 'MSOLAP' IDBInitialize::Initialize
returned 0x80004005: ].

EXEC sp_addlinkedserver
@server='olap_server',
@srvproduct='',
@provider='MSOLAP',
@datasrc='OLAPServer',
@catalog='foodmart 2000'

go

-- MDX in OPENQUERY --

SELECT * FROM OPENQUERY(olap_server,
'SELECT
{ Time.Year.[1997] } ON COLUMNS,
NON EMPTY Store.MEMBERS ON ROWS
FROM Sales
WHERE ( Product.[Product Category].[Dairy])' )
.

Relevant Pages

  • RE: Adding info to query
    ... I'll try and give you an example to what I mean, it could be that the prev ... also, what if the first record is empty, there will be no previous record. ... Function LookForLastDate(IdFieldName As Double, DateFieldName As Variant) ... >>> Mike J ...
    (microsoft.public.access.queries)
  • RE: Adding info to query
    ... it sort of makes sense now. ... > compile error. ... >>> also, what if the first record is empty, there will be no previous record. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Adding info to query
    ... >> I'll try and give you an example to what I mean, it could be that the prev ... >> also, what if the first record is empty, there will be no previous record. ... >> DateFieldName),Date) As DifferentInDays From TableName ... >> LookForLastDate = DateFieldName ...
    (microsoft.public.access.queries)
  • delete rows from datagrid
    ... My problem is that whatever rows I delete, dgDeleted is always empty ... What should I do to store the deleted rows in a dataset so i can ... Thx ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Columns into 2 way tables
    ... the ctrl + alt + enter) but the cells remain empty. ... Are there any lists or ... The Output needs to be a table with 3 columns: Low, ... the corresponding name in a descending order of sales. ...
    (microsoft.public.excel.worksheet.functions)