NetSuite SuiteAnalytics Exam with complete solutions
Calculate median value - Answer- Average
Summary Type: Add up the numerical values - Answer- Sum
Summary Type: Show only the rows meeting threshhold - Answer- Minimum
Summary Type: Quantify the unique values of the field selected - Answer- Count
Search Parameter: Support Case - Answer- Search Type
Search Parameter: Count - Answer- Number
Search Parameter: Support Rep - Answer- Group
Search Parameter: Duration - Answer- Minimum
Search function: Age in months - Answer- Field Type: Date
Search function: Quarter - Answer- Field Type: Date
Search function: Rank - Answer- Field Type: Numeric
Search function: Number as Time - Answer- Field Type:Numeric
Which two analytic tools allow for sending schedule email results to a pre-defined list of recipients? - Answer- Saved Search, Custom Reports
Anyone with access to the excel sheet can pull the data - Answer- Web Query
Respectes role permission to underlying records - Answer- Audience
Overrides role permission access to underlying records - Answer- Run unrestricted
What is a difference between the Audience tab and the Roles tab on a Saved Search - Answer- The Audience tab grants access to the Saved Search
Using the Audience tab of a custom report, the Sales Rep role and the Renewals Department have bene selected. Which two categories of users will be able to access the saved search? - Answer- Anyone with the Administrator role and Sales Reps in the Renewal Department (NOT Everyone in the Renewals Departemtn, NOT Everyone with
the Sales Rep role)
You want to add the Sales Rep's phone number field to the Sales Order search results. Sales rep phone number is on the Employee record, it is not on the Sales Order - Answer- Sales Rep phone number must be selected on the Results tab under Sales Rep Fields...
What 2 requirements to publish dashboard - Answer- You must use the same Cetner as
the Role the dashboard will be published to. You must have Publish Dashboard permission (NOT you must have Admin, NOT you must have Publish Centers permission)
Which 2 statements are true about updating a previously published dashboard? - Answer- Updates can only be rolled out to dashboards using the same center, Updates can override existing users settings
Which use case is the bset match for displaying in a KPI meter? - Answer- Open Support Cases (NOT Sales per Rep, Profitablity across Items, Quarterly Revenue Trend)
Which statement is true about creating a KPI Scorecard? - Answer- A date/period field is required under Available Filters of the KPI
What do you start editing to customize a Financial Report? - Answer- Layout
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? - Answer- Summary
What will display the section data in the order you prefer in the Financial Report Builder Layout - Account Sections? - Answer- Order By
Which 2 scenarios require the use of the Alternate Date/Period Range Type? - Answer- You want your date columns to automatically change based on Today's Date; You want to specify a particular period for each column when viewing a financial statement.
For which use case would a custom search be sued rather than a custom report? - Answer- Use SQL statemnt to refine the criteria and results
For which use case should you use a Custom Summary Report rather than a Search? - Answer- Provide real time data without NetSuite access via WebQuery
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 - Answer- (State=California AND Sales Rep = A) OR (State=Oregon AND Sales Rep = B)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller UPPERFRONT. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.