Set up Netsuite Account Analysis

Set up the Netsuite Account Analysis custom data configuration to create the NetSuite Account Analysis or Netsuite Account Analysis Insights subject area or both and later build the account analysis reports in Oracle NetSuite Analytics Warehouse. After selecting and saving the applicable attributes for account analysis, you must publish the account analysis to activate it.

If you're an existing user of Netsuite Account Analysis, the system creates two subject areas, namely Netsuite Account Analysis and Netsuite Account Analysis Insights. If you're a new user, the system creates the Netsuite Account Analysis Insights subject area. Recommendation for the existing users is to start using the Netsuite Account Analysis Insights subject area because the Netsuite Account Analysis subject area is planned for deprecation in a future release.

NetSuite Account Analysis is built on top of existing transaction functional areas, hence, you must perform these prior to activating NetSuite Account Analysis:
  • Mandatorily activate the base functional areas (at least one).
  • Activate all the required base functional areas needed for performing account analysis-based reporting. Following is the list of base functional areas:
    • Sales
    • Purchases and Payables
    • Inventory
    • Manufacturing
    • Bank
    • Financials
    • Employee Expenses
    • Payroll
While configuring the custom account analysis subject area, ensure that you note the value in the Usage column for each of the available columns on the Netsuite Account Analysis page:
  • Certain columns are mandatory for the account analysis report, hence these columns are selected by default and you can't deselect them.
  • Certain columns are recommended and selected by default but you can deselect them based on your requirements for the account analysis reports.
  • Certain columns are optional and you can select them based on your requirements for the account analysis reports.
  • Certain columns are custom attributes and custom transactions-related. They're available for selection if you've completed the prerequisite task. See Prerequisites for Setting up Netsuite Account Analysis. After completing the prerequisite task, you must select the Include custom transaction applicable for Account Analysis check box to have the columns from custom transactions available for selection.

After creating and publishing the custom account analysis subject area, you can create the account analysis reports based on your business requirements. If you change any of the underlying objects specific to the prebuilt base functional areas listed previously or the Custom Attribute Mapper (CAM) extension, you must republish the NetSuite Account Analysis custom data configuration.

  1. Sign in to your service as a functional administrator.
  2. In Oracle NetSuite Analytics Warehouse Console, click Data Configuration, and then on the Data Configuration page, click Custom Data Configurations.
  3. On the Custom Data Configurations page, click Create and then select Netsuite Account Analysis.
  4. On the Netsuite Account Analysis page, select the data elements that you want to include in the custom account analysis template, and then click Save and Exit.
  5. On the Custom Data Configurations page, click Actions for the Netsuite Account Analysis that you created, and then click Publish to deploy the Netsuite Account Analysis for the selected attributes.
After you've successfully deployed the Netsuite Account Analysis custom data configuration but you need to update it, then perform the applicable actions by clicking Actions for the Netsuite Account Analysis that you deployed:
  • Edit
  • Deactivate
  • Refresh Data
  • Reload Data
  • Undeploy
  • Delete