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
, Custom record to track customer satisfaction survey. What data will show in the
Customer Center - ANS-none - Custom records cannot be linked to the Customer
Center
Display "unassigned" in results if blank - ANS-IS NULL
Display date by day of the week - ANS-TO_CHAR
for a KPI scorecard, a formula field is required under Results tab - ANS-FALSE
for a KPI scorecard, only custom Key Performance Indicators may be used - ANS-
FALSE
for a KPI scorecard, only standard Key Performance Indicators may be used - ANS-
FALSE
For which use case should you use a Custom Summary Report rather than a Search? -
ANS-Provide real time data without NetSuite access via WebQuery
For which use case would a custom search be sued rather than a custom report? -
ANS-Use SQL statemnt to refine the criteria and results
In the Financial Report Builder, when setting up a Header Row, which Display setting
will combine all items within the Header/Summary rows into one number, which can be
drilled into as needed? - ANS-Summary
Overrides role permission access to underlying records - ANS-Run unrestricted
Respectes role permission to underlying records - ANS-Audience
Returns value based on different conditions - ANS-CASE
Search function: Age in months - ANS-Field Type: Date
Search function: Number as Time - ANS-Field Type:Numeric
Search function: Quarter - ANS-Field Type: Date
Search function: Rank - ANS-Field Type: Numeric
Search Parameter: Count - ANS-Number
Search Parameter: Duration - ANS-Minimum
Search Parameter: Support Case - ANS-Search Type
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
, Custom record to track customer satisfaction survey. What data will show in the
Customer Center - ANS-none - Custom records cannot be linked to the Customer
Center
Display "unassigned" in results if blank - ANS-IS NULL
Display date by day of the week - ANS-TO_CHAR
for a KPI scorecard, a formula field is required under Results tab - ANS-FALSE
for a KPI scorecard, only custom Key Performance Indicators may be used - ANS-
FALSE
for a KPI scorecard, only standard Key Performance Indicators may be used - ANS-
FALSE
For which use case should you use a Custom Summary Report rather than a Search? -
ANS-Provide real time data without NetSuite access via WebQuery
For which use case would a custom search be sued rather than a custom report? -
ANS-Use SQL statemnt to refine the criteria and results
In the Financial Report Builder, when setting up a Header Row, which Display setting
will combine all items within the Header/Summary rows into one number, which can be
drilled into as needed? - ANS-Summary
Overrides role permission access to underlying records - ANS-Run unrestricted
Respectes role permission to underlying records - ANS-Audience
Returns value based on different conditions - ANS-CASE
Search function: Age in months - ANS-Field Type: Date
Search function: Number as Time - ANS-Field Type:Numeric
Search function: Quarter - ANS-Field Type: Date
Search function: Rank - ANS-Field Type: Numeric
Search Parameter: Count - ANS-Number
Search Parameter: Duration - ANS-Minimum
Search Parameter: Support Case - ANS-Search Type
