56 views

Description

Looking at the data on the indicator from analytics hub with time series as "Fiscal Quarterly" shows records from the earlier fiscal quarter, resulting in an incorrect score.

Steps to Reproduce

Reproducible on demonightlynewyork:
1. Generate Fiscal Periods, with regular type:
Start month 11 ( November)
Unit = Quarter
Generate for about 2 years 2018-2020 data.
https://demonightlynewyork.service-now.com/nav_to.do?uri=%2Ffiscal_period_list.do

2. Update the system property: com.snc.pa.fy_start = 11 ( November)
https://demonightlynewyork.service-now.com/nav_to.do?uri=sys_properties.do%3Fsys_id%3Dbca93733d7130100ba986f14ce610334

3. Create a new indicator source: (Example: https://demonightlynewyork.service-now.com/nav_to.do?uri=pa_cubes.do?sys_id=4e5f2d12db994010c28f5223dc96197f )
Frequency = Fiscal quarterly
Facts Table = incident
Condition: Opened on This Fiscal Quarter (Expand Schedule option to find this option)

4. Create a new indicator to use this indicator source from step 3
https://demonightlynewyork.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=0bbf6d92db994010c28f5223dc961969%26sysparm_view=automated

5. Associate this indicator with a job and run the job for last years fixed schedule: (2018-11-01 to 2019-11-25)
https://demonightlynewyork.service-now.com/nav_to.do?uri=sysauto_pa.do?sys_id=5fff29d2db994010c28f5223dc9619ab

6. Run the job as System Administrator user and observe the date conditions on the logs.
https://demonightlynewyork.service-now.com/nav_to.do?uri=pa_job_logs.do?sys_id=8640b116db994010c28f5223dc961983

Result: Even if there are records for the fiscal quarter the hub shows 0 records.
Expected Result: The date condition should evaluate correctly for "Fiscal quarter schedule" correctly based on system timezone.

Workaround

There is no known workaround for this issue.


Related Problem: PRB1376093

Seen In

SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-11-15 10:47:46
Published:2020-02-18