NetSuite SuiteAnalytics Exam with
Complete Solutions
A customer needs to report outgoing order information from several warehouse
locations - ANS-Use a Saved Search using Summary functionality on the Results
columns
A saved search has highlighting defined for the results. In which context is that
highlighting visible? - ANS-Only where search results are visible (NOT dashboard
portlet only, only for creator, list view)
A saved search is needed to find all customers in CA who are assigned to Sales Rep A,
and also all customers in OR who are assigned to Sales Rep B - ANS-(State=California
AND Sales Rep = A) OR (State=Oregon AND Sales Rep = B)
A search is required which will display: Customer Name, Sales Rep, Support Case
Number, Support Rep Subsisidary. What record type? - ANS-Support Case
Alternate Date Range options - ANS-Date
An activity search returns a Company field whos field ID is {company}. When an activity
is assigned to a Project, {company} is a combination of Customer and Project that is
always returned in the same format: CustomerABC:ProjectABC - ANS-
An Invoiced Saved Search needs to display the Items and Original quantities from the
SO. Which join relationship - ANS-Created from fields
An Opp record has a Sales Readiness field whose field ID is {salesreadiness}. It has 3
values: Cold, Warm, Hot. You want to convert these - ANS-
DECODE(SUBSTR({salesreadiness},1,3),'Hot','Ready',
DECODE(SUBSTR({salesreadiness},1,4),'Warm','Maybe',DECODE({SUBSTR({salesre
adiness},1,4),'Cold','Not Ready'))) OR
DECODE(instr({SALESREADINESS},'Hot'),1,'Ready',DECODE(INSTR({salesreadiness}
,'Warm'),1,'Maybe',DECODE(INSTR({salesreadiness},'Cold'),1,'Not Ready')))
Anyone with access to the excel sheet can pull the data - ANS-Web Query
As saved search is needed to determine which Items are being brought back by
customers most often in a month. Which record type? - ANS-Return Authorization
Calculate median value - ANS-Average
Compares 2 values, then returns specified paramenter if they match - ANS-DECODE
