Database Reference
In-Depth Information
How to do it...
The steps involved in creating the report for this recipe can be grouped into the following
two tasks:
• Creating the Events Levels shared dataset
• Creating a report that uses the shared dataset to prepopulate a parameter
Creating the Event Levels shared dataset
The Event Levels shared dataset lists all the available event levels from the Operations
Manager Data Warehouse. The dataset returns the event level ID and the event level name.
Perform the following steps:
1. Start Report Builder.
2. On the
Getting Started
page, select
New Dataset
, as shown in the following
screenshot:
3. Under
New Dataset
, select the
OperationsManagerDW
data source. If it is not
listed, click on
Browse other data sources…
and browse to the location of the
OperationsManagerDW
data source. Click on
Create
.
4. When prompted to
Enter Data Source Credentials
, select
Use the current Win-
dows user
or type the password for the service account and click on
OK
.