The name and the database fields of the aggregation-table
and what to write into each field is defined by the aggregation-definition.
Also indexes for one or more fields of the table can be defined.
Note: When creating an aggregation-definition,
the name of the database table can be defined.
Additionally the aggregation-definition gets a unique identifier
in the database. To avoid duplicate table-names in the system,
the given name of the aggregation-table internally gets extended
by the schema-name and the unique identifier.
Example: When creating an aggregation-definition with database table-name
page_statistics, the name of the table after creation will be eg sm._1_page_statistics.
This name also will be provided in the xml that gets returned by the interface call.
The same will happen with index-names, also to avoid duplicate names.
required
Name of the aggregation-definition.
required
objid of the scope.
required
Defines the fields of the aggregation-database-table,
their field-types and where to get the data from.
required
Holds information about where to get the data from,
that has to get aggregated for this aggregation.
required
Name of the aggregation-database-table.
Gets updated on create.
Tablename gets prefixed with _<aggregation-definition-id>_
required
Description of one database-field of the aggregation-table.
optional
Within the index-element, an index for the table can be defined.
required
Holds information which statistic-records to extract
out of the statistic-record-table for this aggregation.
optional
xpath-query for the statistic-data-table.
Only these statistic-records are selected out of the
statistic-record-table that match this expression.
choice
field that holds a value (string, date or numeric)
that comes from a parameter-value of one statistic-record-xml.
Attribute feed=statistics-data is for the
first release the only supported attribute.
In later releases feed could be eg xml-result if additional
data shall be aggregated from other sources than the statistic-record-xml.
choice
field that holds part of a date (can be year,month,day,weekday).
If a xpath-element is defined, use this parameter from the
statistic-record-xml. Child of this parameter must be <datevalue>.
If no xpath-element is defined, use the timestamp when the
statistics-record was written. Time-reduction-fields
are always numeric database-fields.
choice
holds the count of aggregation-table-records with same
values in all other fields of type info-field and
time-reduction-field. Count-cumulation-fields
are always numeric database-fields.
choice
holds the count of statistic-record-xmls with different
values in given statistics-parameter and same values
in all other fields of type info-field and time-reduction-field.
Eg used for a aggregation-table-field that holds
the number of sessions. Difference-cumulation-fields
are always numeric database-fields.
required
name of the table-field in the database.
required
type of the field in the database. Can be text, numeric or date.
required
xpath to the required value in the statistic-record.xml.
required
Attribute feed=statistics-data is for the first release the
only supported attribute. In later releases feed could be eg
xml-result if additional data shall be aggregated from other sources
than the statistic-record-xml.
required
name of the table-field in the database.
required
part of date that has to be written in this field (year,month,day,weekday).
optional
xpath to the required value in the statistic-record.xml.
required
Attribute feed=statistics-data is for the first release the
only supported attribute. In later releases feed could be eg
xml-result if additional data shall be aggregated from other sources
than the statistic-record-xml.
required
name of the table-field in the database.
required
name of the table-field in the database.
required
xpath to the required value in the statistic-record.xml.
required
Attribute feed=statistics-data is for the first release the
only supported attribute. In later releases feed could be eg
xml-result if additional data shall be aggregated from other sources
than the statistic-record-xml.
required
name of the index in the database.
Indexname gets prefixed with _<aggregation-definition-id>_
required
field(s) of the database-table the index shall be created on.