Manuelito Borja-Oracle Blue Ribbon

The Activations page isn’t a separate tile on the Data Configuration landing page shown in your screenshot. In the current NSAW interface, go to: Data Configuration → Applications → NetSuite Warehouse Then select the applicable NetSuite Warehouse category. The Activations page is available within the NetSuite Warehouse…

Hello @User_5NVEC , Based on the additional information and the screenshot, there is one important point I would check first: Inventory Turnover is a separate NSAW functional area. It is not sufficient to have only Inventory Snapshot activated. Oracle's current documentation lists: Inventory…

Hello again @User_5NVEC , Yes — Oracle does provide documentation that can be used as the foundation for a repeatable reconciliation process. I would not describe it as a single "NSAW-to-NetSuite reconciliation best-practice guide," though. The relevant guidance is spread across the Subject Area Reference, Data Validation,…

Hi @User_5NVEC , Yes. Based on Oracle's current documentation, I would separate empty OOB visualizations from missing functional-area enablement. An OOB workbook is a presentation layer over predefined subject areas and metrics. Oracle's documentation confirms that prebuilt workbooks are delivered as part of the NSAW…

Based on the current NSAW documentation, I would not assume that Analytics Currency automatically converts every monetary field in a subject area. For Inventory Item Location Quantity, the current Oracle Reference documentation lists the AC/BC/TC metrics as quantity measures such as Available Quantity, On Hand Quantity,…

Hi @User_5NVEC , The fact that you're finding rows in inventoryitemlocations that don't have a corresponding row in the NetSuite source database is worth investigating, but I would not assume that the rows are necessarily incorrect. A few points are important here. First, Inventory Item Location Quantity is a point-in-time…

Hi @User_5NVEC , For these two modules, I would not treat Analytics Currency as simply a reporting/display option. There are a few implementation considerations to validate before enabling it. 1. Conversion date For Inventory Item Location Quantity and Inventory Snapshot, Oracle's NSAW documentation identifies the Work…

Hi @User_5NVEC , The field averagecostmli is a NetSuite transactional field available through the inventoryitemlocations and assemblyitemlocations tables (for example, via SuiteAnalytics Connect or SuiteQL). However, not every NetSuite field is replicated into NetSuite Analytics Warehouse (NSAW). NSAW loads data into a…

Hi @User_WCXYT , Thank you for the additional details. Based on your findings, this appears to be expected behavior related to NSAW's row-level data security, rather than an issue with workbook permissions. The fact that: The VP of Operations can only see data for employees who report to them in NetSuite. The Viewer who…

Hi @User_WCXYT , Based on your description, it sounds like the user has access to the workbook itself but is encountering Query Error messages when opening specific canvases (such as Expense and Cash Flow) while other canvases (such as Revenue) work correctly. Since you've already confirmed that the user has: A security…

Hello again @User_5NVEC , Yes, keeping individual copies of the Job table for each subject area is a viable workaround, and it is the approach that best aligns with the supported customization capabilities of NSAW. The general implementation would be: Create a custom dataset for each subject area Use a Data Flow to join…

@User_5NVEC , Thank you for the clarification. Based on your use case, the answer is unfortunately still no—there is no supported way to create a persistent semantic join between the Oracle-delivered table OAX_USER.DW_NS_JOB_D and all of the Oracle-delivered fact tables. Although OAX_USER.DW_NS_JOB_D is visible in the…

Hi @User_5NVEC , Data Augmentation is intended to ingest external or custom data into NSAW—it is not designed to expose or "augment" Oracle-delivered warehouse tables that already exist in the underlying database. If you're referring to an existing NSAW table that you can see in the underlying database (for example, a…

Hi @User_5NVEC , Unfortunately, there is no supported or documented method in NetSuite Analytics Warehouse (NSAW) to create new persistent logical relationships (for example, a custom fact-to-dimension join) between two existing Oracle-delivered NSAW tables that become part of the out-of-the-box semantic model and are…

Hi @Siddharth Dang , For the standard variant of NetSuite Analytics Warehouse (NSAW), the available options for ingesting external data are limited. In particular, NSAW does not support connecting directly to arbitrary JDBC or ODBC data sources for data ingestion. If the source system (e.g., Home Depot) only provides a…

Hi @Siddharth Dang , What you're describing is not expected behavior. Once Enable Blending is disabled for a conditional formatting rule, it should remain disabled unless the rule or visualization is modified in a way that causes Oracle Analytics to regenerate the rule. A few things could cause it to become enabled again:…

Hi @Divya Unnikrishnan , Since you're using a Workbook with the Credit Memo and Customer Invoice dataset, and the report is filtered only by Fiscal Year = FY 2026, the behavior you're seeing is expected. Your current YTD formula: TODATE( IFNULL( Invoice. Line Amount in Base Currency - Credit Memo. Line Amount in Base…

Hi @Julianne, The error screenshot confirms that DF B is still holding references to obsolete metadata from DF A, even though the underlying dataset (DS_InvTxn) has already been refreshed. The key error is: [nQSError: 22172] Curated (RPD) conforms expression invalid for xsa column:(Investment Name Name) This indicates that…

Hi @User_OGQAD, Thank you for the screenshots. This helps clarify the issue. What you're encountering is a limitation of the Workbook/Data Visualization interface. The context menu shown in your screenshot is the visualization menu and does not provide measure-based filtering options such as Greater Than 0. Since you've…

Hi @Divya Unnikrishnan. The behavior you're seeing is expected based on how the functions are currently being used. Your current formula: AGO( TODATE( IFNULL( Invoice Transaction Currency Amount - Credit Memo Transaction Currency Amount, 0 ), Fiscal Year ), Fiscal Year, 1 ) first calculates the Year-to-Date total at the…

Hi @User_OGQAD , Thank you for the screenshot. Based on what you're showing, you're using the numeric range filter for the measure, which explains why you're not seeing options such as "Is Not Null". A few observations: The filter is being treated as a continuous measure and only exposes a range slider. The distribution…

Hi @User_OGQAD, Based on the behavior described, the assembly component lines are likely being included in the Sales Order dataset with a null or zero value for Line Amount in Base Currency. Since some of these components can also be sold independently, filtering on Item Type or Component status would not be appropriate…

Hello again @User_ERR9Q , Unfortunately, at this time there is no native NSAW feature that automatically ingests custom data from NetSuite Analytics (Workbook, Analytics Data Source, or SuiteAnalytics Connect schema) into NSAW in the same manner that standard NSAW functional area pipelines ingest NetSuite transactional…

Hi @User_ERR9Q , Yes, manually extracting and loading the data each day would not be the recommended long-term approach. For a daily incremental refresh, the typical approach is to automate the extraction and loading process using an external orchestration or ETL tool. NSAW does not currently provide a native mechanism to…

Hi @User_ERR9Q , Based on the standard NSAW data model, package-level shipment details are generally not included in the out-of-the-box functional area loads. NSAW primarily focuses on transactional, financial, operational, and dimensional data sourced through the standard pipelines. As a result, package-specific…

Hi @User_ERR9Q , NSAW Full Data Reload – Simple Guide (Standard, Augmentation, CAM, Custom Tables) NetSuite Analytics Warehouse (NSAW) is designed for incremental refresh, so a true full reload requires a coordinated approach across multiple components. Core Principle There is no single-button full reload. You must…

Hi @User_F2RD3, Manuel here from NSAW support team. This behavior is by design, not an environment issue. While the NAW Licensed Author role allows users to create and share decks/cards, it does not include catalog administration privileges. Specifically, it does not grant the ability to: Create folders under /Shared…

Hi @FazeprooF Let's continue this discussion via direct message for a quicker response. Please check your inbox.

Hi @FazeprooF Thank you for providing this information. Please allow us some time to review it with our engineers.

Hi @FazeprooF Could you please provide a set of screenshots that demonstrate the issue? Additionally, could you check if the same behavior occurs when using out-of-the-box subject areas? It would also be helpful if you could include screenshots that show the expected numbers. Please attach these details in an MS Word…