跳至主要內容
文件
文件
Adaptive Planning
Set Up NetSuite External System for Drill Through

Set Up NetSuite External System for Drill Through

You can set up an external system and associate it with a mapping profile in a Planning Data Loader to allow drill through from
Adaptive Planning
 sheet and report data into NetSuite. When a user clicks a drill through link,
Adaptive Planning
 connects to the system and reveals the data's underlying transactions.
Associating a mapping profile with an external system is optional. Only set one up to enable drill through from
Adaptive Planning
 to NetSuite.
NetSuite External Systems only support drilling from leaf levels, not rollup levels. NetSuite Basic supports drilling from rollup levels.

Prerequisites

  • Permissions required: Integration, Data Designer
  • Verify you have access to NetSuite data sources in your instance
  • Verify you created a NetSuite Credential for token based authentication
  • When you create a new data source specifically for drilling, make a note of the NetSuite columns you want to map to data in
    Adaptive Planning
     .
  • Only the standard NetSuite dimensions (categories) of Account, Level, Customer, Item, and Department allow drilling

Navigation

Go to nav menu Integration > Design Integrations

Basic Steps

  1. Create an external system and give it a name.
  2. Set up external system settings so that
    Adaptive Planning
     knows how to connect and what account and/or credentials to use.
  3. Set up external dimension mappings to identify how dimensions on the external system map into the dimensions in
    Adaptive Planning
    .
  4. Configure tuple SQL columns if multiple external columns map to one
    Adaptive Planning
     dimension
Best Practice: Configure an external system for NetSuite before configuring a planning loader for the data source. After you create the external system, you will need to return to the NetSuite data source to complete the drill through set up.
If you are importing data from NetSuite and would like to also configure drill through to NetSuite based on the standard categories Account, Time Period, Subsidiary, Department, Class, Location, Item and Customer, then you will need to configure the NetSuite internal identifiers for each of these dimensions as part of your column and data mapping steps in the Planning Data Loader.

Create an External System:

  1. Expand
    External Systems
     in the
    Component Library
     panel on the right.
  2. Click
    Create New External System
    .
  3. In the
    Create New
     ... dialog, enter a name and click
    Create
    .

Set Up NetSuite External System Settings:

  1. Select the
    External Source System
    , in the
    External System Settings
     tab. Select
    NetSuite
    , enter the Account ID used in NetSuite.
  2. Select
    External Dimensions
     to view a list of the external system dimensions and drill through parameter names.

Set Up NetSuite External Dimension Settings

  1. Click the
    External Dimension Mapping
     tab.
  2. Double click a
    Planning Dimension
    . In the dialog, select an External Dimension to map it to. Click
    Apply
    .
  3. A green status checkmark indicates the Planning Dimension successfully mapped to at least one external dimension. Click
    Save
    .

External Dimension Mappings

External Dimension mappings help when mapping two or more dimensions from an external system into a single planning dimension for drill through.
  1. Select an External System listed in the Component Library to map additional external dimensions to a single Planning dimension.
  2. Select the
    External Dimension Mapping
     tab and double click a Planning dimension to launch the mappings editor.
  3. Select external dimensions. Selected dimensions shift to the top of the list, possibly out of view without scrolling up.
  4. (Optional) Drag and drop the selected dimensions that shift to the top of to reorder them. Ensure that the order you configure matches the order you expect them to load from NetSuite.
  5. Enter a delimiter in the mappings editor. A delimiter is required when multiple external dimensions get selected.
  6. Delimiters cannot exceed five characters in length and should not match any characters used in a dimension value (actual values in the tuple mapped columns described later). Click
    Apply
    .
  7. View the External Dimension(s) column to verify it indicates multiple external dimensions mapped to a single Planning dimension.
  8. Click
    Save
    in the Actions panel after you finish mapping the Planning Dimensions the External Dimensions.

Configure Tuple SQL Columns For NetSuite

If you map multiple columns from NetSuite into a single dimension in Planning, then you need to create a Tuple SQL column in the staging table that you wish to expose in the Planning loader.
If you do not require data from multiple NetSuite columns into the same Planning dimension, then you do not need to create a Tuple SQL column in the data source.
If you plan to reuse an existing NetSuite data source to enable drill through and if you need to bring multiple NetSuite columns into a single Planning dimension, you must redo that mapping using Tuple SQL columns. Reconfigure your loaders to ensure that the integration task can be valid. Make these types of changes in a test environment and validate the changes there before rolling them out to a production system.
All of the following steps need to be completed to configure the Tuple SQL Column for drill through. Perform them only if you require data import from multiple NetSuite columns into a single Planning dimension.
In order for
Adaptive Planning
 to parse the different data items into the source NetSuite categories, you will need to specify which NetSuite source columns combine to form a single column before importing this data into Planning.
The order in which the different NetSuite columns combine, and the delimiter specified, should match how the many-to-one column mappings are specified in the NetSuite external system.
By indicating the constituent NetSuite columns and what their underlying NetSuite categories are,
Adaptive Planning
 constructs drill through URLs on the Planning sheet.
Before you create a Tuple SQL column, ensure that you have configured the many-to-one column mapping in the NetSuite external system.
  1. Select your NetSuite Data Source in the
    Component Library
    .
  2. Select the table you want to enable drill through on in the Data Components panel on the left.
  3. The table comes into focus in the Staging Area. Expand the custom column folder in the Data Components.
  4. Drag and drop a Tuple SQL Column into the Staging Area. This column is available when at least one tuple mapping is defined in an external system.
  5. Add a name, select a previously configured External System, and select the Planning Dimension that corresponds to the External Dimension Mapping performed in the previous section.
  6. Select the Mappings tab.
  7. For each of the External Dimensions, map the corresponding table column.
  8. Select
    Apply
  9. Select
    Save
    in the Actions panel.