Report Authoring Tips for Oracle NetSuite Analytics Warehouse

This section provides information about commonly encountered use cases and frequently asked questions regarding Oracle NetSuite Analytics Warehouse reporting. The information isn’t exhaustive and is updated regularly with additional information and authoring tips.

General Tips for Reporting on Oracle NetSuite Analytics Warehouse

Only non-serialized inventory is supported in prebuilt dashboards.
You can add custom columns from Transaction Line Fields but not Transaction Item Options.

Tips for Reporting on Subsidiary

Oracle NetSuite Analytics Warehouse automatically filters data to include the configured reporting subsidiary and all child subsidiaries. You can further filter data to include a single subsidiary.

Tips for Reporting on Analytics Currency

In most cases, a set of defined analytics currency, or reporting currency, metrics convert from the subsidiary base currency on the transaction to the reporting subsidiary’s base currency. These metrics are calculated using the Consolidated Exchange Rates table in NetSuite. In cases where the Consolidated Exchange Rates isn’t used or hasn’t been setup correctly, the metrics default to the base currency metrics. Metrics can be calculated using the Current, Average, Historical exchange rate, or per Account.

Tips for Reporting on Exchange Rate Type

Analytics Currency metrics are calculated using Current, Average, Historical exchange rates, or per Account. To prevent amounts that are 4 times the expected amount, always add an Exchange Rate Type filter to all analyses and workbooks when using Analytics Currency metrics.

Tips for Reporting on Multi-Book Accounting

When multi-book accounting is enabled, the grain of the line-level transaction tables is at the accounting book level. Add an Accounting Book filter to all analyses and workbooks containing line-level data when multi-book accounting has been enabled in NetSuite.

Tips for Reporting on Budget and Inventory Insights

These subject areas don't have a standard time dimension so useing the Accounting Period filter is required.

Recommended Filters

Subject Area	Presentation Columns (* Required Filter)
All Subject Areas (non-snapshot)	Time (Fiscal Calendar or Gregorian Calendar)* Accounting Book (if Multi-book Accounting is enabled) Exchange Rate Type* (required for both snapshot and non-snapshot when using Analytics Currency metrics)
All Snapshot Subject Areas	Snapshot Calendar* Exchange Rate Type* (required for both snapshot and non-snapshot when using Analytics Currency metrics)
Item Fulfillment Snapshot	Snapshot Calendar Exchange Rate Type Accounting Book Item