Document ID: TEC606261
Spec KB: How to make Date type dimension filtering by time in Query Filter of WEBI report
Description:
If you use Date type dimension as Query Filter in your Web Intelligent (WEBI) report, by default, you can only filter by date, not by date and time. In a scenario when you want to create WEBI report to show alarms that created for 4 hours duration, you cannot easily do that using Query Filter. To achieve the objective you may select "Create On" dimension in "Alarm" folder as Query Filter and set "between" operation and specify the duration. Although you have specified 4 hours duration within the same date, by default the Query Filter won't filter alarms as expected because the time portion is not honored. This KB article shows how you can configure CABI so that it honors specified time in Date type dimension as the Query Filter.
Please select the following link for more information on this subject:
Knowledge Document Link:
https://comm.support.ca.com/?legacyid=TEC606261