Wrong data reported in CABI report when selecting more devices or a longer period

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Creating an UIM Metrics report in CABI, adding CI names, devices and doing Sample value (Count All) in columns.

Then using Input Controls to select the Time Range, as usual. All is fine as long as I do not select more than 4 devices or some period which is longer than 1 week or so

And I'm using 'raw data', so no aggregation. End-2-End Nimsoft Robots as Group selector. And 'Application Response Time' as metric.

See this list below to know what I mean. 3 digit devices are our Robot names.

Metrics CABI report

For up to 4 devices all looks good. Name of device, followed by QoS value [Sample value (Count All)], time period = 1 month
DET 1.352
GRZ 2.665
HGB 2.044
MER 2.056

Then, with 5 devices selected in Input Control, values are decreased (time period 1 month)

DET 1.250 (should be 1.352, -8%)
GRZ 2.436 (should be 2.665, -8%)
HGB 1.886 (should be 2.044, -8%)
MER 1.895 (should be 2.056, -8%)
PDN 1.796 (1.941 when being 1 out of 4 devices, -8%)

Even worse with 6 devices selected, (time period 1 month):

DET 1.010 (should be 1.352, -26%)
GRZ 2.000 (should be 2.665, -25%)
HGB 1.523 (should be 2.044, -26%)
MER 1.527 (should be 2.056, ...)
PDN 1.457 (should be 1.941, ...)
PUN 998  (should be 1.340, ...)

 

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - CABI REPORTS AND INTEGRATION

Resolution

Please increase the limit of the below ad hoc setting 

Ad Hoc Filter List of Values Row Limit  10000  to  100000000

Ad Hoc Dataset Row Limit  200000 to  2000000000 

Path are as given :  Cabi (UI) -> Manage - > Server Settings  - >Ad hoc Setting  - > Ad Hoc Filter List of Values Row Limit / Ad Hoc Dataset Row Limit