RSA Security Analytics Warehouse reports are not generating in charts like pie, bar etc.

[#1]

Article Number

000032963

Applies To

RSA Product Set: Security Analytics
RSA Product/Service Type: SA Reporting Engine, SA Data Warehouse
RSA Version/Condition: 10.X

Issue

When running reports against Warehouse DB, reports run fine in table view but chart view appears empty as below.


Image description

Cause

This is due to summary charts like Warehouse DB chart having an unlimited output limit by default when the SA GUI can only display less than 1000 values in charts.

Resolution

The Limit field must contain a value less than 1000 in the Rule as below to display the chart output.

Image description

Notes

For Timeline charts (NWDB rules), the limit is "auto adjusted". For summary charts (Warehouse DB rules), this limit is untouched.