Understanding Data Sources
Data Sources define the source of data to be aggregated, such as measurement data from usage subscriptions linked to a service point, badged or unbadged items, or measuring component sets. Data sources also define configurations used when generating dynamic queries used by aggregation processing.
Data Source Classes
Data sources are defined by classes, each of which is based on a specific business object, and determines the type of configuration used by aggregation processing. More specifically, the data types configured on the data source are used when generating dynamic queries used by aggregation processing.
The table below lists the data source classes and the business object and configuration options for each. Consult the embedded help for more information about the specific configuration options used by each data source class.
| Data Source Class | Usage | Business Object | Configuration Options |
|---|---|---|---|
| Measurements from US Service Points | Used when aggregating data from measuring components linked to service points via a usage subscription. | D1-DataSourceMeasurements | Measuring Component Types |
| Badged Items | Used when aggregating data from badged items. | D1-BadgedItemsDataSource | Item Types |
| Billed Service Quantities | Used when aggregating data based on billed services quantities. | D1-DataSourceBilledSerQuantity | Usage Subscription Types |
| Measuring Component Sets | Used when aggregating data from measuring component sets. Data sources of this class are used with composite aggregation. | D1-DataSourceMCSet | Usage Subscription Types |
| Unbadged Items | Used when aggregating data from unbadged items. | D1-DataSourceUnbadgedItems | Item Types |
| Measurements from US Direct Links | Used when aggregating data from measuring components directly linked to a usage subscription. | D1-DataSourceMeasurementDirect | Measuring Component Types |
| Service Point Quantities | Used when aggregating data based on service point quantities. | D1-DataSourceSPQuantities | Service Point Quantity Types |
| Attribute and Measurement Data Snapshot | Used when aggregating data based on data snapshots | D1-MasterAndMsrmtDataSnapshot | Measurement Data Snapshot Types |
Data Source Template SQL
Data sources also provide template structured query language (SQL) used when generating dynamic queries used by aggregation processing. This template SQL is used as the basis for dynamic queries, and is extended by additional SQL generated from the data source configuration as well as configuration defined for measuring component sets, measuring components, and measuring component types that reference the data source. Template SQL is provided via the Data Source SQL (D1-DataSourceSQLLookup) extendable lookup. Values for this extendable lookup are used as the Option Value for the following business object options on the data source business object.
- Dimension Scanner SQL: The template SQL used when dimension scanning. This SQL is extended by the criteria, dimensions, and individually managed items configured on the measuring component sets being processed.
- Find Constituents SQL: The template SQL used when finding constituents. This SQL is extended by attributes defined on the aggregator measuring components being processed.
- Aggregation SQL: The template SQL used when performing aggregation. This SQL is extended by the value identifiers defined on the measuring component type of the aggregator measuring components being processed.