@UC Paul -
The "Daily" vs "Fiscal Month" is probably a red herring. If I'm interpreting the documentation correctly, "Valid for frequency" (pa_cubes.frequency) applies only to a Calendar of "Standard Calendar." "Calendar Frequency" (pa_cubes.calendar_freq) applies only to a Calendar of "Fiscal Calendar."
Sayeth the docs:
- If you select the standard calendar, you have the Valid for frequency field. This field gives you a choice of standard indicator frequencies. The default choice is Daily.
- If you select a business calendar, you have the Calendar Frequency field. This field is required. The business calendar you selected determines the range of frequencies that are available.
Since the default choice for Standard Calendar is Daily, and since you're using Fiscal, I wouldn't worry too much about seeing Daily there; the system is probably ignoring that and is looking at the calendar_freq field for the configuration.
When I think of possible causes for this issue, I wonder if the Indicator Source was using Standard Calendar at one point & then got changed to fiscal. I also wonder if perhaps there were changes to the fiscal calendar setup for your organization. Because either of those could cause significant data inconsistencies.
Additionally, I have seen "parent" records cause some weirdness; I see that your Fiscal Months have parent records. The weirdness I saw was not on the PA side but was in another SN application, but it was inexplicable data inconsistency that we ultimately traced back to parent record issues.
It may be interesting to look at records in one of the PA Scores tables to see if you're able to glean anything of use from looking at the records directly.
Definitely an interesting quandary 😁 if you get it figured out, please let us know what you found.
thx
David
David Hepburn, III (he / him) | Paramedic
CSA, Senior Enterprise Application Analyst
ServiceNow DevOps
Children’s Health System of Texas
Dallas, Texas, USA
