Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 cube as data source

Author  Topic 

IBoonZ
Yak Posting Veteran

53 Posts

Posted - 2009-03-23 : 08:05:28
Hi

I am sure this question is already asked, but i dident find a post
that explains, how do i link my cube i just made as a data source for SSRP?

Ty in advance

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-03-23 : 08:30:19
Create a datasource as type SQL Analysis Services and get a connection string for the cube (the easiest way to do this is to open the cube in something like excel and copy the connection string created). You now have a connection to your cube. You can then build a report model if you want to, but the users can only access this if they have certain rights.
Go to Top of Page

IBoonZ
Yak Posting Veteran

53 Posts

Posted - 2009-03-23 : 08:40:41
yup worked :)

Thx
Go to Top of Page
   

- Advertisement -