Data file

A data file contains the data for a single view recorded during a session. The file name is dsessionid_viewnumber_viewname where:

One record in the file exists for each unique combination of data item key field values that occurred in each sample taken.

Each such record holds:

If no data is returned for this view during a given sample interval, a placeholder record is written to the historical data file. This record contains the timestamp of the sample, followed by a comma-separated list of empty values. That is, the timestamp field is followed by as many commas as are needed to separate the remaining data items of the view, but no values are stored for those data items. This format is acceptable to the Bulk Copy utility, provided that the columns into which the data items are being copied will accept nulls.