Advanced Reporting and Analytics Flashcards
Matrix reports are suitable for (4)
Aggregating and Summarizing numeric data
Modifying rows and columns at runtime for a different view
Drilling into summaries and details
Taking actions on insights
What is the main construct of a matrix report? (3)
Grouping: grouping instances of the PBO to define the initial summary. defining rows/columns
Summarizing: define aggregations for each group
Drilling: drilling into each group for further analysis
____ and ____ groupings are the starting summary matrix for the report.
Rows and columns
Are column groupings optional?
Yes
What is the default summarization type for a Matrix report?
Count
What are the 8 summarization types for a matrix report?
- Count
- Count distinct
- Sum
- Average
- Percentile
- Minimum
- Maximum
- Calculation (create your own arithmetic calc)
What are the maximum output for rows and columns? What happens if the data is over the threshold?
Rows: 250
columns: 20
Data over the max goes to a column called other
What are the 3 types of percent of totals for a matrix report in the summarization fields? Where do you select these types?
The 3 types are: Percent of row total (only available if column total is used), Percent of column total and overall total. This is done in the option column
What must be configured in order for a percent row total to be defined?
Sort the data
Which feature allows you to control the orders and values of grouping in the report output?
Field value group
Can analytic indicators be created to appear for a field on a Business Object?
Yes.
Can an analytic indicator be report specific?
Yes
What are the types of analytic indicators available?(6)
- flag
- trend arrow
- progress bar
- check mark/x
- status: green, yellow, red or 5 stars
- nBox
What are the steps to create a system wide analytic indicator?
run created analytic indicator task and follow the steps.
or use edit analytic indicator and adjust or copy.
How to create a report specific analytic indicator?
from the options column create>create analytic indicator.
Where can you configure Top N Values for charts in a report?
Chart options>Top N values
What are target lines for charts?
The highlight the deviations from the target.