Thanx Sydney I will go check out this article and let you know how it worked for me

What I meant with 'Today' is create a calculation called Today for time being 8 hours ahead of UTC . Customer wants current date displayed on the dashboard - for the first 8 hours of a day it is incorrect - so use formula below CASE WHEN hour(NOW()) between 16 and 24 THEN CURRENT_DATE + 1 Else CURRENT_DATE END

Feedback on this I noticed in documentation that one should be able to set defaults under System Settings Alas, one gets an 'Insufficient Permission' error message when trying to access this I logged a case with NetSuite, thinking this is something missing in the set-up Answer was that it is a current limitation and that…

Thanx Good to know - this would be great if one could simply hide missing or zero values like in SmartView. By the way, the link to SuiteIdeas did not work

Thanx Sanjeev - I will go try this out and let you know

Thanx Michelle The requirement is to show the latest exchange rate on a Workbook In NetSuite on can get this from Lists→Accounting→Currency Exchange Rate One can then get the latest exchange rate as downloaded from Xignite If one clicks on History, one can see each day's download I will continue down this track and see if…

This was helpful- thanx

Hello Pamela How does one set-up the 'Open NetSuite Sales order' link? Please let me know of point me to documentation on how to do this

Best solution I could find thus far was to add a free exchange rate site to the safe domains Add a text box pointing to this It is not ideal as one would have liked to see the actual amount, hence me asking if the exchange rate is available somewhere in the NSAW subject areas

Hello I also logged a ticket with NetSuite and received this answer Please see the following steps to resolve the concern: 1. Build a dataset that contains all the departments 2. Join this dataset with all other datasets in the DV workbook using department column 3. Create a filter condition on the department column from…

Thanx @Angela Bayliss You have answered another question I had - this will be really helpful My question related to Prompts on a dashboard to work on several Visualisations I am finding the blending between DV (new technology) and OBIEE (old technology) to be really challenging - documentation can be for either and some…

Thanx Mark That sounds very much what I am after. How does one enable the 'Account Analysis' Subject Area?. I have checked and it is not available in the current set-up. I have in the meantime started pulling together several subject areas in a Union query as a data flow after create custom data sets for each subject area.…

Thanx Grace

Hello Pamela Is there any document to assist in how to get Gross profit reporting from NSAW? Which common NetSuite Subject Areas to combine, how to structure the dataset and dataflows and how to get basic calculations e.g. Gross Profit and Gross profit %? The 'out of the box' set-up gives one the ability analyze every…

This is the exchange rate type - just add a filter for one of them

Hello Is there anyway one can edit the Portlet? e.g. add a column or replace a column with another?

Thanx for the answer Kristoffer Yes, that is not really going to help - users still need to execute the one rule so 'view only' access will prevent that This will need some more brainstorming - or telling the client a user can kick of 'any job' or 'no job'- there is no 'some jobs' option