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

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000032963
Applies ToRSA Product Set: Security Analytics
RSA Product/Service Type: SA Reporting Engine, SA Data Warehouse
RSA Version/Condition: 10.X
IssueWhen running reports against Warehouse DB, reports run fine in table view but chart view appears empty as below.

User-added image
CauseThis 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.
ResolutionThe Limit field must contain a value less than 1000 in the Rule as below to display the chart output.
User-added image
NotesFor Timeline charts (NWDB rules), the limit is "auto adjusted". For summary charts (Warehouse DB rules), this limit is untouched.