Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Loaders

Contains preview content for the upcoming 2018.2 release.

Loaders are a set of business rules that identify how the raw data from a data source is used. Loaders read records from a data source, take the data from the staging area, prepare it for loading into the Adaptive Suite, and then load it. There are four types.

Discovery Metric Loader

Loads data from staging tables into Adaptive Discovery and maps columns in staging tables to dimensions and metrics in Discovery. It prepares the data by:

  • mapping the data in the staging area to assign a period range to the columns you specify for referencing the information
    You can set the granularity of the timestamp. The timestamp lets you view data across different time periods.

  • converting the information into metrics and dimensions
    A metric is basically any collection or series of numeric data. Examples of metrics include monthly sales data, personnel expenses, and product defect count. Metrics can be aggregated. Dimensions are attributes of a metric. Dimensions cannot be aggregated. Dimensions provide a mechanism to group metrics. For example, you might have a dimension called Region whose values are North, South, East, and West. Each metric can have one of these values for the Region dimension, and this lets you group metrics (and the associated record) by what region they’re associated with.

  • applying SQL calculations and filters
    You can use SQL to create calculations and filter conditions.

See Creating Metric Loaders for more information.

Planning Dimension Loader

Loads dimension values from staging tables into Adaptive Planning. This loader prepares the metadata by:

  • mapping dimension values in the staging area to the dimensions you specify in Adaptive Planning
  • applying SQL filters

It contains tabs for configuring:

  • Data Source Settings: Configure source and destination for the loader.

  • Column Mapping: Map Planning columns to a source column in a source system.

  • Business Rules: Skip selected metadata and write SQL filters to further distil the metadata being loaded.

It also allows previewing the loader output so that you can download a zipped XML file of the dimension values.

See Create a Planning Dimension Loader for more information.

Planning Loader

Loads data from staging tables into sheets and transactions in Adaptive Planning or Consolidation. This loader prepares the metadata by:

  • mapping the data in the staging area to the columns you specify in Adaptive Planning

  • setting the period range for the time periods the data loads into

  • setting the Planning version and sheet the data loads into

  • applying SQL filters

It contains tabs for configuring:

  • Data Source Settings: Configures source and destination for the loader and the period settings for the loader.

  • Profiles: Create and manage profiles for column mapping and data mapping.

  • Column Mapping: Map Planning columns to a source column in a source system.

  • Data Mapping: Map data from Column Mapping to the Accounts, Levels and Dimensions data in Planning.

  • Business Rules: Skip selected account codes, change signs, and write SQL filters to further distill the data being loaded.

See Using Adaptive Integration for Planning and Creating a Planning Loader for more information.

Scripted Loader

Loads data directly into Adaptive Planning through Pentaho Kettle scripts.

You can run a loader manually from the Loader screen or you can run a loader as part of an Integration task.

See Creating Scripted Loaders for more information.

  • Was this article helpful?