NS Suite Analytics Study Guide questions and answers graded A+ 2024/2025

NS Suite Analytics Study Guide

False - ANST/F: You can update data directly from the report

Reports Overview Page - ANSpage to see all the reports available in your role

Report Results - ANSwhere to find completed reports you ran

Filters - ANShow to restrict reports

Web query - ANSenable saving the report as an excel web query, access to report without
having access to NS

Audience - ANSwho has permission to run the report

Standard Report - ANSWhat should you use as your base when building a custom report?

30 - ANShow many data columns can you have in a report?

2 - ANShow many reports can be run at once

Summary, detailed, matrix - ANS3 types of reports

3 - ANSmax number of kpi meters allowed on a dashboard

75 - ANSnumber of available KPIs

public - ANSavailable to anyone who has permission

Case - ANS(SQL) like an "if" statement

Decode - ANS(SQL) compares expr to each search value, if expr = search, the corresponding
result is returned

To_char - ANS(SQL) show date in a certain format

instr - ANS(SQL) searches string for substring

substr - ANS(SQL) returns a portion of char

nvl - ANS(SQL) lets you replace null with the 2nd parameter