DM

This is the simplest type of DataMeasure. It uses a SqlDef provided in the TLV definition. Platform executes the query, fetch the results and display the aggregated values in appropriate buckets.

<DM bucketization="DAILY">
<Name>RequestQuantity</Name>
<DisplayName>Request Quantity</DisplayName>
<SqlDefName>DummySql</SqlDefName>
<SqlQuantityField levelType="Undefined">
<FieldName>quantity</FieldName>
</SqlQuantityField>
<SqlDateField levelType="Undefined">
<FieldName>the_date</FieldName>
</SqlDateField>
</DM>



  1. SqlDefName: One of SqlDefName or SqlDefRef must be provided. SqlDefName is the name of a query from the SqlDefs section of this TLV definition.

  2. SqlDefRef: Often we define a single query to be used across multiple TLV definitions. To re-use the same SqlDef across multiple TLVs, SqlDefRef is used. This takes GroupName and SqlName for the SqlDef defined in a *.sqls file in a module (your module or a module you depend on).

  3. SqlQuantityField: quantity field from the query result set for displaying values in the buckets.

  4. SqlDateField: Date field from the query which determines which date each quantity corresponds to.