Creating mapping of timestamp and respective quarter in Data Loading Form

Products

• CA Business Service Insight

Issue/Introduction

In a Data form, we provide manual timestamp as record submission timestamp.

There is a requirement to map data submission timestamp with quarter. When a timestamp is placed in the record, then accordingly a respective quarter should be selected. For example, if timestamp of 20th Apr 2025 is provided, then it should automatically populate quarter Q2t.

Is this possible?

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

There is no control for doing this within the Data Loading Form itself.

While we can set default values for fields, it cannot pass programmatic data from one field to another.

Translation tables exist, but are used to map one specific value to another specific value - there is no way to make values in a range to an item, whether it is a date range or a numeric one.

If you wish to have this information used in the results, then a SQL adapter that was pulling this submitted data could do something like

select month(dateField)

and then have entries for which quarter each month was in.

However, this is only for use in the results, not as part of the Data form.

Also remember that "Quarter" does exist as a calculation granularity in the metric itself.  For instance, if you are calculating availability over a quarter, you can do this with the report granularity rather than mapping to a quarter in the event itself.