Databases Reference
In-Depth Information
nection to specify the connection details. Select the Data source type
as Microsoft SQL Server Analysis Services. This dialog lacks the
ability to launch the Connection Manger dialog to specify the connec-
tion parameters. You can obtain the connection to an Analysis Ser-
vices database by creating a data source in Analysis Services pro-
ject or Report Designer project. Type the connection string as "Pro-
vider=MSOLAP.3;Data Source=localhost;Integrated Security=
SSPI;Initial Catalog=AnalysisServices2005Tutorial" as shown in
Fig-
ure 17-45
. Finally you need to specify the credentials under which
Report Server needs to connect to the Analysis Services database.
Select the Windows integrated security for the credentials and click
OK.
Figure 17-45
3. Right-click on the Analysis Services data source created in step 2
and select Generate model as shown in
Figure 17-46
.
Search WWH ::
Custom Search