Hello,
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services?
thank you
regards
Andreas
Sure you can. However, you have to use the Microsoft OLE DB Provider for Analysis Services when you set up your data source in SSRS. You may find this whitepaper useful although it's been written for SSRS 2000.
|||
thank you for the quick answer. i thought of a compatibility issue because i can choose the server and the database in the driver. but when i try to send a mdx the driver always tells me that the connection is lost. Ill try it on a second server, maybe its a computer issue...
thank you
andreas
No comments:
Post a Comment