What’s New for Oracle NetSuite Analytics Warehouse

Here’s an overview of the features and enhancements added recently to improve your Oracle NetSuite Analytics Warehouse experience.

Platform 25.R1.P3 - March 2025

Feature Description
Transfer custom and supplemental fields You can transfer the custom and supplemental fields created in NetSuite to your Oracle NetSuite Analytics Warehouse instance using the data transfer setup page. This capability ensures that you can work with all your NetSuite data in Oracle NetSuite Analytics Warehouse and create the most accurate data visualizations for your business. See Transferring Custom and Supplemental Fields to NetSuite Analytics Warehouse.
Reload your NetSuite data To maintain data consistency, especially when records are modified, you can reload your NetSuite data into Oracle NetSuite Analytics Warehouse. You can reload your standard fields' data of your active functional areas as well as any custom and supplemental data you have transferred to Oracle NetSuite Analytics Warehouse. See Reloading Your Data to NetSuite Analytics Warehouse.

25.R1.P2 - March 2025

Application update that replaces the 25.R1 and 25.R1.P1 releases and contains all the updates of the 25.R1 and 25.R1.P1 releases.

25.R1.P1 - March 2025

Application update to address bugs.

25.R1 - March 2025

Feature Description
Enhanced subject areas Tooltips have a description for all the metrics including those involving calculations. These descriptions are also available in the Metrics tab of the Content Explorer - NetSuite Analytics Warehouse dashboard.
Enhancement to the dashboard The Revenue Recognition canvas has been added in the Order to Cash Transactions workbook. This enables you to view a summary report that lists everything on one page - Sales Order, Invoice, and Revenue Arrangement, whether the Revenue Arrangement has been generated from the Invoice or from the Sales order.
Deprecated catalog folders The following obsolete catalog folders have been removed from the NetSuite folder under Shared Folders: Financials, Inventory, Manufacturing, Projects and Support, Purchasing, and Sales. These have been replaced by the content in the corresponding Detail Dashboards folders in the NetSuite folder under Shared Folders.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 25.R1 - February 2025

Oracle NetSuite Analytics Warehouse will process the Prediction Applications as part of the secondary data refresh instead of the primary data refresh from an upcoming future release. This change will speed up daily incremental data refreshes. If you're relying on the output from the prediction apps, you must wait for the secondary data sets to be available. You can view these refresh completion times in the Pipeline Settings on the Data Configuration page.

24.R4.P3 - January 2025

Application update to address bugs.

24.R4.P2 - December 2024

Application update that replaces the 24.R4 and 24.R4.P1 releases and contains all the updates of the 24.R4 and 24.R4.P1 releases.

24.R4.P1 - December 2024

Application update to address bugs.

Platform 24.R4 - December 2024

Feature Description
Use additional NetSuite connections As a premium license tier Oracle NetSuite Analytics Warehouse customer, you can connect to two additional NetSuite accounts. If you're an enterprise license tier customer, you can connect to ten additional NetSuite accounts. These additional connections enable you to bring in data from multiple NetSuite accounts. See Create Additional NetSuite Connections and Merging Your NetSuite Accounts Data Into Your NetSuite Analytics Warehouse Instance.
Provide configuration and extraction details separately Use the simplified user interface with distinct tabs and menu items for configuration and extraction properties for the Oracle Autonomous Database and Oracle Warehouse Management connectors. See Load Data from Autonomous Database into Fusion Data Intelligence (Preview) and Load Data from Oracle Warehouse Management Cloud into Fusion Data Intelligence (Preview).
Additional connector The Oracle Warehouse Management connector (Preview) is available to acquire business relevant data from Oracle Warehouse Management Cloud and use it to create data augmentations for various warehouse management use cases. See Load Data from Oracle Warehouse Management Cloud into Fusion Data Intelligence (Preview).
Salesforce connector supports OAuth authentication type While creating the connection to the Salesforce SaaS instance, you can select Basic Authentication or OAuth as the type of authorization. See Load Data from Salesforce into Fusion Data Intelligence.
Use your own keystore and TLS certificate with the remote agent You can either use the default TLS certificate provided in the keystore with the remote agent or provide your own keystore and TLS certificate. See Set up the Remote Agent to Load Data into Fusion Data Intelligence (Preview).
Define common data validation parameters You can define and apply common parameters across multiple metrics for validating the extracted source data. See Validate Your Data.
View the release upgrade job failures If there is an issue while applying an update, the system displays the Troubleshooting icon that you can use to view the details and reach out for help to resolve the issue. See Update Your Application.
Enhanced incremental refresh process The incremental data refresh process refreshes objects as base and derived datasets. See About Data Refresh Performance.
Upload the custom security assignments through upload center You can upload the prebuilt as well as the custom security assignments through the upload center. See Upload and Download Data Security Assignments.
Use the expanded list of system settings You can set more advanced, service-level options through the Systems Settings page. See About Advanced Configuration.
Content Explorer supports custom subject areas and metrics In the Content Explorer - NetSuite Analytics Warehouse Workbook, you can search for and view your custom subject areas and metrics in their respective Subject Areas and Metrics dashboards.

24.R4 - December 2024

Note:

This release has been replaced with release 24.R4.P2 - December 2024.
Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Manufacturing Insights subject area offers crucial manufacturing Key Performance Indicators (KPIs) such as Perfect Work Orders, Behind Plan Ratio, Defect (Scrap) Density, and Yield for work orders. These are essential metrics for assessing the quality, speed, and accuracy of the manufacturing process execution at work order level. You can perform this analysis with 17 dimensions and 12 measures.
Enhanced subject areas These subject areas have been enhanced:
  • NetSuite - Sales Insights subject area supports 7 dimensions. Line-level updates are available with the dimensions and measures.
  • NetSuite - Inventory Insights subject area measures item efficiency by examining how quickly a company can sell an item at a location. You can do this analysis with 8 dimensions and 20 measures.
Planned deprecation The following obsolete catalog folders are planned to be removed in release 25.R1: Shared Folders -> NetSuite -> Financials, Inventory, Manufacturing, Projects and Support, Purchasing and Sales. These have been replaced by the content in the corresponding folders: Shared Folders -> NetSuite -> Detail Dashboards
Additional visualization workbook The Content Explorer - NetSuite Analytics Warehouse visualization workbook provides a view of business content including subject areas, metrics, key metrics, and workbooks to help business users understand what content is available and what business questions can be answered. This workbook is available in the catalog in the following location: Shared > Oracle > Common.
Duty roles for Content Explorer - NetSuite Analytics Warehouse To access and use the Content Explorer - NetSuite Analytics Warehouse workbook, users must have the Content Explorer Analysis Duty (OA4F_CONTENT_EXPLORER_ANALYSIS_DUTY) and Netsuite Content Explorer Analysis Content Duty (NAW_CONTENT_EXPLORER_ANALYSIS_CONTENT_DUTY) roles.

See Reference for Oracle NetSuite Analytics Warehouse.

24.R2.P4 - October 2024

Application update to address bugs.

24.R2.P3 - October 2024

Application update to address bugs.

24.R3 - September 2024

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Procurement Spend Analysis (Preview) subject area provides the ability to understand spend by derived flags designed to simplify, streamline, and enhance spend analysis as well analyse it by department, class, location, and statuses. It also enables you to check procurement spend for each vendor.
  • NetSuite - Inventory Insights (Preview) subject area enables you to view the total COGs and Net sales for a specific item in a specific accounting period and a location. Eventually enables you to determine the rank for each item in terms of COGS and NetSales.
  • NetSuite - Sales Insights (Preview) subject area enables you to view how much time it takes from the creation of a sales order to the generation of an invoice (first invoice and last invoice) and what percentage of sales orders result in immediate cash sales without any credit extended to customers. You can also check sales orders that aren't fulfilled because of back orders.
Additional dashboards These dashboards have been added:
  • Order to Cash Transactions: This dashboard contains total of 5 canvas thereby enabling order to cash analysis from various T-types perspectives such as Invoices, Fulfillments, Payments, Returns, and Refunds.
  • Procure to Pay Transactions: This dashboard contains total of 4 canvas, one each for Vendor Bills, Item Receipts, Vendor Payments, and Vendor Returns. Each canvas displays a tabular visualization on respective areas thereby allowing procure to pay analysis from each of the 4 T-types perspective.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 24.R3 - August 2024

Feature Description
Embed Oracle NetSuite Analytics Warehouse report visual graphics in NetSuite You can add your visualizations to your dashboard to have at-a-glance information about your business without having to log in to a different interface. See Adding NetSuite Analytics Warehouse Visualizations to a Dashboard.
Purchase multiple instance connections As a premium and enterprise tier Oracle NetSuite Analytics Warehouse customer, you can buy multiple instance connections that enables you to bring in data from multiple NetSuite backends. See Merging Your NetSuite Accounts Data Into Your NetSuite Analytics Warehouse Instance.
Create a configurable dataset required for Account Analysis for NetSuite (Preview) The NetSuite Account Analysis feature enables you to build custom content using data from custom transactions and prebuilt subject areas. See About Extending Data with Netsuite Account Analysis.
Set up OIDC single sign-on You can set up OpenID Connect (OIDC) single sign-on for Oracle NetSuite Analytics Warehouse to enable users to access their instance of Oracle NetSuite Analytics Warehouse by using OIDC single sign-on. See Enable Single Sign-On.
Access the Autonomous Data Warehouse tools Access to the Autonomous Data Warehouse tools is available with your Oracle NetSuite Analytics Warehouse subscription depending on your tier. See About the Autonomous Data Warehouse Tools.
Opt for the additional features available as Generally Available The "Reset Data Warehouse" and "SME Options for Data Augmentation" features are available in the Generally Available Features tab. See Generally Available Features.
Use the Oracle Transportation Management Connector (Preview) This feature enables connecting to an Oracle Transportation Management Cloud Service instance to create augmentations on that data. See Load Data from Oracle Transportation Management into Netsuite Analytics Warehouse (Preview).
Use the updated Data Augmentation process The updated Data Augmentation process provides the Dataset augmentation type as the default option. Use this recommended option to bring varied data into the warehouse and then use the semantic model extensions to create your own semantic model using this data. This enables you to perform complex semantic modelling to meet your business requirements. You can enable the "SME Options for Data Augmentation" under the Generally Available Features tab on the Enable Features page to augment your reports with datasets created by extending an existing entity or group of facts, by adding a new dimension in the target instance, and by adding a new fact in the target instance. However, this option isn't recommended. See .About Augmenting Your Data.
Enable full load of the data augmentation source table You can enable full load of the source table data everytime using the Versioned Dataset option. See Augment Your Data.
View and select logical facts based on subject area While editing a logical star, you can select a subject area and then select from the logical facts available in the subject area. This enables you to view a shorter list of logical facts and select from it, thereby improving the overall performance. See Edit Logical Star.

24.R2.P2 - June 2024

Application update delivers performance enhancements and bug fixes.

24.R2.P1 - June 2024

Application update to address bugs.

24.R2 - June 2024

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Order to Cash - Revenue Recognition (Preview) subject area enables you to analyze recorded general ledger impact of sales transactions across multiple future periods.
  • NetSuite - System Journal subject area enables you to perform analysis on system-generated, read-only journals to represent general ledger impact of payments that are at varying states of completeness in your system.
  • NetSuite - Statistical Journal subject area is used with statistical accounts to make single-sided transactions by class, department, and location.
  • NetSuite - Invoice Group subject area gives greater flexibility in meeting your customer’s expectations for how and when they receive invoices by combining multiple invoices into one invoice group.
Enhanced existing subject areas These additions are available:
  • Line-level snapshot metrics for the Sales Order and Item Fulfillment snapshots.
  • Generic Resource dimension support in the Project and Support Management subject areas.
  • Inventory Snapshot subject area enhancements such as introduced currency dimension changes in formulas for On Hand Value, Average On Hand Value, and Component Item On Hand Value.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 24.R2 - June 2024

Feature Description
(Preview) Create a configurable dataset You can configure a custom dataset that enables you to create the custom account analysis reports. See Extend Data with Custom Data Configurations.
View bundle validation status Prior to deployment, the system validates the bundles to confirm whether the bundles contain all prerequisites. See About Bundles.
Export and import key metrics You can export key metrics in a content bundle and import key metrics by deploying a key metric bundle into a new instance with key metrics enabled. See Create a Bundle.
Enhancements to connectors The following connectors have additional parameters:
Single sign-on support The single sign-on setup in Oracle NetSuite Analytics Warehouse supports SAML sources like Google and Azure apart from the existing support for OKTA.
Upcoming changes to the Oracle Autonomous Data Warehouse tools starting July 2024

For the upcoming changes to the Oracle Autonomous Data Warehouse tools, see About the Autonomous Data Warehouse Tools.

Platform 24.R1.P8 - April 2024

Feature Description
Semantic model uploaded through the External Application Merge functionality will also be upgraded The semantic model that you uploaded through the External Application Merge functionality is also upgraded when the release upgrade happens for the instance. After a release upgrade, you must download the latest version of the uploaded semantic model from the user interface. Save it for any further usage because the uploaded semantic model would have gone through an upgrade. See About Merging External Applications.
Reset action renamed as Reload Data The Reset action available for an activated data pipeline for a functional area has been renamed as Reload Data. See Reload Data for a Data Pipeline.

24.R1.P3 - April 2024

Application update to address bugs.

Platform 24.R1.P4 - April 2024

Detail dashboards (workbooks that were previously built to work with the now-deprecated decks) will be deprecated in a future release.

These legacy deck-oriented dashboards are stored in folders at the root level of your application. On the other hand, the current, updated detail dashboards are found inside the Detail Dashboards folder and not in folders at the root level. When these legacy folders are removed in the 24.R2 release, the directory structure will contain only an Overview Dashboards folder, another Detail Dashboards folder, and possibly a small number of special folders. Any other “loose” folders will be removed.

If you're referencing dashboards in these “loose” folders in any of your application content, copy those dashboards to other folders and update links in your application to the new location of those dashboards.

24.R1.P2 - March 2024

Application update to address bugs.

24.R1.P1 - March 2024

Application update that includes the following fixes and enhancements:
  • Fixes and improvements for the Revenue Plan and Revenue Arrangement queries.
  • Identifier attributes have been exposed in the Item, Account, and Entity-related dimensions.
  • The Rate Type filter requirement for analyses and dashboards when Analytics Currency metrics aren't needed has been removed.
  • Descriptions (tooltips) for all NetSuite subject areas have been added.

24.R1 - March 2024

Application update that has been replaced with the 24.R1.P1 - March 2024 release.

Platform 24.R1 - March 2024

Feature Description
KPIs, decks and cards are no longer available The separate Oracle NetSuite Analytics Warehouse home page, as well as KPIs, decks, and cards have been deprecated. These workflows are now found exclusively under the unified experience of Oracle Analytics Cloud: home page, key metrics, composite visualizations, and workbook-based dashboards. Since 23.R3, all prebuilt application content is delivered based solely on theOracle Analytics Cloud features. See About Oracle NetSuite Analytics Warehouse.
Data Source Reset and Reload feature is generally available as opt-in functionality Enable Data Source Reset and Reload from the Generally Available Features tab on the Enable Features page.

See Reset and Reload the Data Source.

Extract metadata for pivot tables If you've pivot table in your source, then the metadata extract supports pivot table metadata extraction for the EPM connectors. See Load Data from Enterprise Performance Management into Netsuite Analytics Warehouse (Preview) and Load Data from EPM Export Data Instance into Netsuite Analytics Warehouse (Preview).
U.S. Bureau of Labor Statistics connector is no longer available Due due to the government policy change and the restrictions on the API, Oracle had to deprecate this connector. If you need to bring this data into your analytics, then perform the following operations:
  1. Bring the desired Bureau of Labor Statistics tables into any independent storage for which Oracle Fusion Analytics Warehouse has connectors; for example Oracle Object Storage or Secure FTP.
  2. Use those respective connectors to bring the data in and build data augmentations.

23.R4.P3 - January 2024

Application update to address bugs.

23.R4.P1 - December 2023

Application update to address bugs.

Platform 23.R4 - December 2023

Feature Description
Authenticate users with OKTA You can authenticate your users with OKTA, a third party identity provider and provide access to the Oracle NetSuite Analytics Warehouse content. Your users don’t need to sign into Oracle Identity Cloud Service which is the default identity provider for Oracle NetSuite Analytics Warehouse.
(Preview) Connect with your on-premises MySQL database You can connect with your on-premises MySQL database to acquire additional data and later use this data to create data augmentations. See Load Data from On-premises MySQL into Netsuite Analytics Warehouse (Preview).
(Preview) Connect with your MySQL Cloud database You can connect with your MySQL Cloud database to acquire additional data and later use this data to create data augmentations. See Load Data from MySQL Cloud into Netsuite Analytics Warehouse (Preview).
(Preview) Connect with an Enterprise Data Management Cloud instance You can connect with an Enterprise Data Management Cloud instance to acquire additional data and later use this data to create data augmentations. See Load Data from Oracle Enterprise Data Management Cloud into Netsuite Analytics Warehouse (Preview).
(Preview) Connect with your Mongo database You can connect with your Mongo database to acquire additional data and later use this data to create data augmentations. See Load Data from Mongo Database into Netsuite Analytics Warehouse (Preview).
Use connectors available by default These connectors are available as default features and you no longer need to enable them on the Enable Features page:
  • Oracle Object Storage Service
  • Google Analytics
  • Salesforce REST
  • U.S. Bureau of Labor Statistics

See About Managing Data Connections.

(Preview) Include warehouse data tables from functional areas, descriptive flexfields custom configurations, and data augmentations for frequent refreshes Select warehouse data tables that are part of functional areas, descriptive flexfields custom configurations, and data augmentations for frequent data refresh ahead of other data in the regularly scheduled batch. See Schedule Frequent Refreshes of Warehouse Tables (Preview).
Verify data augmentations rejected on full load with invalid records crossing threshold During the data augmentation activation process, if the number of invalid records is substantial, then Oracle NetSuite Analytics Warehouse rejects the data augmentation. See Augment Your Data.
View the Troubleshooting status for load request View the Troubleshooting status in the data pipeline load request history to understand why a pipeline job is taking substantial amount of time. See About Request Types and Statuses.
Use the enhanced security capabilities The enhanced security capabilities enable you assign the ready-to-use licensed application roles to custom groups to provide users the system privileges such as consumer, author, and administrator.

You can continue to use the existing security capabilities till Oracle NetSuite Analytics Warehouse automatically applies them as part of the release 24.R2. These changes are mandatory and you can schedule the update sooner to enhance the security of your application. See About Managing Users, Groups, and Application Roles and Licensed Roles.

Deprecated column The SOURCE_EXTRACT_DATETIME column has been deprecated from Warehouse Refresh Statistics.

23.R4 - December 2023

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Order to Cash - Customer Invoice subject area analyzes line level links of invoices with sales order and also associated Estimate and Opportunity transaction.
  • NetSuite - Order to Cash - Customer Payment Activity subject area enables you to conduct cross-transactional analysis of all the payment transactions done to pay an invoice or statement charge.
  • NetSuite - Order to Cash - Customer Refund subject area analyzes the refunds where refund is applied against transactions - customer payment, credit memo and deposit application.
  • NetSuite - Order to Cash - Order Fulfillment subject area provides the unified view of Item Shipment and Store Pickup fulfillment and its associated Sales Order. It tracks the line level links between Sales Order and Fulfillment transaction.
  • NetSuite - Order to Cash - Return Authorization subject area analyzes return authorization transactions and its associated Sales Orders, Cash Sales and Customer Invoices. These links are stored at line level.
  • NetSuite - Procure to Pay - Item Receipt subject area presents line-level transactions to track item receipts and its associated transactions. This includes purchase orders, purchase requisitions and purchase contracts.
  • NetSuite - Procure to Pay - Vendor Bill subject area presents line-level transactions to track vendor bill and its associated transactions. This includes purchase orders, purchase requisitions, and purchase contracts.
  • NetSuite - Procure to Pay - Vendor Payment Activity subject area presents vendor payment vendor payment activities. This includes vendor payments, vendor credits and vendor prepayment applications that occur during the process of settling a vendor bill.
  • NetSuite - Procure to Pay - Vendor Return Authorization subject area analyzes line-level transactions to track vendor return authorization and its associated transactions. This includes vendor bill, purchase orders, purchase requisitions and purchase contracts.
Enhanced existing subject areas The Time Tracking and Timesheet subject areas include Employee Work Calendar attributes.
Enhanced existing dimensions The Job and Job Contact dimensions are available in all the Sales Module subject areas.
Additions to data security Updated security to support the hiding of prebuilt content.
Enhanced existing prebuilt analysis Restructured the Financials visualization and added new visualizations under Revenue, Expenses, Receivable Analysis, Payable Analysis, and Cash Analysis canvases.
Preview functional areas These functional areas are available as preview features:
  • Order to cash
  • Procure to pay

See Features Available for Preview.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 23.R3.P3 - October 2023

Feature Description
Migrate your custom content You can migrate your custom content to transform your custom KPIs, decks, and cards to Oracle Analytics Cloud workbooks and visualizations. See Migrate Your Content.
Build analytical applications Using the Overview and Detail dashboards, you can construct Oracle applications, build new content that looks similar to the ready-to-use content, and extend the ready-to-use content. See Build Analytical Applications.

23.R3.P3 - October 2023

Application update to address bugs.

23.R3.P2 - September 2023

Application update to address bugs.

23.R3.P1 - September 2023

Application update to address bugs.

23.R3 - September 2023

Feature Description
Enhanced existing subject areas Transaction Identifier, Transaction Type, and Created From Identifier attributes available in the applicable subject areas
Enhanced existing dimensions These dimensions have been enhanced:
  • Contact details available in the entity-related dimensions.
  • Item dimension supports viewing and filtering all levels of the Merchandise Hierarchy.
Additional data security Additional data security by Subsidiary, Department, Classification, and Location is available.
Enhanced existing prebuilt analysis These prebuilt analysis have been enhanced as follows:
  • The Time Tracking canvas is available in the Project Hours and Timesheet project.
  • The Bill of Materials Inquiry canvas is available in the Manufacturing project.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 23.R3 - September 2023

Feature Description
(Preview) Connect with an Azure SQL instance You can connect with an Azure SQL instance to acquire additional data and later use this data to create data augmentations. See Load Data from Azure SQL into NetSuite Analytics Warehouse (Preview).
(Preview) Connect with your Oracle BI Publisher instance You can connect with your Oracle Analytics Publisher instance to acquire additional data and later use this data to create data augmentations. See Load Data from Oracle BI Publisher into NetSuite Analytics Warehouse (Preview).
(Preview) Connect to an Oracle database using JDBC You can connect to an Oracle database using JDBC to acquire additional data and later use this data to create data augmentations. See Load Data from Oracle Database Using JDBC into NetSuite Analytics Warehouse (Preview).
(Preview) Connect with an QuickBook Online instance You can connect with a QuickBook Online instance to acquire additional data and later use this data to create data augmentations. See Load Data from QuickBooks Online into NetSuite Analytics Warehouse (Preview).
(Preview) Connect with an SQL Server instance You can connect with an SQL Server instance to acquire additional data and later use this data to create data augmentations. See Load Data from SQL Server into NetSuite Analytics Warehouse (Preview).
(Preview) Reset and reload the data source Reset and reload data for all the activated functional areas, augmentations, and custom data configurations. See Reset and Reload the Data Source (Preview).
(Preview) Schedule frequent refreshes of warehouse tables Select the warehouse data tables for frequent refreshes before refresh of data in the regularly scheduled batch. See Schedule Frequent Refreshes of Warehouse Tables (Preview).
View release update activity View the actual date when a release was deployed for the instance and any service administrator actions like date selections for release or patch uptake. See View Release Update Activity.
Use bundles on environments at different versions Bundles work on environments where the source and target are at the same level or the source is at a lower version and the target is at a higher version. See About Bundles.
Begin your user experience with Oracle Analytics Cloud Build your analytics directly from Oracle Analytics Cloud to create key metrics, workbooks, and visualizations. See About Oracle NetSuite Analytics Warehouse.

23.R2.P1 - June 2023

Application update to address bugs.

Platform 23.R2 - June 2023

Feature Description
Configure advanced options You can set more advanced, service-level options through the Systems Settings page. See Configure Advanced Options.
Support for custom data configurations and custom attributes mapper in the Data config bundle You can include the custom data configurations and custom attributes mappings in the Data Config bundle. See Create a Bundle.
(Preview) View the estimated refresh completion time You can view the estimated refresh completion time for daily pipelines. See About Data Refresh Performance.
Enable generally available features You can enable the features that are generally available but needs you to enable them to use the specific functionality. See Enable Generally Available Features.
Set the frequent data refresh schedule You can set the refresh schedules for the pipelines of Financials and Sales functional areas to a frequency of 4 hours or higher. See Schedule Frequent Refreshes of Functional Area Data.
Schedule periodic full refresh of functional area data You can schedule a full refresh on a weekly, monthly, or quarterly basis for the functional area data. See Schedule Periodic Full Reload of Functional Area Data.
Planned for deprecation The SOURCE_EXTRACT_DATETIME column in the DW_WH_REFRESH_SUMMARY view is planned for deprecation in a future release.

23.R2 - June 2023

Feature Description
Additional subject areas These subject areas have been added:
  • In the Sales and Inventory module:
    • NetSuite – Wave: Enables you to track and analyze wave pick actions and also number of waves and wave lines.
    • NetSuite – Subscription: Enables you to analyze subscription details such as number of subscription, length of subscription, and contract value of subscription.
  • NetSuite – Budget in the Financials module. This enables you to analyze the budget period amount, total amount corressponding to budget, and number of budgets and periods.
  • NetSuite – Inbound Shipment Snapshot in the Purchases module. This enables you to track incoming shipments by vendor, in-transit inventory and status by location, subsidiary and snapshot date. You can also track landed costs, and receiving and billing details associated with the Inbound Shipment record. You can split the Inbound Shipments by vendor, subsidiary, location, and item.
  • NetSuite – Time Tracking in the Product and Support Management module. This enable you to analyze time tracking, labor cost, billing rate, and hours.
Reorganization of the detailed projects All the detailed projects have been re-organized into the Detail Dashboards folders under NetSuite to support the applicable Oracle Analytics Cloud features.
Additions to existing subject areas The Revenue Plan facts have been added in the NetSuite – Revenue Arrangement subject area (Financials module).

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 23.R1.P1 - April 2023

Feature Description
(Preview) Connect with your Taleo data source You can connect with your Taleo data source to acquire additional data and later use this data to create data augmentations. See Load Data from Taleo into NetSuite Analytics Warehouse (Preview).

23.R1.P1 - March 2023

Feature Description
Additional coverage in data model Data for the Budget module is available in the data model.
Ready-to-use KPIs and Decks migrated to dashboards The existing Financial, Inventory, Order Management, Procurement, and Sales Overview KPIs and decks have been migrated as the Financials Overview, Inventory Overview, Order Management Overview, Procurement Overview, and Sales Overview dashboards. These KPIs and decks are planned to be deprecated in a future release.
Added folder level content security Content folder level access control driven by the duty roles corressponding to the underlying functional areas has been added as follows:
  • The Financials folder available in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_CONTENT_DUTY and NAW_FINANCIALS_DUTY duty roles and the ServiceAdmin system role.
  • The Inventory folder available in the NetSuite folder under Shared is accessible to the NAW_INVENTORY_CONTENT_DUTY and NAW_INVENTORY_DUTY duty roles and the ServiceAdmin system role.
  • The Manufacturing folder available in the NetSuite folder under Shared is accessible to the NAW_MANUFACTURING_CONTENT_DUTY and NAW_MANUFACTURING_DUTY duty roles and the ServiceAdmin system role.
  • The Projects and Support folder available in the NetSuite folder under Shared is accessible to the NAW_PROJECT_SUPPORT_MANAGEMENT_CONTENT_DUTY and NAW_PROJECT_SUPPORT_MANAGEMENT_DUTY duty roles and the ServiceAdmin system role.
  • The Purchasing folder available in the NetSuite folder under Shared is accessible to the NAW_PURCHASING_CONTENT_DUTY and NAW_PURCHASING_DUTY duty roles and the ServiceAdmin system role.
  • The Sales folder available in the NetSuite folder under Shared is accessible to the NAW_SALES_CONTENT_DUTY and NAW_SALES_DUTY duty roles and the ServiceAdmin system role.
  • The Cash Forecast Detailed Analysis dashboard available in the Financials subfolder in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_CONTENT_DUTY and NAW_FINANCIALS_DUTY duty roles and the ServiceAdmin system role.
  • The COGS Detailed Analysis dashboard available in the Financials subfolder in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_CONTENT_DUTY and NAW_FINANCIALS_DUTY duty roles and the ServiceAdmin system role.
  • The DSO/DPO Detailed Analysis available in the DSO subfolder with in the Financials subfolder in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_CONTENT_DUTY and NAW_FINANCIALS_DUTY duty roles and the ServiceAdmin system role.
  • The COGS Detailed Analysis dashboard available in the Financials subfolder in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_CONTENT_DUTY and NAW_FINANCIALS_DUTY duty roles and the ServiceAdmin system role.
  • The COGS Detailed Analysis, Financials, Payable Detailed Analysis, Receivable Detailed Analysis, SaaS Metrics, and Spend dashboards available in the Financials subfolder in the NetSuite folder under Shared are accessible to the NAW_FINANCIALS_CONTENT_DUTY and NAW_FINANCIALS_DUTY duty roles and the ServiceAdmin system role.
  • The Back Order Detailed Analysis, Inventory Analysis, Inventory Count Detailed Analysis, Inventory Detailed Analysis, Inventory Transfer Detailed Analysis, Inventory Turnover Detailed Analysis, and Item Cost Detailed Analysis dashboards available in the Inventory subfolder in the NetSuite folder under Shared are accessible to the NAW_INVENTORY_CONTENT_DUTY and NAW_INVENTORY_DUTY duty roles and the ServiceAdmin system role.
  • The Manufacturing dashboard available in the Manufacturing subfolder in the NetSuite folder under Shared is accessible to the NAW_MANUFACTURING_CONTENT_DUTY and NAW_MANUFACTURING_DUTY duty roles and the ServiceAdmin system role.
  • The Manufacturing dashboard available in the Manufacturing subfolder in the NetSuite folder under Shared is accessible to the NAW_MANUFACTURING_CONTENT_DUTY and NAW_MANUFACTURING_DUTY duty roles and the ServiceAdmin system role.
  • The Overview dashboards available in the NetSuite folder under Shared are accessible to the NAW_FINANCIALS_OVERVIEW_OAC_CONTENT_DUTY, NAW_INVENTORY_OVERVIEW_OAC_CONTENT_DUTY, NAW_ORDER_MANAGEMENT_OVERVIEW_OAC_CONTENT_DUTY, NAW_PROCUREMENT_OVERVIEW_OAC_CONTENT_DUTY, and NAW_SALES_OVERVIEW_OAC_CONTENT_DUTY duty roles and the ServiceAdmin system role.
  • The Financials Overview dashboard available in the Overview Dashboards subfolder in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_OVERVIEW_OAC_CONTENT_DUTY duty role and the ServiceAdmin system role.
  • The Financials Overview dashboard available in the Overview Dashboards subfolder in the NetSuite folder under Shared is accessible to the NAW_FINANCIALS_OVERVIEW_OAC_CONTENT_DUTY duty role and the ServiceAdmin system role.
  • The Inventory Overview dashboard available in the Overview Dashboards subfolder in the NetSuite folder under Shared is accessible to the NAW_INVENTORY_OVERVIEW_OAC_CONTENT_DUTY duty role and the ServiceAdmin system role.
  • The Order Management Overview dashboard available in the Overview Dashboards subfolder in the NetSuite folder under Shared is accessible to the NAW_ORDER_MANAGEMENT_OVERVIEW_OAC_CONTENT_DUTY duty role and the ServiceAdmin system role.
  • The Procurement Overview dashboard available in the Overview Dashboards subfolder in the NetSuite folder under Shared is accessible to the NAW_PROCUREMENT_OVERVIEW_OAC_CONTENT_DUTY duty role and the ServiceAdmin system role.
  • The Sales Overview dashboard available in the Overview Dashboards subfolder in the NetSuite folder under Shared is accessible to the NAW_SALES_OVERVIEW_OAC_CONTENT_DUTY duty role and the ServiceAdmin system role.
  • The Project Hours and Timesheet, Services, and Support and Case Incidents dashboards available in the Projects and Support subfolder in the NetSuite folder under Shared are accessible to the NAW_PROJECT_SUPPORT_MANAGEMENT_CONTENT_DUTY and NAW_PROJECT_SUPPORT_MANAGEMENT_DUTY duty roles and the ServiceAdmin system role.
  • The Procurement Detailed Analysis, Purchase Order Detailed Analysis, Purchasing Analysis, Requisition Detailed Analysis, Vendor Delivery Detailed Analysis, Vendor Payment Detailed Analysis, Vendor Return Detailed Analysis, and Vendor Spend Detailed Analysis dashboards available in the Purchasing subfolder in the NetSuite folder under Shared are accessible to the NAW_PURCHASING_CONTENT_DUTY and NAW_PURCHASING_DUTY duty roles and the ServiceAdmin system role.
  • The Customer Growth, Customer Invoice Analysis, Customer Payment Analysis, Customer Return Detailed Analysis, Customer Sales Detailed Analysis, Forecast Accuracy Detailed Analysis, Fulfillment Details, Gross Margin, Invoice Detailed Analysis, Invoice Details, Item Fulfillment Detailed Analysis, Item Sales Detailed Analysis, Net Sales Order Detailed Analysis, Opportunity Win/Loss Detailed Analysis, Order Management, Overdue Invoice Detailed Analysis, Overdue Invoice Details, Payment Detailed Analysis, Payment Details, Pipeline Detailed Analysis, Return Details, Sales Order Analysis, Sales Order Detailed Analysis, Sales Order Details, and Shipment Detailed Analysis dashboards available in the Sales subfolder in the NetSuite folder under Shared are accessible to the NAW_SALES_CONTENT_DUTY and NAW_SALES_DUTY duty roles and the ServiceAdmin system role.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 23.R1 - March 2023

Feature Description
(Preview) Connect with your Snowflake data source You can connect with your Snowflake data source to acquire additional data and later use this data to create data augmentations. See Load Data from Snowflake into NetSuite Analytics Warehouse (Preview).
View the usage of capacity for custom data You can view the usage of capacity for custom data that is loaded into Oracle NetSuite Analytics Warehouse through the connectors in the Custom Data Usage dashboard available in the Common folder. See About Managing Data Connections.
View activity history of the bundles View all the bundles-related activities to understand the changes made to your instance, which bundles to use, and whether the existing bundles are still current. See View Activity History of Bundles.
Unused branches are automatically deleted Oracle NetSuite Analytics Warehouse automatically deletes the unused branches after an inactive period of 120 days .
Data source is automatically disabled If the credentials are invalid for a data source, then Oracle NetSuite Analytics Warehouse automatically disables the source and sends you an email. Until you reset the credentials, Oracle NetSuite Analytics Warehouse doesn't process any of the data pipeline tasks.
Key metrics

The Key Metric feature has been added to the Oracle Analytics Cloud analytics platform supporting Oracle NetSuite Analytics Warehouse. Use key metrics to package a related set of metrics and dimensions to model a reusable business performance metric. Like the current Oracle NetSuite Analytics Warehouse KPIs, the ready-to-use key metrics are based on the ready-to-use application subject areas.

Included in the definition of the key metric is metadata describing its purpose, custom calculations, and pre-configured conditional formatting that will appear in any visualization based on the key metric. Access key metrics through the Oracle Analytics Cloud Workbook authoring experiences and use them to build Workbook-based content. See About Key Metrics.

KPIs and decks migrated to Oracle Analytics Cloud-based artifacts for review

For your review, a version of KPIs and decks have been translated into Oracle Analytics Cloud-based artifacts. As the translation is lossy, this migrated content supplements the ready-to-use KPIs and decks that remain the primary application content and optimal user experience in this release.

All Oracle NetSuite Analytics Warehouse KPIs and decks have been migrated. KPIs have been translated to a new feature called Key Metrics and decks to core Oracle Analytics Cloud Workbooks. Outside of using key metrics, the migrated decks are generic Oracle Analytics Cloud workbooks featuring core Workbook capabilities.

Converted content is available in an “Overview Dashboards” folder under the parent application folder. There is one Overview Dashboard Workbook for each shipped deck. These link to the shared ready-to-use Detail Workbooks also found in the application folder.

22.R4.P2 - January 2023

Application update to fix the incorrect schema name for the event polling tables (EPT).

Platform 22.R4 - December 2022

Feature Description
Enable Single Sign-On Set up the single sign-on authentication to enable users to access their Netsuite account through Oracle NetSuite Analytics Warehouse. See Enable Single Sign-On.
Make the preview features available Enable the functionality available as a preview feature to try it out. See Make Preview Features Available.
Connect with your other data sources You can connect to a variety of data sources to provide the background information for reports. See About Managing Data Connections.
Use custom objects in the semantic model extensions While extending the semantic model, you can use the custom objects that you created using data augmentation. See Customize Oracle NetSuite Analytics Warehouse.
Change the names of the columns in data augmentations You can change the names of the columns that you’ve added from the various data sources in your data augmentation. See Augment Your Data.
Join custom dimensions to ready-to-use facts While extending the semantic model, you can join a custom dimension to the ready-to-use or custom facts, and add the custom dimension to any subject area. See Add a Dimension.
Create complex joins While extending the semantic model, use complex joins to provide expressions as join conditions. See Add a Fact Table and Extend a Dimension.
Copy user mappings to a group You can copy the users mapped to an existing group to a custom group to quickly add users to the new custom group. See Copy User Mappings to a Group.
Configure a virus scanner Use the Virus Scanner option on the Console in Oracle NetSuite Analytics Warehouse to connect to your virus scanning server. See Configure a Virus Scanner.

22.R4 - November 2022

Feature Description
Additional subject areas These subject areas have been added:
  • Support Case - Use this subject area to track support cases by customer, support representative, case type, escalations, and time to resolution. Record type included in NetSuite Support Management that is used to track key support case details.
  • Support Issue - Use this subject area to track a product's modules or version updates and track support responses to customers. Issue Management expands customer support capabilities and allows for detailed customer follow up regarding sold or manufactured products. Customer support representatives and quality assurance employees have access to product issues as well as engineering managers, QA manager, or product managers.
  • Work Breakdown Structure - This record type within Project Management enables you to track revenue, profit, and margin by task. Utilize this subject area to review revenue and cost estimates alongside actuals and related project costs.
  • Netting Settlement - This subject area allows subsidiaries to net or settle outstanding receivable or payable amounts at the end of each month. Use this subject area to track key details including date, document number, due date, amount due, and paired fields.
Additional visualization projects These visualization projects have been added:
  • Support and Case Incidents: Reivew Support Cases by Agent and support resolution flow and status. Utillize these metrics to review support representative productivity and to help gauge support details and efficiency.
  • Project Hours and Timesheet: Review project hours billed and approved as well as billable hour revenue. Review top clients by hours, top employees, and timesheet details.
  • Manufacturing: Review key production metrics regarding assembly build and unbuild as well as work order review and production details. Track inventory shortages based on production and pending fulfillments.

See Reference for Oracle NetSuite Analytics Warehouse.

22.R3 - September 2022

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Cross Charge Journal: This subject area generates cross charges between subsidiaries that provide business services to each other. For example, when one subsidiary creates a sales order and another subsidiary fulfills the order, this subject area creates one transaction for the selling subsidiary and one for the buying subsidiary each.
  • NetSuite - Statement Charge: This subject area is similar to an invoice because they track payments you expect from your customers. Use statement charges instead of invoices when you want to enter several charges that accumulate before you send a billing statement to your customer.
  • NetSuite - Inventory Status Change: This subject area allows you to track Inventory attribute changes such as item availability, quality inspection status, or work order status.
  • NetSuite - Store Pickup Fulfillment: This subject area enables you to pick up an item at a specifically identified store. You can view the specific items that can be picked up and the locations allowing store pick-up through this transaction.
  • NetSuite - Vendor Prepayment: This subject area records and tracks deposit amounts paid to vendors before they accept a purchase order for a good or service. You can associate the vendor prepayment to a purchase order or list as a standalone vendor prepayments.
  • NetSuite - Vendor Prepayment Application: This subject area records and tracks the application of a vendor prepayment against vendor bills. A vendor prepayment application is a posting transaction that impacts the general ledger. The Prepayment account is credited, offsetting the accounts payable account. The application decreases the total amount you must pay to your vendor.
  • NetSuite - Timesheet: Timesheet enables you to track employee time in weekly segments rather than as individual time entries. Each timesheet record contains multiple time entry subrecords.
  • NetSuite - Customer Payment Snapshot: This subject area provides the ability to do historical analysis of key metrics associated with AP Holds at Invoices Header and Line level at the header level. You can analyze these metrics by ledger, business units, CoA segments, vendor, invoices holds, and releases.
  • NetSuite - Item Fulfillment Snapshot: This subject area allows you to perform historical analysis for all the top metrics related to AR Receipts and its applications against AR Invoices at the header level. You can analyze the information by time, customer details, business units in addition to GL account, GL balancing segments, and non-qualifying GL segments of CoA.
Additional visualization project The Industry Metrics: SaaS Metrics visualization project has been added.
Use the NetSuite Analytics Warehouse Licensed Viewers group Assign the NetSuite Analytics Warehouse Licensed Viewers group to enable users to only view the content. See System Groups.

See Reference for Oracle NetSuite Analytics Warehouse.

Platform 22.R3 - September 2022

Feature Description
Use dimension aliases in data augmentation You can specify the alias names for the Dimension type augmentations and the data that is in the warehouse already as dimensions to reuse the existing warehouse tables with a different name in the subject areas. See Create a Dimension Alias .
View business names of the entity fields The Custom Attribute Mapper displays the business names, IDs, data types, and size of the associated custom attributes. See Map Custom Attributes.

Platform 22.R2 - May 2022

Feature Description
Extend your subscription with user packs You can extend your Oracle NetSuite Analytics Warehouse subscription by buying additional user packs. See About Oracle NetSuite Analytics Warehouse.
Disable data pipeline You can disable the data pipeline and enable it again. See Disable Data Pipeline.
Specify data refresh schedule at more intervals Specify the frequency and when you want the incremental data load to happen. See Set Up the Pipeline Parameters.
Bundle your application artifacts Manage snapshots of your application artifacts as bundles. See Bundle Your Application Artifacts.
Import custom attributes for dimension entities Use the Custom Attribute Mapper to import custom attributes for the dimension entities. The Custom Attribute Mapper supports custom list, segment, record, and standard list on Entity and custom field on Lookup Entity, except in the case of role playing dimensions and multiple references to the same dimension. See Map Custom Attributes.
Data augmentation enhancements The data augmentation process supports standard list on Entity and custom field on looked-up transaction using the standard list on T-Type, except in the case of role playing dimensions and multiple references to the same dimensions. See Augment Your Data.

22.R2 - May 2022

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Revenue Commitment: Transaction type associated with classic (legacy) revenue recognition. The Revenue Commitment transaction enables you to separate billing and revenue recognition functions and is used by subscription software companies and construction management firms.
  • NetSuite - Inventory Cost Revaluation: This subject area provides insights into the process of recalculating the value of items configured to use standard costing. You can analyze the total amounts, credits, debits, and actual number of inventory revaluations.
  • NetSuite - Bin Transfer: A transaction type that updates the quantity on hand in specific bins within a warehouse. This transaction doesn't impact the general ledger.
  • NetSuite - Bin Putaway worksheet: Use the Bin Putaway Worksheet to print a bin numbers list for items that need to be re-stocked in your warehouse or stock room. The printed putaway list includes the date, items to be put away, quantity, and the preferred bin number for each item.
  • NetSuite - Ownership transfer: You can choose when the transfer of ownership occurs for items being transferred between locations. Ownership can transfer either at the time of shipping or the time of receipt.
  • NetSuite - Revenue Commitment Reversal: The Revenue Commitment Reveral subject area enables you to reverse the original Revenue Commitment transaction creating a reversal at the line item level of the original transaction.
  • NetSuite - Revenue Arrangement Snapshot: The Revenue Arrangement transaction is part of advanced revenue management and contains the details of customer performance obligations for purposes of revenue allocation and recognition. The snapshot feature enables you to view the various stages of performance obligations and the associated deferred and recognized revenue by customer, item, and sales order.
  • NetSuite - Opportunity Snapshot: The opportunity transaction represents a negotiation with a prospect or exising customer. Use the snapshot feature to track the various stages of an opportunity and measure sales force efficiency regarding closing of deals.
  • NetSuite - Commissions Snapshot: This transaction type tracks aspects of the commission process from including plan tracking and the related payout and accounting impact. Enables you to track additional details for partner commissions and employee schedules. The snapshot feature documents the payout timing and related commission calculation.
Additional visualization projects These visualization projects have been added:
  • Spending
  • Gross Margin
  • Financial
  • Customer Acquisition cost (an update to the Customer Growth project)
  • Industry Metrics: Services
Deprecated column The oncredithold column is no longer populated, although you see this column in the DW_NS_customer_D table.

Platform 22.R1 - March 2022

Feature Description
Enhanced custom attribute mapper Custom Attribute Mapper supports custom list and record mapped to a T-type.

22.R1 - February 2022

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Customer Refund: The customer refund subject area tracks the return of funds to a customer who paid for goods or services using cash, a check, or a credit card.
  • NetSuite - Customer Payment Authorization: The refund is generally made in cash or by check. You can split refund details by time, customer, subsidiary, location, and NetSuite User. This subject area tracks credit card authorizations. When accepting credit card payments, Oracle NetSuite Analytics Warehouse sends an authorization request to your credit card gateway to verify a credit card is valid and places a hold on the card holder's funds for the order. The hold on the card holder's funds is immediate. You can split the Payment Authorizations by time, customer, subsidiary, location, and sales order.
  • NetSuite – Commissions: This subject area tracks commission details including defined commission plans, the associated Oracle NetSuite Analytics Warehouse calculations and the payments made to employees. You can track the commission schedules and commission plans by employee, subsidiary, department, item, and location.
  • NetSuite - Fulfillment Request: This subject area tracks fulfillment details representing a request or demand to fulfill a sales order at a fulfillment location. When you create a fulfillment request record from a sales order record, depending on the selected fulfillment choice (Ship or Store Pickup), Oracle NetSuite Analytics Warehouse sets the fulfillment request type to Ship or Store Pickup respectively. Fulfillment request statuses and exceptions are also tracked on this transaction type. You can track the fulfillment requests by customer, subsidiary, location, NetSuite user, and item.
  • NetSuite - Inbound Shipment: The Inbound Shipment subject area allows you to track incoming shipments by vendor, in-transit inventory, and status by location and subsidiary. You can also track landed costs and receiving, and billing details associated with the Inbound Shipment record. You can split the Inbound Shipments by vendor, subsidiary, location, and item.
  • NetSuite – Paycheck: This subject area tracks paycheck record details from a payroll batch and related paycheck adjustments. You can track paycheck details by employee, subsidiary, department, location, and NetSuite user.
  • NetSuite - Paycheck Journal: This subject area tracks paycheck journal details and the related accounting impact. This transaction is like the paycheck transaction used by SuitePeople US Payroll. However, unlike a paycheck, a paycheck journal cannot issue a check drawn on an account. You can track Paycheck Journal details by subsidiary, department, and location.
  • NetSuite – Charge: This subject area tracks charge details and the related attributes. You can do analysis around for example, charge type, date of charge, class, and account.
Additional visualization projects These visualization projects have been added:
  • Customer growth
Additional application roles These additional duty roles are available:
  • NetSuite Analytics Warehouse Payroll Duty
Enhanced data augmentation Data augmentation supports custom field on an entity that is modeled as a dim attribute using lookups in the Oracle NetSuite Analytics Warehouse layer.

See Reference for Oracle NetSuite Analytics Warehouse.

Release 21.R3.P4 - December 2021

Feature Description
Update your application As a service administrator, you can decide when to uptake the application updates except the emergency patches that are deployed automatically. See About Application Updates.
Copy data security assignments in bulk Use the enhanced Copy Assignment functionality to copy data assignments in bulk. See Copy Data Security Assignments.
Examine the status of security-related activities The History tab on the Security page displays a status icon next to each action that shows the status such as "in progress" or "completed successfully". See View Activity History.
Track usage Usage tracking has been turned on in the Oracle Analytics Cloud instance associated with your Oracle NetSuite Analytics Warehouse instance. Usage tracking enables administrators to track user-level queries on the content. Service administrators and functional administrators can track user queries and generate reports and visualizations to analyze the usage data.
Create augmentations with attributes from your extensions Oracle NetSuite Analytics Warehouse supports extension of entities such as customer, item, partner, vendor, and employee. See Augment Your Data.

Release 21.R3.P2 - November 2021

Feature Description
Additional subject areas These subject areas have been added:
  • NetSuite - Inventory Item Location Quantity subject area helps to evaluate the total available and on-hand inventory, committed and backordered inventory. You can also examine whether the inventory is in-transit or on-order.
  • NetSuite - Expense Report subject area helps to analyze Expense Reports and related approval status. Evaluate by legal entity, employee, department, approver, and associated processing details.
  • NetSuite - Expense Report Snapshot subject area helps to analyze Expense Reports and related approval status. Evaluate by legal entity, employee, department, approver, and associated processing details with historical analysis capabilities.
  • NetSuite - Inventory Snapshot subject area is associated with the Advanced Inventory module in NetSuite and provides the ability to analyze key metrics related to Inventory Counts. You can analyze these metrics at a granular level by time, legal entity, location, employee, and approver with historical analysis capabilities.
  • NetSuite - Inventory Worksheet subject area helps do Inventory count and value adjustments deriving from the Inventory Worksheet transaction type. This T-type allows you to update all the inventory items in a single view and is often used during inventory cycle counts. Use this subject area to review the resulting GL impact by subsidiary, location, and GL account.
  • NetSuite - Credit Card Refund subject area helps to review credit card refunds associated with corporate card transactions or specific vendor payments. Evaluate by legal entity, department, payment date, and GL account.
  • NetSuite - Credit Card Charge subject area helps to review credit card charges associated with corporate card transactions or specific vendor payments. Evaluate by legal entity, department, payment date, and GL account.
  • NetSuite - Check subject area helps to review payments recorded in the GL (as opposed to vendor bill payments). Evaluate by legal entity, department, payment date, and GL account. Common use cases include license fees or payments where an invoice is not received.
  • NetSuite - Deposit subject area helps to review bank deposits and associated customer payments. Review deposit details including bank account, transaction date, and payment processing details.
  • NetSuite - Work Order Snapshot subject area provides insight into the work order details including assembly and component quantities. You can analyze the metrics by time, legal entity, accounting period, class, and location. Available data points associated with this transaction type include bill of materials, WIP, routing, scheduling attributes, GL impact, and work order analysis details with historical analysis capabilities.
  • NetSuite - Vendor Bill Snapshot subject area provides the ability to analyze key metrics associated with the vendor bills including number of days outstanding, approver, and payment status. These metrics can be analyzed at a granular level by time, legal entity, product line, department, location and associated purchase orders with historical analysis capabilities.
  • NetSuite - Transfer subject area enables you to review and investigate the inventory transfers between locations within a subsidiary. Review the associated transaction types including item fulfillment, item receipt, and GL impact.
  • NetSuite - Tax Liability Cheque subject area helps to review and investigate the tax liability cheques by province, state, and payee. Review related details including the GL impact, payment date, tax account, and legal entity.
  • NetSuite - Sales Tax Payment subject area enables you to review and investigate the sales tax payments by state and tax jurisdiction. Review related details including the GL impact, payment date, and subsidiary.
Additional visualization projects These visualization projects and KPIs have been added:
  • 31 more KPIs have been added across multiple subject areas.
  • 5 more decks and 42 more visualization projects have been added across multiple subject areas.
Additional application roles These additional duty roles are available:
  • NetSuite Analytics Warehouse Banking Duty
  • NetSuite Analytics Warehouse Employee Expense Duty
Deprecated columns in fact tables The "documentnumber" column from these tables is deprecated:
  • DW_NS_VENDOR_BILL_CREDIT_LINES_F
  • DW_NS_VENDOR_BILL_PAYMENT_LINES_F

See Implementing Oracle NetSuite Analytics Warehouse.

Recent Product Updates

Here’s an overview of the regions where Oracle NetSuite Analytics Warehouse is available.

April 2024

Update Description
Available in Phoenix

Oracle NetSuite Analytics Warehouse rolls out to the Phoenix region.

See Region Availability.

July 2023

Update Description
Available in Tokyo

Oracle NetSuite Analytics Warehouse rolls out to the Tokyo region.

See Region Availability.

December 2022

Update Description
Available in Frankfurt

Oracle NetSuite Analytics Warehouse rolls out to the Frankfurt region.

See Region Availability.

August 2022

Update Description
Available in Sydney

Oracle NetSuite Analytics Warehouse rolls out to the Sydney region.

See Region Availability.

May 2022

Update Description
Available in London

Oracle NetSuite Analytics Warehouse rolls out to the London region.

See Region Availability.