Get Started with Oracle NetSuite Analytics Warehouse

About Oracle NetSuite Analytics Warehouse

Oracle NetSuite Analytics Warehouse enables you to analyze your NetSuite data and generate visualizations and reports.

This service is based on the real-world notions of KPIs, cards, and decks, and provides a collaborative experience optimized for executives and decision-makers. Business analysts can extend Oracle NetSuite Analytics Warehouse using the intuitive KPI editor and other Oracle Analytics Cloud features to author new visualizations, reports, and dashboards. These analytics, whether new or ready-to-use, work alongside KPIs, cards, and decks for a comprehensive data analysis experience.

This packaged service includes Oracle Analytics Cloud and is powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle NetSuite instance into an instance of Oracle Autonomous Data Warehouse. You can then use Oracle Analytics Cloud to customize existing dashboards and create dashboards. You can augment your NetSuite data with data from the custom transaction objects and make the custom data available for reporting.

Oracle NetSuite Analytics Warehouse consists of a data pipeline, data warehouse, semantic model, and best-practice content such as ready-to-use KPIs, dashboards, and reports. Oracle manages the service starting with deployment through performance monitoring, upgrades, and maintenance for the ready-to-use content.

Oracle NetSuite Analytics Warehouse supports several non-English languages, and certain elements such as the user interface and auto-generated text are displayed in those languages.

You can extend your Oracle NetSuite Analytics Warehouse subscription by buying additional user packs. Each user pack contains licenses for five users. User packs available for these license tiers are:

Standard tier: seven user packs
Premium tier: nine user packs
Enterprise tier: No limit on user packs

For example, if you have a Standard Oracle NetSuite Analytics Warehouse license, you can only buy up to seven user packs. If you require nine user packs, then you must upgrade to the Premium license tier.

Region Availability

Oracle NetSuite Analytics Warehouse is available in the following regions currently:

Region Location	Region Name	Region Key
Ashburn, VA	us-ashburn-1	IAD
Frankfurt, Germany	eu-frankfurt-1	FRA
London, United Kingdom	uk-london-1	LHR
Phoenix, AZ	us-phoenix-1	PHX
Sydney, Australia	ap-sydney-1	SYD
Tokyo, Japan	ap-tokyo-1	NRT

Language Support

Oracle NetSuite Analytics Warehouse is supports the following non-English languages:

Arabic
Chinese Simplified
Chinese Traditional
Dutch
French Canadian
French European
German
Italian
Japanese
Portuguese Brazilian
Spanish

About the Autonomous Data Warehouse Tools

If you want to use the tools available in Autonomous Data Warehouse associated with your Oracle NetSuite Analytics Warehouse instance, then note the following:

If you’re an Oracle NetSuite Analytics Warehouse (Standard and Premium) customer, then the Database tools option for only "Data Transforms" is enabled.
If you’re an Oracle NetSuite Analytics Warehouse (Enterprise) customer, then the Database tools option for only Oracle REST Data Services (ORDS), Oracle Application Express (APEX), Data Transforms, and Oracle Machine Learning is enabled.
If you wish to use the Database tools that are enabled, then follow this process:
- Download the wallet and open the README file. See About Autonomous Data Warehouse Wallet and Administrator Credentials.
- In the README file, copy any url for the Database tools listed in the Autonomous Database Tools and Resources section till .com and then append the url after .com for Data Transforms with odi/oracle-data-transforms/ and for Oracle REST Data Services (ORDS) with /ords/. You can use the URLs for Oracle Application Express and Oracle Machine Learning that are available in the README file.

Enable Single Sign-On

Set up the single sign-on authentication to enable users to access their Netsuite account through Oracle NetSuite Analytics Warehouse.

When you enable single sign-on in Oracle NetSuite Analytics Warehouse, you allow single sign-on access to NetSuite using authentication from a third-party identity provider. Users who have signed in to Oracle NetSuite Analytics Warehouse can directly go to NetSuite. They don't need to log in separately to NetSuite, because authentication from the same identity provider is used for login to both Oracle NetSuite Analytics Warehouse and NetSuite.

Ensure that you've configured SAML single sign-on in NetSuite. See Using Single Sign-On with NetSuite Analytics Warehouse.

In Oracle NetSuite Analytics Warehouse, open the Navigator menu, click Console, and then click Authentication.
On the Authentication page, select Enable SSO.
Under Authentication System Settings, in Assertion Consumer URL, enter the URL to direct your identity provider to send its SAML Response after authenticating a user.
In Entity ID, enter the name of your application in the identity provider.
In NamedID Format, ensure Email Address is selected and in NamedID Value, ensure that Primary Email is selected by default.
Expand Advanced Settings, select Enable Single Logout, and provide appropriate values in Logout Binding, Single Logout URL, and Logout Response URL to configure the logout behavior.

Preview Features

Oracle NetSuite Analytics Warehouse offers certain functionality as preview features for you to try. Preview features are high confidence features that are design, specification, and implementation complete with roadmap commitment but may change before they become generally available.

You can evaluate the Preview features for production use as-is based on your specific requirements. If you've questions on the feasibility of deploying a specific Preview feature for production use in your instance, then contact Oracle Support.

Preview features are disabled by default. If you want to explore one of the preview features, ask your administrator to enable it for your organization. Administrators can make preview features available for others to try; see Make Preview Features Available.

To enable the preview features, see Make Preview Features Available.

Connectors

Feature	Description
AWS S3	This feature enables an administrator to connect to data in Amazon Simple Storage Service (AWS S3). See Load Data from Amazon Simple Storage Service into Oracle NetSuite Analytics Warehouse (Preview). On – Display the AWS S3 option in the Create Connection dialog. Off – Hide the AWS S3 option in the Create Connection dialog. Default: Off Restart Required: No
Azure SQL	This feature enables connecting to an Azure SQL instance to create augmentations using data from that instance. See Load Data from Azure SQL into Oracle NetSuite Analytics Warehouse (Preview). On – Display the Azure SQL option in the Create Connection dialog. Off – Hide the Azure SQL option in the Create Connection dialog. Default: Off Restart Required: No
Azure Storage	This feature enables connecting to an Azure Storage instance to create augmentations using data from that instance. See Load Data from Azure Storage into Oracle NetSuite Analytics Warehouse (Preview). On – Display the Azure Storage option in the Create Connection dialog. Off – Hide the Azure Storage option in the Create Connection dialog. Default: Off Restart Required: No
Oracle Autonomous Database	This feature enables an administrator to connect to custom data in Oracle Autonomous Database. You can create up to five connections to different Oracle Autonomous Database instances and they are denoted as Oracle Autonomous Database 1, Oracle Autonomous Database 2, Oracle Autonomous Database 3, Oracle Autonomous Database 4, and Oracle Autonomous Database 5. See Load Data from Oracle Autonomous Database into Oracle NetSuite Analytics Warehouse (Preview). On – Display the Oracle Autonomous Database option such as Oracle Autonomous Database 1 in the Create Connection dialog. Off – Hide the Oracle Autonomous Database option such as Oracle Autonomous Database 1 in the Create Connection dialog. Default: Off Restart Required: No
Oracle BI Publisher	This feature enables connecting to an Oracle Analytics Publisher instance to create augmentations using data from that instance. See Load Data from Oracle Analytics Publisher into NetSuite Analytics Warehouse (Preview). On – Display the Oracle BI Publisher option in the Create Connection dialog. Off – Hide the Oracle BI Publisher option in the Create Connection dialog. Default: Off Restart Required: No
Oracle E-Business Suite On-Prem	This feature enables configuring remote agent, loading data from on-premises Oracle eBusiness Suite (EBS), and building a complete managed data pipeline with that data. See Load Data from On-premises E-Business Suite into NetSuite Analytics Warehouse (Preview). On – Display the Oracle E-Business Suite On-Prem option in the Create Connection dialog. Off – Hide the Oracle E-Business Suite On-Prem option in the Create Connection dialog. Default: Off Restart Required: No
Oracle Eloqua	This feature enables connecting to an Oracle Eloqua instance to bring business-relevant marketing and sales campaign data to build a managed data pipeline with data from that instance. See Connect with Your Oracle Eloqua Data Source. On – Display the Oracle Eloqua option in the Create Connection dialog. Off – Hide the Oracle Eloqua option in the Create Connection dialog. Default: Off Restart Required: No
Oracle Enterprise Data Management Cloud	This feature enables connecting to Oracle Enterprise Data Management Cloud service instance to build a managed data pipeline with data from that instance. See Load Data from Enterprise Data Management Cloud into NetSuite Analytics Warehouse (Preview). On – Display the Oracle Enterprise Data Management Cloud option in the Create Connection dialog. Off – Hide the Oracle Enterprise Data Management Cloud option in the Create Connection dialog. Default: Off Restart Required: No
Oracle EPM - Enterprise Data Management	This feature enables connecting to an Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into NetSuite Analytics Warehouse (Preview). On – Display the Oracle EPM - Enterprise Data Management option in the Create Connection dialog. Off – Hide the Oracle EPM - Enterprise Data Management option in the Create Connection dialog. Default: Off Restart Required: No
Oracle EPM - Financial Close and Consolidation	This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into NetSuite Analytics Warehouse (Preview). On – Display the Oracle EPM - Financial Close and Consolidation option in the Create Connection dialog. Off – Hide the Oracle EPM - Financial Close and Consolidation option in the Create Connection dialog. Default: Off Restart Required: No
Oracle EPM - Planning and Budgeting	This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into NetSuite Analytics Warehouse (Preview). On – Display the Oracle EPM - Planning and Budgeting option in the Create Connection dialog. Off – Hide the Oracle EPM - Planning and Budgeting option in the Create Connection dialog. Default: Off Restart Required: No
Oracle EPM - Profitability and Cost Management	This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into NetSuite Analytics Warehouse (Preview). On – Display the Oracle EPM - Profitability and Cost Management option in the Create Connection dialog. Off – Hide the Oracle EPM - Profitability and Cost Management option in the Create Connection dialog. Default: Off Restart Required: No
Oracle JD Edwards On-Prem	This feature enables connecting to the various data sources in the on-premises JD Edwards instance and building a complete managed data pipeline with that data. See Load Data from On-premises JD Edwards into NetSuite Analytics Warehouse (Preview). On – Display the Oracle JD Edwards On-Prem option in the Create Connection dialog. Off – Hide the Oracle JD Edwards On-Prem option in the Create Connection dialog. Default: Off Restart Required: No
Oracle JDBC	This feature enables the remote agent-managed connectivity to Oracle database using JDBC. You can create upto five connections and they are denoted as Oracle JDBC 1, Oracle JDBC 2, Oracle JDBC 3, Oracle JDBC 4, and Oracle JDBC 5. See Load Data from Oracle Database Using JDBC into NetSuite Analytics Warehouse (Preview). On – Display the Oracle JDBC option such as Oracle JDBC 1 in the Create Connection dialog. Off – Hide the Oracle JDBC option such as Oracle JDBC 1 in the Create Connection dialog. Default: Off Restart Required: No
MongoDB	This feature enables connecting to a MongoDB instance to build a managed data pipeline with data from that instance. See Load Data from Mongo Database into NetSuite Analytics Warehouse (Preview). On – Display the MongoDB option in the Create Connection dialog. Off – Hide the MongoDB option in the Create Connection dialog. Default: Off Restart Required: No
MySQL Cloud	This feature enables connecting to MySQL Cloud instance to build data augmentation with data from that instance. See Load Data from MySQL Cloud Database into NetSuite Analytics Warehouse (Preview). On – Display the MySQL Cloud option in the Create Connection dialog. Off – Hide the MySQL Cloud option in the Create Connection dialog. Default: Off Restart Required: No
MySQL On-Prem	This feature enables connecting to a MySQL on-premises instance to build data augmentation with data from that instance. See Load Data from On-premises MySQL Database into NetSuite Analytics Warehouse (Preview). On – Display the MySQL On-Prem option in the Create Connection dialog. Off – Hide the MySQL On-Prem option in the Create Connection dialog. Default: Off Restart Required: No
Oracle PeopleSoft On-Prem - Campus Solutions	This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into NetSuite Analytics Warehouse (Preview). On – Display the Oracle PeopleSoft On-Prem - Campus Solutions option in the Create Connection dialog. Off – Hide the Oracle PeopleSoft On-Prem - Campus Solutions option in the Create Connection dialog. Default: Off Restart Required: No
Oracle PeopleSoft On-Prem - Financials	This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into NetSuite Analytics Warehouse (Preview). On – Display the Oracle PeopleSoft On-Prem - Financials option in the Create Connection dialog. Off – Hide the Oracle PeopleSoft On-Prem - Financials option in the Create Connection dialog. Default: Off Restart Required: No
Oracle PeopleSoft On-Prem - Human Resources	This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into NetSuite Analytics Warehouse (Preview). On – Display the Oracle PeopleSoft On-Prem - Human Resources option in the Create Connection dialog. Off – Hide the Oracle PeopleSoft On-Prem - Human Resources option in the Create Connection dialog. Default: Off Restart Required: No
Oracle PeopleSoft On-Prem - Learning Management	This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into NetSuite Analytics Warehouse (Preview). On – Display the Oracle PeopleSoft On-Prem - Learning Management option in the Create Connection dialog. Off – Hide the Oracle PeopleSoft On-Prem - Learning Management option in the Create Connection dialog. Default: Off Restart Required: No
QuickBooks Online	This feature enables connecting to a QuickBooks Online instance to create augmentations using data from that instance. See Load Data from QuickBooks Online into Oracle NetSuite Analytics Warehouse (Preview). On – Display the QuickBooks Online option in the Create Connection dialog. Off – Hide the QuickBooks Online option in the Create Connection dialog. Default: Off Restart Required: No
Remote Agent	Remote Agent application helps bring data from the on-premises applications like E-Business Suite and JD Edwards into Oracle Fusion Data Intelligence. See Set up the Remote Agent to Load Data into NetSuite Analytics Warehouse (Preview). On – Display the Remote Agent option in the Create Connection dialog. Off – Hide the Remote Agent option in the Create Connection dialog. Default: Off Restart Required: No
SFTP	This feature enables connecting to a Secure FTP source and building a complete managed data pipeline with that data. See Load Data from a Secure FTP Source into NetSuite Analytics Warehouse (Preview). On – Display the SFTP option in the Create Connection dialog. Off – Hide the SFTP option in the Create Connection dialog. Default: Off Restart Required: No
Shopify	This feature enables connecting to a Shopify instance and building a complete managed data pipeline with that data. See Load Data from Shopify into NetSuite Analytics Warehouse (Preview). On – Display the Shopify option in the Create Connection dialog. Off – Hide the Shopify option in the Create Connection dialog. Default: Off Restart Required: No
Snowflake	This feature enables connecting to a Snowflake instance and creating augmentations using that data. See Load Data from Snowflake into Oracle NetSuite Analytics Warehouse (Preview). On – Display the Snowflake option in the Create Connection dialog. Off – Hide the Snowflake option in the Create Connection dialog. Default: Off Restart Required: No
SQL Server	This feature enables connecting to the SQL Server instance to create augmentations using data from that instance. See Load Data from SQL Server into Oracle NetSuite Analytics Warehouse (Preview). On – Display the SQL Server option in the Create Connection dialog. Off – Hide the SQL Server option in the Create Connection dialog. Default: Off Restart Required: No
Taleo	This feature enables connecting to a Taleo instance and creating augmentations using that data. See Load Data from Taleo into NetSuite Analytics Warehouse (Preview). On – Display the Taleo option in the Create Connection dialog. Off – Hide the Taleo option in the Create Connection dialog. Default: Off Restart Required: No

Functional Areas

Feature	Description
Order to cash	This feature provides you the ability to perform cross-transactional analysis with the Order to Cash (O2C) flow. After enabling this functional area, ensure to create a data pipeline and activate it. See Create a Data Pipeline for a Functional Area.
Procure to pay	This feature provides you the ability to perform cross-transactional analysis with the Procure to Pay (P2P) flow. After enabling this functional area, ensure to create a data pipeline and activate it.

Pipeline Features

Feature	Description
Data Refresh Estimate	This feature enables prediction of completion time for data refresh. The predicted time is visible under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. See About Data Refresh Performance. On – Display the Estimated Refresh Completion detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. Off – Hide the Estimated Refresh Completion detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. Default: Off Restart Required: No
Frequent Refresh Tables	This feature enables custom warehouse tables for frequent data refresh. See Schedule Frequent Refreshes of Warehouse Tables. On – Display the Frequent Refresh Tables detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. Off – Hide the Frequent Refresh Tables detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. Default: Off Restart Required: No
Prioritized Data Refresh	This feature enables configuration of the warehouse tables for prioritized refresh ahead of other data in the regularly scheduled daily refresh cycles. See Prioritize Datasets for Incremental Refresh (Preview). On – Display the Prioritized Data Refresh tab on the Pipeline Settings page. Off – Hide the Prioritized Data Refresh tab on the Pipeline Settings page. Default: Off Restart Required: No

Feature

Description

Data Refresh Estimate

This feature enables prediction of completion time for data refresh. The predicted time is visible under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.

See About Data Refresh Performance.

On – Display the Estimated Refresh Completion detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.
Off – Hide the Estimated Refresh Completion detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.

Default: Off

Restart Required: No

Frequent Refresh Tables

This feature enables custom warehouse tables for frequent data refresh.

See Schedule Frequent Refreshes of Warehouse Tables.

On – Display the Frequent Refresh Tables detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.
Off – Hide the Frequent Refresh Tables detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.

Default: Off

Restart Required: No

Prioritized Data Refresh

This feature enables configuration of the warehouse tables for prioritized refresh ahead of other data in the regularly scheduled daily refresh cycles.

See Prioritize Datasets for Incremental Refresh (Preview).

On – Display the Prioritized Data Refresh tab on the Pipeline Settings page.
Off – Hide the Prioritized Data Refresh tab on the Pipeline Settings page.

Default: Off

Restart Required: No

Make Preview Features Available

As a functional administrator, you can enable the functionality available as a preview feature to try it out.

Preview features allow your organization to explore and try new features before they roll out by default. See Preview Features.

The preview features aren't available by default, but administrators can turn individual preview features on or off at any time. Administrators can find the latest preview features in the Enable Features tile on the Console and switch them on for others to use.

Sign in to your service.
In Oracle NetSuite Analytics Warehouse Console, click Enable Features under Application Administration.
On the Enable Features page, under the Preview Features tab, expand the categories such as Functional Areas and select the features that you want to make available for your organization.
Navigate to the location of the preview feature you want to use. For example, if you’ve enabled AWS S3 in the Managed Pipeline category, then navigate to the Create Connections dialog from the Manage Connections page to use this feature.

Generally Available Features

Oracle NetSuite Analytics Warehouse offers certain functionality as generally available that you must enable using the Console. Generally available features are publicly available features that you can use for production workloads.

Generally available features are disabled by default. Administrators can make these features available for others to use; see Enable Generally Available Features.

Pipeline Features

Feature	Description
Frequent Refresh	This feature enables certain pipeline refresh schedules to be set to a frequency of 4 hours or higher. See Schedule Frequent Refreshes of Data. On – Display the Frequent Refresh option on the Pipeline Settings page. Off – Hide the Frequent Refresh option on the Pipeline Settings page. Default: Off Restart Required: No
Scheduled Full Data Reload	For specific functional areas, an administrator can schedule full refreshes on a weekly, monthly, or quarterly basis. See Schedule Periodic Full Reload of Functional Area Data. On – Display the Scheduled Full Data Reload on the Pipeline Settings page. Off – Hide the Scheduled Full Data Reload on the Pipeline Settings page. Default: Off Restart Required: No
Data Source Reset and Reload	This feature enables reset and reload of a data source. See Reset and Reload the Data Source. On – Display the Data Source Reset and Reload detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. Off – Hide the Data Source Reset and Reload detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. Default: Off Restart Required: No

Feature

Description

Frequent Refresh

This feature enables certain pipeline refresh schedules to be set to a frequency of 4 hours or higher.

See Schedule Frequent Refreshes of Data.

On – Display the Frequent Refresh option on the Pipeline Settings page.
Off – Hide the Frequent Refresh option on the Pipeline Settings page.

Default: Off

Restart Required: No

Scheduled Full Data Reload

For specific functional areas, an administrator can schedule full refreshes on a weekly, monthly, or quarterly basis.

See Schedule Periodic Full Reload of Functional Area Data.

On – Display the Scheduled Full Data Reload on the Pipeline Settings page.
Off – Hide the Scheduled Full Data Reload on the Pipeline Settings page.

Default: Off

Restart Required: No

Data Source Reset and Reload

This feature enables reset and reload of a data source.

See Reset and Reload the Data Source.

On – Display the Data Source Reset and Reload detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.
Off – Hide the Data Source Reset and Reload detail under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page.

Default: Off

Restart Required: No

Enable Generally Available Features

As a functional administrator, you can enable the functionality that is generally available but needs you to enable it to use the specific functionality.

The generally available features aren't available by default, but administrators can turn individual features on or off at any time. Administrators can find the latest generally available features in the Enable Features tile on the Console and switch them on for others to use.

To find out about features that are generally available currently, see Generally Available Features.

Sign in to your service.
In Oracle NetSuite Analytics Warehouse Console, click Enable Features under Application Administration.
On the Enable Features page, under the Generally Available Features tab, expand the categories such as Pipeline Features and select the features that you want to make available for your organization.
Navigate to the location of the feature you want to use. For example, if you’ve enabled Frequent Refresh in the Pipeline Features category, then navigate to the Pipeline Settings page and click Frequent Data Refresh Schedule to use this feature.

Configure Advanced Options

You can set several advanced options using the Console.

Topics:

About Advanced Configuration

Administrators can set more advanced, service-level options through the Systems Settings page.

Topics:

Email Delivered by Agents Options

You can use these options to customize the way agents deliver email.

System Setting	More Information
Maximum Email Size (KB)	Specifies the maximum size (KB) of a single email. If you set a maximum email size, you can avoid situations when SMTP servers reject emails that are too large, and in the event that an email exceeds the set limit, the email recipients receive an error message instead of the agent failing and just alerting the email author. Valid Values: 0-20480 Default: 0 (unlimited email size) API Key: EmailMaxEmailSizeKB Edition: Enterprise only
Maximum Number of Recipients per Email	Specifies the maximum number of recipients allowed in the To: or Bcc: line for a single email. You can set the maximum number of email recipients to avoid some SMTP servers from filtering out these emails as spam. If the recipient list exceeds the set limit, the list is split into smaller lists with the maximum number of allowed recipients in each list. Valid Values: 0-1024 Default: 0 (unlimited number of email recipients) API Key: EmailMaxRecipients Edition: Enterprise only
Safe Domains	If you want to restrict the email domain that Oracle Analytics can send emails to, enter the name of the domain. For example, `examplemaildomain.com`. Use a comma to separate multiple domain names. For example, `exampledomain1.com,exampledomain2.com`. By default, there are no restrictions. API Key: EmailSafeDomains Edition: Enterprise only
Use BCC	Specifies whether to include the names of email recipients in the To: or Bcc: line. By default, email recipients are added to the Bcc: line. On — Add email recipients to the Bcc: line. Names of email recipients are hidden. Off — Add email recipients to the To: line. Everyone who receives the email sees the recipient list. Default: On API Key: EmailUseBcc Edition: Enterprise only
Use RFC 2231 Encoding	Specifies how to encode MIME email parameters. By default, RFC 2047 is used. On — Use RFC 2231 to encode MIME email parameter values. RFC 2231 supports multi-byte languages. Select On if you deliver emails that contain multi-byte characters and use an email server that supports RFC 2231, such as Microsoft Outlook for Office 365 or Google Gmail. Off — Use RFC 2047 to encode MIME email parameter values. Default: Off API Key: EmailUseRFC2231 Edition: Enterprise only

Other Options

These system setting options in the Console enable you to set the behavior for a variety of actions such as database queries, default URLs, display defaults, and sorting.

Note:

If you change one of these settings, you must apply the change for the new value to take effect unless we note it otherwise.

System Setting	More Information
Hide Loading Messages	Specifies if a detailed message is displayed during data load processing. On — Detailed loading messages are hidden and a simplified message Loading... is displayed instead. Off — Detailed loading messages are displayed. Default: Off API Key: HideLoadingMessages Edition: Professional and Enterprise

System Setting

More Information

Hide Loading Messages

Specifies if a detailed message is displayed during data load processing.

On — Detailed loading messages are hidden and a simplified message Loading... is displayed instead.
Off — Detailed loading messages are displayed.

Default: Off

API Key: HideLoadingMessages

Edition: Professional and Enterprise

Performance and Compatibility Options

You use these options to configure performance and compatibility settings between Oracle BI Enterprise Edition and Oracle Analytics.

Note:

If you change a performance and compatibility setting, you must apply the change for the new value to take effect unless mentioned otherwise.

System Setting	More Information
Brushing Enabled for Datasets	Specifies whether brushing is enabled by default for workbooks that use dataset data. On — Brushing is on by default for workbooks that use dataset data. Off — Brushing is off by default for workbooks that use dataset data. Users can override this setting in the workbook and canvas properties. Default: On API Key: EnableBrushingDatasets Edition: Professional and Enterprise
Brushing Enabled for Subject Areas	Specifies whether brushing is enabled by default for workbooks that use data from subject areas. On — Brushing is on by default for workbooks that use subject area data. Off — Brushing is off by default for workbooks that use subject area data. Users can override this setting in the workbook and canvas properties. Default: On API Key: EnableBrushingSubjectAreas Edition: Enterprise only
Enable Auto Insights on Datasets	Specifies whether the Auto Insights feature is available when datasets are created or modified. On — The Enable Insights option is available in the Dataset Inspect dialog and insights are automatically generated and available for workbooks that use datasets with the Enable Insights option selected. Off — Auto Insights and its related features are disabled. Default: On Apply Change Required: No, but when you change this setting, it may take a few minutes to take effect.
Evaluate Support Level	Specifies who can issue database functions: `EVALUATE`, `EVALUATE_ANALYTIC`, `EVALUATE_AGGR`, and `EVALUATE_PREDICATE`. By default (`0`), the `EVALUATE` database functions are disabled. 1 — Service administrators only. Users with the BI Service Administrator application role can invoke `EVALUATE` database functions. 2 — Anyone. Any user who signs in to can invoke `EVALUATE` database functions. 0 (or any other value) — No one. All `EVALUATE` database functions are disabled in . Valid Values: 0, 1, 2 Default: 0 API Key: EvaluateSupportLevel Edition: Professional and Enterprise

Preview Options

Administrators can turn some preview features on and off. This way, your organization can evaluate and learn how to use new features before they roll out by default.

System Setting	More Information
Preview the Generic REST Connector	Enable this option to try out the REST connector and visualize data from a data source with a REST endpoint. Use this connector to access data from a REST endpoint and create datasets. See Connect to Data from REST Endpoints and Create a Dataset from a REST Connection. On — Displays the REST API connection option on the Create Connection dialog. Off — Hides the REST API connection option. Default: Off Apply Change Required: No API Key: PreviewGenericRestConnector Edition: Enterprise only
Preview Workbook Email Scheduler	Enable this option so that administrators can set up a schedule to regularly share their workbooks with one or more email recipients in PDF or PNG format. See Share Visualizations Using Workbook Email Schedules (Preview). On — Displays the Schedule option in the Actions menu of a workbook to users with the BI Service Administrator application role with Read-Write access and the Edit share permission on the workbook. Off — Disables and hides the Schedule option in the Actions menu of a workbook. Default: Off Apply Change Required: No API Key: PreviewWorkbookEmailScheduler Edition: Enterprise only
Preview Workbook Email Scheduling with Bursting	Enable this option to allow administrators to set bursting options when emailing workbooks saved in Shared Folders. This option requires Preview Workbook Email Scheduler to be enabled. See Share Visualizations Using Workbook Email Schedules (Preview) and Create a Bursting Workbook Email Schedule (Preview). On — Enables users with a BI Service Administrator application role with Read-Write access and the Edit share permission for the workbook to enable the Bursting option in the Email tab of a workbook schedule if the workbook is saved in Shared Folders. Off — Disables the Bursting option in the Email tab of a workbook schedule. Default: Off Apply Change Required: No API Key: PreviewWorkbookEmailBursting Edition: Enterprise only

System Setting

More Information

Preview the Generic REST Connector

Enable this option to try out the REST connector and visualize data from a data source with a REST endpoint. Use this connector to access data from a REST endpoint and create datasets. See Connect to Data from REST Endpoints and Create a Dataset from a REST Connection.

On — Displays the REST API connection option on the Create Connection dialog.
Off — Hides the REST API connection option.

Default: Off

Apply Change Required: No

API Key: PreviewGenericRestConnector

Edition: Enterprise only

Preview Workbook Email Scheduler

Enable this option so that administrators can set up a schedule to regularly share their workbooks with one or more email recipients in PDF or PNG format. See Share Visualizations Using Workbook Email Schedules (Preview).

On — Displays the Schedule option in the Actions menu of a workbook to users with the BI Service Administrator application role with Read-Write access and the Edit share permission on the workbook.
Off — Disables and hides the Schedule option in the Actions menu of a workbook.

Default: Off

Apply Change Required: No

API Key: PreviewWorkbookEmailScheduler

Edition: Enterprise only

Preview Workbook Email Scheduling with Bursting

Enable this option to allow administrators to set bursting options when emailing workbooks saved in Shared Folders. This option requires Preview Workbook Email Scheduler to be enabled. See Share Visualizations Using Workbook Email Schedules (Preview) and Create a Bursting Workbook Email Schedule (Preview).

On — Enables users with a BI Service Administrator application role with Read-Write access and the Edit share permission for the workbook to enable the Bursting option in the Email tab of a workbook schedule if the workbook is saved in Shared Folders.
Off — Disables the Bursting option in the Email tab of a workbook schedule.

Default: Off

Apply Change Required: No

API Key: PreviewWorkbookEmailBursting

Edition: Enterprise only

Security Options

Use Security options to control how users can perform specific actions in analyses and dashboards.

These options apply only to analyses and dashboards. They don't apply to data visualizations.

Note:

If you change a security setting, you must apply the change for the new value to take effect.

System Setting	More Information
Allow HTML/JavaScript/CSS Content	Determines whether users can apply and save HTML, JavaScript, and CSS markup in various text fields for analyses and dashboards, and how any previously saved markup is used. Always — Enables users to apply markup. Displays the Contains HTML/JavaScript/CSS Markup option in dialogs where additional formatting might be useful. For example: For analyses: Various dialogs in the analysis editor, Analysis Properties dialog, Column Properties (Column Format) dialog, Edit Column Formula dialog, Narrative dialog, Ticker dialog, Static Text dialog, and New Calculated Measure dialog. For dashboards: Various dialogs in the dashboard editor, Text Properties dialog, and Edit Header and Edit Footer dialogs (under Print and Export Options). Never — Prevents users from applying markup. Hides the Contains HTML/JavaScript/CSS Markup option. Users can only enter plain text. Oracle Analytics ignores any markup that users previously entered and saved for their analyses and dashboards. HTML Only — Enables users to apply HTML markup. Displays the Contains HTML/JavaScript/CSS Markup option in dialogs where additional formatting might be useful but only safe HTML is allowed (no JavaScript or CSS). When an analysis or dashboard opens, Oracle Analytics sanitizes any markup that users have entered and applies only the HTML markup. On Open — Prevents users from applying additional markup (existing markup is retained). Hides the Contains HTML/JavaScript/CSS Markup option so users can enter only plain text. Any previously saved markup for analyses and dashboards continues to be applied. Note: The On Open option was previously named "Off". API Key: AllowHTMLJavaScriptCSSContent Edition: Enterprise only

System Setting

More Information

Allow HTML/JavaScript/CSS Content

Determines whether users can apply and save HTML, JavaScript, and CSS markup in various text fields for analyses and dashboards, and how any previously saved markup is used.

Always — Enables users to apply markup. Displays the Contains HTML/JavaScript/CSS Markup option in dialogs where additional formatting might be useful. For example:
- For analyses: Various dialogs in the analysis editor, Analysis Properties dialog, Column Properties (Column Format) dialog, Edit Column Formula dialog, Narrative dialog, Ticker dialog, Static Text dialog, and New Calculated Measure dialog.
- For dashboards: Various dialogs in the dashboard editor, Text Properties dialog, and Edit Header and Edit Footer dialogs (under Print and Export Options).
Never — Prevents users from applying markup. Hides the Contains HTML/JavaScript/CSS Markup option. Users can only enter plain text. Oracle Analytics ignores any markup that users previously entered and saved for their analyses and dashboards.
HTML Only — Enables users to apply HTML markup. Displays the Contains HTML/JavaScript/CSS Markup option in dialogs where additional formatting might be useful but only safe HTML is allowed (no JavaScript or CSS). When an analysis or dashboard opens, Oracle Analytics sanitizes any markup that users have entered and applies only the HTML markup.
On Open — Prevents users from applying additional markup (existing markup is retained). Hides the Contains HTML/JavaScript/CSS Markup option so users can enter only plain text. Any previously saved markup for analyses and dashboards continues to be applied.
Note: The On Open option was previously named "Off".

API Key: AllowHTMLJavaScriptCSSContent

Edition: Enterprise only

Set Advanced Options

Use the service instance console to set advanced options for Oracle NetSuite Analytics Warehouse.

In Oracle NetSuite Analytics Warehouse, click Console.
Under Service Administration, click System Settings.
On the System Settings page, update the toggle option for the applicable advanced option.

Typical Workflow to Get Started with Oracle NetSuite Analytics Warehouse

To get started with Oracle NetSuite Analytics Warehouse for the first time, follow these tasks as a guide.

Task	Description	More Information
Enable NetSuite Analytics Warehouse	As an administrator, enable NetSuite Analytics Warehouse in the NetSuite account of the users.	Enabling NetSuite Analytics Warehouse, NetSuite Analytics Warehouse
Add and delete users.	As a user, after your administrator enables NetSuite Analytics Warehouse in your NetSuite account, add and delete users. Adding users to your NetSuite Analytics Warehouse account enables the users to work with data transferred to the data warehouse. You can add existing NetSuite users and non-NetSuite users.	Adding Users to NSAW, NetSuite Analytics Warehouse
Change the user account for data transfer credentials.	By default, NetSuite Analytics Warehouse assigns the data transfer credentials to the user that enabled NetSuite Analytics Warehouse. Oracle recommends that you use a generic email address such as user_account_data_transfer@example.com to ensure that the transfer credentials remain valid if the user that enabled NetSuite Analytics Warehouse leaves the organization.	Resetting NetSuite Analytics Warehouse Transfer Credentials, NetSuite Analytics Warehouse
Set up the data transfer in the NetSuite user interface.	As a user, begin transferring data to the NetSuite Analytics Warehouse by selecting the functional area.	Setting Up the Data Transfer, NetSuite Analytics Warehouse
Alternatively, set the pipeline parameters and create a data pipeline for a functional area to transfer data to the warehouse using the Data Configuration page in the NetSuite Analytics Warehouse user interface.	You can transfer data to the warehouse using the Data Configuration page. You specify the pipeline and report parameters and then create a data pipeline for a functional area.	Set Up the Pipeline Parameters Set Up the Reporting Configurations Create a Data Pipeline for a Functional Area
Start analyzing your data	After the data is transferred to the autonomous data warehouse, you can analyze your data using the capabilities of Oracle Analytics Cloud that is included with NetSuite Analytics Warehouse.	Get Started with KPIs, Decks, and Cards, Using Oracle Fusion Data Intelligence Work with Projects, Using Oracle Fusion Data Intelligence Work with Data, Using Oracle Fusion Data Intelligence

Additionally, as an advanced user, you can perform these tasks:

Task	Description	More Information
Augment your data	You can supplement the data in your reports by extending the transaction entity, creating custom dimensions and custom facts.	Augment Your Data
Integrate third-party data	You can integrate data from other sources with the NetSuite data. Through this integration, you can create KPIs, metrics, cards, and dashboards using data from multiple sources.	Integrate Third-Party Data

Task

Description

More Information

Augment your data

You can supplement the data in your reports by extending the transaction entity, creating custom dimensions and custom facts.

Augment Your Data

Integrate third-party data

You can integrate data from other sources with the NetSuite data. Through this integration, you can create KPIs, metrics, cards, and dashboards using data from multiple sources.

Integrate Third-Party Data