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

Hello, For a SFTP connection, you do need to log a SR and request the port be opened.

NSAW does have data validation functionality as documented here: https://docs.oracle.com/en/cloud/saas/netsuite-analytics-warehouse/nsawi/subject-areas-chapter.html#GUID-EA56CB91-76FC-408F-8DC8-22C594BBAC04 Is Fixed Asset Listing consistent with Fixed Asset Subledger result? This would depend on the timing of the last load…