Skip to content

Cross-source questions

Workday Adaptive Planning and NetSuite in one question

Ask questions that join Workday Adaptive Planning budgets and forecasts with NetSuite actuals by account and department, with lineage for each system.

Short answer

One question can span Workday Adaptive Planning and NetSuite, such as how NetSuite actuals by department compare with the current forecast version. Nexatron queries each within the requesting user’s existing access, combines the results in an isolated step inside your workspace, and shows each source’s query. Workday Adaptive Planning and NetSuite are both available.

Example joined questions

Questions to ask. Each needs data from both systems; the answer depends on your own data and definitions.

  • How do NetSuite actuals by department for the last closed period compare with the current Adaptive Planning forecast version?
  • Which GL accounts posted in NetSuite this month have no matching account in the Adaptive Planning budget?
  • Which departments are over their Adaptive Planning budget once NetSuite vendor bills pending approval are included?
  • How does NetSuite revenue by subsidiary compare with the Adaptive Planning budget for each entity this year?

Agree how NetSuite accounts, departments and subsidiaries map to Adaptive Planning accounts and levels, usually the mapping your actuals import already uses.

Check before you trust a joined answer

  • Adaptive Planning holds actuals as they were loaded; NetSuite holds them as posted. Check when actuals were last loaded before comparing.
  • NetSuite posting periods and Adaptive Planning time periods must line up, including the fiscal calendar.
  • Subsidiary base currencies and Adaptive Planning level currencies can differ. Name the currency and the rate.

How a cross-source answer works

  1. Each system is queried within the person’s access

    Nexatron sends each part of the question to the system that holds it. Each system answers with user-level access: Nexatron inherits the requesting user’s existing permissions in that system.

  2. Results are joined inside your workspace

    Nexatron combines each system’s results in an isolated step inside your tenant when the question is asked. Nothing has to be consolidated into a warehouse first, and there is no pipeline to build.

  3. The queries come back with the answer

    The answer carries the generated query for each system and how many records matched, so a reviewer can check which system supplied which figure and repeat the check later.

  4. Joins follow links found at setup

    Nexatron joins on the links setup found between the systems, and says how many records matched. If no record matches, it says so and marks the figures as uncertain.

  5. Currencies are never added up as they are

    Amounts in different currencies are converted with one system’s own exchange rates where a usable rate source exists, and otherwise shown side by side with the reason.

  6. Longer than a single-source answer

    These answers take longer than single-source ones.

More on how it works and its limits: Cross-source analytics and the guide to cross-source analytics without a warehouse migration.