JohnW-Oracle Blue Ribbon

Hi @Vandana Srivastava, We will need more information to answer this. Is this a NSAW report you are creating in OAC? If not, you may want to post your question to the main Netsuite community site here: Regards, John

Hi @Vismay Barot If you cannot find the PO number via NSAW's OAC, then that means the PO Number was deleted appropriately via the Netsuite (Source) application and all is good. Regards, John

Hi @Vismay Barotm Knowing the PO Number should make Data Validation easier. In NSAW > OAC, using a user with the same privileges you have in Netsuite, create a simple workbook from Subject Area: Netsuite - Purchase Order > Purchase Order Transaction Number. You can filter on the number. If it exists in NSAW and does not…

Hi @Vismay Barot NSAW Administrators can get access to the subject area named: "Common - Warehouse Refresh Statistics". In OAC, that Subject Area can be used to develop workbooks that show differences and explain the results of the Pipeline. Specifics would depend on the records you want to track. For example, some…

Hi @Priya Chary, Please see the What's New section of your NSAW documentation here: Usage tracking has been turned on in the Oracle Analytics Cloud instance associated with your Oracle NetSuite Analytics Warehouse instance. Usage tracking enables administrators to track user-level queries on the content. Service…

Hi @SheikMohamedTharicq, As Christine mentioned, you should take advantage of the Out of the box NSAW content as much as possible because a lot of work has been put into that. When you open a NSAW Workbook in OAC, you will notice some already have Calculated columns included. If they do not exactly meet your needs, you can…

Hi @Priya Chary Export limits for OAC are explained here In short, formatted formats will not be able to export as many rows as comma-delimited or other unformatted formats. Your OAC Workbooks should be designed with Prompts and filters so no single report returns millions of rows. Regards, John

Hi @SheikMohamedTharicq, Are you trying to create a calculated column in OAC with this statement? In NSAW> OAC, we do have a blog that provides several best practice examples of case statements . Regards, John

Hi @Sydney Agus-Oracle, What does "How to Invalid Warehouse Credentials" mean? A reset of the Data Warehouse should be the last option to simply ensure the Warehouse is up to date. Note: Resetting the Data Warehouse should be a very rare occurrence, and it should not be done unless there is a specific reason why. Regards,…

Hi @Vismay Barot, Thank you for the follow up and for sharing this. Have a nice weekend. John

Hi @Vismay Barot , To add to what the last user said, most custom content you use in Netsuite can be pulled into NSAW via data augmentations, custom attribute mapper and/or semantic model extensions. The customization documentation starts here: If it is a derived attribute that you cannot pull into NSAW, then its likely…

Hi @Kaden B, Thank you for the question. We may need a little more detail to provide a specific answer like the logical SQL from the NSAW report. Here is a document on suppressing Nulls. Regards, John

Hi @User_569R9 , You can start new threads. Sales is not a Preview Feature. You would enable it in the NSAW Console under Data Configuration > Netsuite Warehouse. The load will then run based on your Pipeline Settings. (Make sure it is Enabled). Regards, John

Hi @user10090865 , You are in the right area. Double check your release level in the NSAW Console > Release Updates Make sure you have completed the prerequisites from the earlier docs. Prerequisites for Setting up Netsuite Account Analysis Ensure these prerequisites are met: Prior to configuring the Netsuite account…

Hi @user10090865 , You can enable the Account Analysis Subject Area following the steps here: Prerequisites for Setting up Netsuite Account Analysis. If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the…

Hi @user10090865 The link you are referencing is 'internal only' so the link here is a mistake. I'll follow up internally to get that corrected. Your salesperson would be the first source to goto for OAC Demos. OAC 'What's New' documentation can be found here: If you find this reply to your question useful, others might as…

Hi @Nilanjan Biswas-Oracle , Thank you for starting this new thread. When your NSAW User Management and NSAW Data Transfer Setup buttons are grayed out, this normally points to a User permissions issue and the User should have the Administrator and Data Warehouse Integrator Role. The NSAW documentation on manager users,…

Hi @Nilanjan Biswas-Oracle , Please start a new thread for each question so these threads can be easier for others to search. If your original question was answered, please click 'Yes' to 'Did this answer the question?' . By doing so, you’ll be able to help the community members who might have a similar concern find the…

Hi @Nilanjan Biswas-Oracle , The documentation with screenshots is here: (video) and here: and here: Hope that helps. Regards, John

Hello @User_569R9 , I am not 100% clear on the follow up question. Is it that you cannot edit your custom hierarchy? If yes, this can happen if the branch is out-of-sync. Once you re-sync the custom branches with the Main branch, you should be able to edit. See the admin doc here: Have a nice weekend. -John

Hi @User_569R9 , You cannot make a changes to the OOTB Subject Areas names as you can do to a RPD using the Administration tool. Even with our older products like OBIA, we recommend against changing the OOTB content. The OOTB content gets updated on a regular basis so this needs to remain the same. However, you could…

Hi @User_569R9 , As you mentioned, you should start in the Data Source (Netsuite) and create the necessary fields to include in your Hierarchy and after that, things should be easier to understand. In your screenshot, if you click on the 'Details' folder under Selected Data Elements, do Primary Key and Display Attributes…

Hi @User_569R9, I am happy to hear you are making progress. Please continue asking questions here in the NSAW community. NSAW development is rapid, so if something is missing today, check again tomorrow. If you would like an Enhancement Request logged, please log a ticket with Netsuite and we can do that. Many of the…

Hi @User_569R9, I think your approach of adding a custom field in NetSuite that stores the parent account name and use Workflow to update this field and then pull in this field using Data Augmentation is the best one. This will allow for much easier Data Validation between Netsuite and NSAW and if you leave the…

Hi @User_569R9, Thanks for the follow up. The screenshots are helpful but if any of that is PI and not just dummy data, you should delete it. If you find this reply or the earlier reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to…

Hi @jmack_admin By Warehouse Team, I assume you mean those working with NSAW. If a user uses both Netsuite and NSAW, the user privileges should be kept in sync. This helps with data validation and generally helps to avoid confusion. You do have the ability to create custom duty and data roles to secure subject areas,…

Hello @User_569R9 NSAW does have documentation that explains how to extend the Semantic Model and add Hierarchies. It looks like you are really close based on your screenshots. The documentation is here: The hierarchy in your screenshots is of a time dimension and we have some blogs that can offer additional assistance on…

Hello @User_569R9 As of now Write Back functionality is not available in NSAW. On your behalf, the Below Enhancement bug has been raised with Product Management to consider the same for future releases. Enh 36694769 - ER: ENABLE WRITE BACK FUNCTIONALITY IN NSAW Please confirm whether this answers your question. Regards,…

Hi @User_569R9, Thank you for the Doc Bug request. We do need to clarify that in our documentation so I have logged a documentation Bug. This is internally available only but for your reference, the Documentation Bug number is: 36690242 I also created a KM article for this question that should be published soon: (Doc ID…

It does not look like this is available OOTB in NSAW but you could customize your warehouse to pull in the missing field and build the relationship. See: https://docs.oracle.com/en/cloud/saas/netsuite-analytics-warehouse/nsawa/customize-oracle-netsuite-analytics-warehouse.html