Manuelito Borja-Oracle Red Ribbon

@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…

Hello NetSuite Community! I'm Manuelito Borja located in the Philippines. I am a Technical Support Engineer at Oracle Netsuite assigned on Netsuite Analytics Warehouse(NSAW). Fun fact: I love watching and reading everything about MARVEL movies/comics Thank you!