HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Contexts Guide (October 2008)

Creating Reports in a Complex Environment38
4. Run the report.
5. Create sections for Storage System Name and Storage Pool Name:
a. Merge dimensions on Storage System Name, Storage Pool Name, and Host Name on these
two queries by clicking the Merge Dimensions and following the screen instructions.
b. Create a section with Storage System Name.
c. Create a section with Storage Pool Name which is nested in the Storage System Name
section.
d. Right-click the “Storage pool name” section, and click Remove in the sub-menu to remove
the section name only. The following message displays:
e. Click No to delete the section cell (but not the section).
f. Similarly, right-click on the “Storage system name” section, and click Remove in the
sub-menu to remove the section name only.
6. Run the report.
7. Calculate the total cost as follows:
a. Double-click the Cost per GB column and enter:
“=Ceil([Volume Size in GB]*[Cost per GB])”
b. Right-click on the Cost per GB column, and select Format Number.
c. Select Currency in the Number Format dialog box and follow the screen to select the correct
currency format.
Host > HBA for
Dependency > HBA Ports
for Dependency
Port Name
Host > HBA for
Dependency > HBA Ports
for Dependency
WWN
Storage System > Storage
Tier Information for
Chargeback
Cost per GB
Host Managed Hosts filter
Storage System Managed Storage system filter
Class > Subclass(es) Object/Filter