How to connect Crystal report to OLAP services

[Former Member]

hi...

i'm trying to connect to the OLAP services to retrieve the data from cubes..

i'm using microsoft oledb provider for analysis services 10 in SAP crstal report13

for VS2010..

but i'm getting the following error..

Failed to retrieve data from the database

Details: ADO Error Code: 0x80004005

Source:Microsoft OLEDB Provider for analysis service 2008

Description : Query (1.36) Parser: The Syntax for '[_DM2]' is incorrect.

Native Error : -1056047102 [Database Vendor Code: -1056047102 ]

what to do .. ?

[former_member11696]

Moved to OLAP forum.