Skip to main content
Start a Conversation

Unsolved

This post is more than 5 years old

Reid3

14 Posts

1832

February 18th, 2016 08:00

ViPR SRM Custom Report: Summarizing column data on "parent" report

Overall question of this post: How can I get a parent report to correctly display a summary of column data contained on child reports?

I have been having some difficulties with creating reports that contain columns which summarize the data on child reports.  The reports seem to work, but the summarized data doesn't "add-up" to the actual values when you drill-down to the child report...and I have tried several ways of doing this. Further below are some examples in a report I created as a test, but here is a quick overview of what I want:

  • Parent Report
    • Column1: Array SID(s)
    • Column 2: Sum of Pool Capacity (of all pools) on that array
      • Child Report (Drill-down by SID)
        • Column 1: Array SID
        • Column 2: Pool Name
        • Column 3: Pool Capacity

On the parent report I desire to show the array SID(s) (we only have one VMAX in this test environment) and the sum of the pool capacity within each VMAX.  The parent report uses the following filter:

!vstatus=='inactive' & source=='VMAX-Collector' & parttype=='Storage Pool'

You can see on the parent report screenshot (below) that I have tried 3 different summary column methods.  'Sum Pool Capacity' is just defined as a value column using the filter name=='Capacity'. The other two columns are attempts at using 'sum' formulas on the child report.  No scaling is used on any of these columns and I have tried different time management settings on the columns as well as trying different sampling settings on the report itself (on the report configuration page)--though these settings change the displayed values at times, they never seem to show the actual real sum of the pool capacities. Here is a screenshot of the parent report:

Screenshot 1 - Parent Report

SRM_parent_report.PNG.png

On the first level child report there is no filter, but I have defined the 'device' property as an Expansion property on the 'Filtering and Expansion' tab. Also on the child report I have defined Formulas that to summarize the name=='Capacity' metric so that it accessible to the parent report columns, as previously explained.  Here is a screenshot of the child report:

Screenshot 2 - Child Report

SRM_child1_report.PNG.png

From the screenshots of the reports you can see that the Capacity numbers displayed on the child do not add up to the value that displays on the parent report.  How can the data on the parent summarize properly?  If you are interested, attached please find a report template of this test report.

Any thoughts and recommendations on this issue are welcomed!

Thanks,
REID

1 Attachment

Flo_csI

2 Intern

 • 

166 Posts

February 22nd, 2016 03:00

Hi Reid,

You are on a good track ; and your issues are probably just a matter of collection discrepancies.

First thing to do is to create your report structure.

You a report that list for every array the pool capacity. So you have to :

1. filter on this data set

2. list every array

3. list every the pool to be able to sum them

Edit_Mode_-_pool_report_-_EMC_M_R.png

Then we will calculate the sum of pool capacities ; to do so you need to :

1. Go to your pool "atomic" element, here the node name part, and encapsulate the metric.

    To do so we use the formula named "MakeRange" ; it being used to make sure even if there is collection issue (collector stopped or missing polling cycle) we can still have the latest known value to do our calculation.

    This formula to work properly also needs proper time management settings (usually last week, 1 day, last)

2. At the array level, node named "device", sum the pool capacity.

    For that use-case we must use the spatial sum (another post will come to explain the differences)

    You can also configure your table report to list the Pools with their Capacity

3. Last but not list configure your first node display the array name with its total

Edit_Mode_-_part_-_EMC_M_R.png

Edit_Mode_-_part_-_EMC_M_R.png

Edit_Mode_-_device_-_EMC_M_R.png

And here is the results :

Report_-_pool_report_-_EMC_M_R.png

Report_-_000195700949_-_EMC_M_R.png

Let me know if you have questions

1 Attachment

Reid3

14 Posts

February 22nd, 2016 12:00

Bauagonzo,

Brilliant! Thanks for your help!  I got it working as you outlined, but it took a little effort playing with some things.  I'm re-posting how I created the report with some more detail so that hopefully others can benefit.

First, create the primary node for the report, called 'storage pool' and set the following options:

Primary node Filtering and Expansion:

srm_primary_node_filter_and_exp.PNG.png

Primary node Report Configuration:

srm_primary_node_report_configuration.PNG.png

After this, I created the next node in the report--named 'device' and set the following options:

Device node filtering and expansion:

srm_device_node_filter_and_exp.PNG.png

Device node Report Configuration:

srm_device_node_report_configuration.PNG.png

After this I created the 'part' node with the following options:

'part' node Filtering and Expansion:

srm_part_node_filter_and_exp.PNG.png

'part' node Report Configuration:

srm_part_node_report_config.PNG.png

'part' node formula utilizing the 'MakeRange' function:

srm_part_node_formula.PNG.png

Now I go back to the 'device' node and setup a formula that does a Spatial Sum on the output of the MakeRange formula on the 'part' node.  This formula will be used on the primary node of the report:

srm_device_node_formula.PNG.png

Now define the table columns on the 'device' report node:

srm_device_node_table.PNG.png

Now go back to the primary node and setup the columns for the table:

srm_primary_node_table.PNG.png

And at that point I think the report was working properly.

Thanks for your help.  I hope this increased detail will help others.

Thanks,
REID

Was this post helpful?

View All

No Events found!

Top