Configuring Data Source Template SQL

Template SQL used when generating dynamic queries used in aggregation processing is defined in the Data Source SQL (D1-DataSourceSQLLookup) extendable lookup. The base package data source business objects reference appropriate base package values from this extendable lookup.

For example, the Aggregation SQL option on the Measurements from US Service Points data source business object (D1-DataSourceMeasurements) references the “D1_​MSRMT_​FROM_​US_​SP_​MCTYPE_​SQL” value from the Data Source SQL extendable lookup.

If an implementation requires template SQL that differs from the base package, custom extendable lookup values can be created and referenced on the data source business object.

When creating custom template SQL, start from an existing extendable lookup value. Select the value that most closely matches your requirements and use the Duplicate function to create a copy, and edit the SQL as needed.

Use the following procedure to add a custom extendable lookup value to a data source business object.

  1. Add a business object option of the appropriate type to the data source business object. For instance, if creating custom SQL for aggregation, add an Aggregation SQL option.
  2. Enter a Sequence higher than the base package option.
  3. Specify the custom extendable lookup value in the Option Value field.