2017-04-14 07:41 AM
I have developed a report which have 3 sections: Trending Line chart by month, Capacity Bar Chart (Total, used and unused) and List by arrays.
It was working fine for some time, till some days back. User started complaining that capacity shown in reports are 2 or more times the original capacity which was shown in earlier reports and there was no addition of disks on those arrays.
During analysis I found that there are multiple firmware versions of those arrays and users then confirmed that they have upgraded firmware. So to fix that double counting capacity I decided to use latest date filter in the report. It fixed the capacity in list but broke the trending chart. Now after putting filter, instead of showing all months past and projection, it is only showing latest month.
So what can be done that report show only latest data in list but read historical info to create trending chart.
Attaching here is XML copy of that report and 2 report output snapshots with and without using latest date filter.
I am using OCI 7.2.3 and Storage and Storage Pool Capacity DM.
2017-04-21 02:06 AM
Are you using Report Studio for this, or Workspace Advanced? Do your three different sections of your report all leverage to the same query?
If so, the easiest thing to do would be to copy the query and have the table use the 'new' query, then apply the 'latest' filter only to that query. I think you'd probably have to do this in Report Studio.
Does that make sense?