How to create a Report Model based on SSAS ?
I'm following the steps from Books Online (http://msdn2.microsoft.com/en-us/library/ms159118.aspx), and I'm stumbling on the following:
In theConnection string box, enter the connection string that points to the Analysis Services cube
How does the connection string need to look like ? My other connections is RS projects are OLE DB connections, but Books Online says that the connection type must beMicrosoft SQL Server Analysis Services.
I've tried "Data Source = MyServer\MyInstance", but that won't work.
Can someone help ?
[750 byte] By [
AlanKohl] at [2007-12-26]
Hello. This problem have left me spending a few hours to look for answeres. If you download the SP2CTP of Books on Line you will find the answeres. My description covers SP1 of SQL Server 2005, so it is only the BOL SP2 CTP1 that you will have to download.
1.You cannot do this directly in BI-Dev Studio, unless someone have a workaround.. Why, I do not know.
2. You can do this in the report manager. You will have to build a connection/data source first. In BOL SP2 CTP1 you will find instructions. With a valid SSAS2005 source in RM you build the report model. You can see this at the end of the data source page.
3. Right click on a SSAS2005 data source in Management Studio(for reporting services) and build your report model(Generate model).
HTH
Thomas Ivarsson
