Hi @SWSearcy, Thank you for the follow up. Your idea is a good one too. Browsers have developer tools that can generate .har files that will include the logical SQL. You may want to check with your Admin regarding the OAC Console. There is a NSAW Console and a OAC Console. The OAC Console would be accessed here: The the…

Hi @SWSearcy, In NSAW, Goto your OAC Console > Sessions and Queries and set your log level to trace. Then goto your Workbook and run it. (You may need to refresh it using the 'Refresh Data' button). Then return to Sessions and Queries and you will see the log including all the calculations. Hope that helps. Regards, John

Hi @Gavin Davidson, Sorry about that. Not sure what happened to the link. Try: Regards, John

Hello @Gavin Davidson, In NSAW itself, there is some KPI functionality that is documented here: NSAW comes with OAC where there is more alert and conditional functionality as documented here: and here: Regards, John

Hi @James Woods, Thank you for the question and its definitely not a dumb question. Yes, you can do this in NSAW > OAC. A lot of different options exist on how and where to create calculations based on two different columns but the starting point is here: Regards, John

Hi @James Woods Administrators can switch off workbook personalization for the entire organization using the system setting Enable Personalization in Workbooks. See the documentation here: Regards, John

Hi @James Woods, There is a difference between exiting the Dashboard and logging off and remaining logged into the same session while doing other things. There are many types of filters, parameters, dashboard prompts, etc NSAW > OAC. For many filters you can supply a default value so everything a user logs in, the default…

Hi @User_PK2Q7 NSAW uses Oracle Analytics Cloud as its reporting tool. It includes many OOTB Dashboards that do default to an 'original state' when they are opened and these can all be customized. The OAC documentation is here: Regards, John

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…