Before you start working with spreadsheets in the Veeam VMware
PowerPivot Example workbook, connect to your Ops Mgr DW to retrieve
data from it:
1.
|
Launch Microsoft
Excel, open the PowerPivot tab
and click Manage. |
2.
|
In the
PowerPivot For
Excel window, switch to the
Home
tab and click Existing Connections. |
3.
|
In the
Existing
Connections window, select the
SCOM_DW
data source and click Edit. |
4.
|
In the
Edit
Connection window, expand the
Server
name drop-down list and choose your
server which hosts Data Warehouse. |
Click Test Connection, wait for the connection to be tested,
click OK and
then click Save.
5.
|
On the
Home
tab, click Refresh > Refresh All,
wait for the new data to be retrieved and click Close. |
6.
|
Close the
PowerPivot For
Excel window. |
|