Database Reference
In-Depth Information
Getting ready
Before we can start using SQL Server Reporting Services with Service Manager OLAP
cubes, we need to create a data source that points to the OLAP cubes. The cubes are hosted
in
DWASDataBase
on the instance of SQL Server Analysis Services used by Service
Manager. Perform the following steps:
1. Open your web browser and navigate to
http://[SCSMDWSQL]/Reports
.
Replace
[SCSMDWSQL]
with the fully qualified domain name of the SQL server
that is used for reporting. If SQL Server Reporting Service is running as a named
instance, the syntax of the URL will be
http://[SCSMDWSQL]/Re-
ports_[InstanceName]
.
2. Click on the
SystemCenter
folder, then click on the
ServiceManager
folder.
3. Click on
New Data Source
and complete the form as follows:
◦ Name:
DWASDataBase
◦ Data source type:
Microsoft SQL Server Analysis Services
◦ Connection string:
Data Source=[SCSMDWAS];Catalog=
DWASDataBase
(replace
[SCSMDWAS]
with the fully qualified domain
name of the SQL Server Analysis Services server that hosts the Service
Manager OLAP cubes)
Tip
Do not use the
Enter
key to move to the next line when typing the connec-
tion string. The text will automatically word wrap. Using the
Enter
key to
move to the next line will generate a syntax error.
4. Select
Credentials stored securely in the report server
5. Enter the username and password of an account that has read access to the cubes in
the
DWASDataBase
Analysis Services database.
6. Select
Use as Windows credentials when connecting to the data source
7. Click on
Test Connection
to validate the connection.
8. Click on
OK
to save the new data source, as shown in the following screenshot: