NetSuite SuiteAnalytics Exam ACTUAL
Exam Questions and CORRECT Answers
CASE - CORRECT ANSWER - Expression that contains conditions created using WHEN -
THEN clauses to return certain values
CASE WHEN
THEN
ELSE
END
DECODE - CORRECT ANSWER -
TO_CHAR - CORRECT ANSWER - Allows date and numeric information to be converted
into text strings
TO_CHAR(date or number [, 'format'])
INSTR - CORRECT ANSWER - Returns the numeric position of the substring
INSTR('char','substring')
SUBSTR - CORRECT ANSWER - Allows you to extract a string of characters from a text
object
SUBSTR(char, position [, substring_length])
NVL - CORRECT ANSWER - SQL function available for use in the saved search Criteria and
Results tabs to return a second value if the first value is blank
NULLIF - CORRECT ANSWER - Returns a NULL if the input has the value specified in the
second parameter
,Formulas in Criteria (Saved Search) - CORRECT ANSWER - Formulas can be used in
criteria to filter rows based on the results of a function or calculation
Available options:
Formula (Date)
Formula (Numeric)
Formula (Text)
Reports - CORRECT ANSWER - - Point in time analysis
- Add hierarchical groupings, formula fields, and additional fields for customized analysis
Formulas Types in Saved Searches - CORRECT ANSWER - 1. Formula (Currency)
2. Formula (Date)
3. Formula (Date/Time)
4. Formula (Numeric)
5. Formula (Percent)
6. Formula (Text)
Use Standard Reports When: - CORRECT ANSWER - Summarize reports into groups, totals,
and subtotals
Limitations of Standard Reports: - CORRECT ANSWER - - Cannot update data directly in
the report (must update the underlying record instead of the report)
Summary-Level Report - CORRECT ANSWER - Allows drill down into a detail-level report;
can toggle between summary and detail level
Detail-Level Report - CORRECT ANSWER - Provides more granular detail than the
summary-level report; can toggle between summary and detail level
, Best Practices: Reporting - CORRECT ANSWER - - Review NetSuite standard reports prior
to creating custom reports
- Run similar reports to compare the outputs
- Conduct a gap analysis to identify what needs to be added to a standard report
Name vs. Name (Grouped) - CORRECT ANSWER - Name - list without grouping
Name (Grouped - list with hierarchal groupings
Drill Down Button - CORRECT ANSWER - Reveal the next level of the report
What does parent-child relationships enable in reporting? - CORRECT ANSWER - Totaling
and subtotaling in reports
Grouping - CORRECT ANSWER - Aggregate values within a subgroup of data and returns a
single value
5 Group Functions
Group with Previous Column - CORRECT ANSWER - Allows data to be subtotaled by the
previous column
Report Footer Filters - CORRECT ANSWER - Vary depending on the report.
- Date
- From
- To
- Subsidiary Context
- Column
Report Export Options - CORRECT ANSWER - 1. Excel
2. PDF
Exam Questions and CORRECT Answers
CASE - CORRECT ANSWER - Expression that contains conditions created using WHEN -
THEN clauses to return certain values
CASE WHEN
THEN
ELSE
END
DECODE - CORRECT ANSWER -
TO_CHAR - CORRECT ANSWER - Allows date and numeric information to be converted
into text strings
TO_CHAR(date or number [, 'format'])
INSTR - CORRECT ANSWER - Returns the numeric position of the substring
INSTR('char','substring')
SUBSTR - CORRECT ANSWER - Allows you to extract a string of characters from a text
object
SUBSTR(char, position [, substring_length])
NVL - CORRECT ANSWER - SQL function available for use in the saved search Criteria and
Results tabs to return a second value if the first value is blank
NULLIF - CORRECT ANSWER - Returns a NULL if the input has the value specified in the
second parameter
,Formulas in Criteria (Saved Search) - CORRECT ANSWER - Formulas can be used in
criteria to filter rows based on the results of a function or calculation
Available options:
Formula (Date)
Formula (Numeric)
Formula (Text)
Reports - CORRECT ANSWER - - Point in time analysis
- Add hierarchical groupings, formula fields, and additional fields for customized analysis
Formulas Types in Saved Searches - CORRECT ANSWER - 1. Formula (Currency)
2. Formula (Date)
3. Formula (Date/Time)
4. Formula (Numeric)
5. Formula (Percent)
6. Formula (Text)
Use Standard Reports When: - CORRECT ANSWER - Summarize reports into groups, totals,
and subtotals
Limitations of Standard Reports: - CORRECT ANSWER - - Cannot update data directly in
the report (must update the underlying record instead of the report)
Summary-Level Report - CORRECT ANSWER - Allows drill down into a detail-level report;
can toggle between summary and detail level
Detail-Level Report - CORRECT ANSWER - Provides more granular detail than the
summary-level report; can toggle between summary and detail level
, Best Practices: Reporting - CORRECT ANSWER - - Review NetSuite standard reports prior
to creating custom reports
- Run similar reports to compare the outputs
- Conduct a gap analysis to identify what needs to be added to a standard report
Name vs. Name (Grouped) - CORRECT ANSWER - Name - list without grouping
Name (Grouped - list with hierarchal groupings
Drill Down Button - CORRECT ANSWER - Reveal the next level of the report
What does parent-child relationships enable in reporting? - CORRECT ANSWER - Totaling
and subtotaling in reports
Grouping - CORRECT ANSWER - Aggregate values within a subgroup of data and returns a
single value
5 Group Functions
Group with Previous Column - CORRECT ANSWER - Allows data to be subtotaled by the
previous column
Report Footer Filters - CORRECT ANSWER - Vary depending on the report.
- Date
- From
- To
- Subsidiary Context
- Column
Report Export Options - CORRECT ANSWER - 1. Excel
2. PDF
