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

User Guide 33
f. Click the arrow button at the right end of the filter box.
g. Drag File Name to the “drop a dimension here” field after the For Each label.
h. Drag ‘File Server Name’ to “drop a dimension” here” field after For Each label.
i. Drag ‘Volume Name’ to “drop a dimension” here” field after For Each label.
3. Create the necessary variables using the following formulas:
4. Add a “Rank_Condition” report filer to rank the file name based on the file access time:
a. Click Show/Hide filter pane.
b. Drag the Rank_Condition variable to the Report filter pane.
c. Select Not equal to from the Operator drop-down menu and set the value to 0.
Variable Name Formula
UsedResponse =ToNumber(UserResponse("Top x File Name
(Enter x)"))
File_Rank =Rank([File Accessed]; ([File Server
Name];[Volume Name];[File Name]); ([File
Server Name];[Volume Name]))
Rank_Condition =If([File_Rank]<=[UserResponse] ForAll([File
Name]) ForEach([Volume Name]);1;0)