NetSuite Analytics Warehouse

The Analytics Warehouse enables businesses to analyze historical data from multiple sources and determine how to improve their business. When enabled, you can begin transferring your data to the Analytics Warehouse. You can then blend your NetSuite data with data from other sources, and analyze it with a wide set of visualizations.

Feature to Enable – NetSuite Analytics Warehouse

• Adding Users
• Set Up Data Transfer

Adding Users

Adding users to your Analytics Warehouse account enables them to work with data transferred to the Analytics Warehouse. You can add NetSuite users and non-NetSuite users.

To add NetSuite users to your NetSuite Analytics Warehouse account:

1. Go to Setup > Integration > NetSuite Analytics Warehouse > Configuration (Administrator).

1. Click NSAW User Management.
2. Click Add NetSuite Users.
3. Select the users you want to add and click Apply.

To add an external user to your NetSuite Analytics Warehouse account:

1. Go to Setup > Integration > NetSuite Analytics Warehouse > Configuration (Administrator).

1. Click NSAW User Management.
2. Click Add External User.
3. Enter the first name, last name, and email address of the user and click OK.

All new users, both NetSuite and external, receive an email notification asking them to complete their Oracle Analytics for Applications (OAX) account activation and enter a password. Use these credentials to access the NetSuite Analytics Warehouse homepage.

Data Transfer

To set up the data transfer:

1. Go to Setup > Integration > NetSuite Analytics Warehouse > Configuration (Administrator).
2. Click NSAW Data Transfer Setup.
3. Select the date from when you want your data transferred.
4. Select the subsidiary.
5. Select the functional areas to include in the transfer.

Data from the selected functional areas is refreshed automatically every 24 hours. The Last Transfer column displays the date and time of the first automatic data transfer, or the last manual data transfer. You can find the time remaining before the next automatic data transfer above the functional area list. You can select the interval and specify the time, day, and month of your incremental data load in the Oracle NetSuite Analytics Warehouse.

The first data transfer may take some time. The subsequent data transfers happen incrementally every day.

You don’t have to wait until the scheduled data transfer. To work with the most recent data, click Transfer Data in the Transfer Data column to manually start a data transfer. The status of the data transfer is shown in the Last Transfer column.

You can transfer all the data of all your active functional areas by clicking Reset Functional Areas. This action queues all functional areas and transfers all data, not only the incremental data, to Oracle NetSuite Analytics Warehouse. No data is lost by doing this action.