Advanced Reporting and Trended Workers HCM Flashcards
Where do you include terminations of the end of the period date?
Task: Maintain Trended Worker.
Counting Terminations events for those workers one day after the Effective Date.
What access do you need to perform the “purge trended worker” or “create trended worker” tasks?
Custom Report Administration Security Domain
What does Trended Worker Report and Matrix Report have in common?
Allows for aggregation, grouping, interactive drilling.
You can use matrix report type with trended worker source by defining lookup date rollup as a grouping
What abilities do you have when using outlining structure and configuring a repeating column grouping.
Allows you to expand the outline for repeated levels in hierarchy. Column outlining is only for primary hierarchy.
What is a requirement for the field when creating repeating column group?
The field must exist in the subreport.
When combining two columns with the two data sources, the field must exist in both subreprots.
Y/N: Can you delete subreport prompts out of a composite report?
No.
BUT:
1. you can set prompts to “Prompt User for Value at Runtime” in column configuration screen
2. then.. set the prompt in the Report Setting screen to ‘no default value’ and ‘do not prompt at runtime’
How can you use a prompt set for a field at the column level?
to configure columns in the prompt sets, first identify which prompt set to use in your Reporting Setting window.
Y/N: Do expansion hierarchies export to Excel?
No. Unless you enable the advanced option to export to Excel. –> the report runs in the background to send the expansion to Excel.
Expansions can only expand up to 8 levels in the Excel outlining.
What is the task to add a extend an indexed data source?
Maintain Custom Data Source Task
How do you determine is a field is suitable for indexing?
Run the “Field Suitability for Business Objects” Task
What task do you run to determine security configuration for any object?
“View Security for Securable items” Task
What user security access is needed to be able to share a report with the user?
Must have access to the data source and data source filter
What grouping dimension must you specify when building a matrix report?
Minimum of one row grouping and summarization must be specified. Column Groupings are optional.
A runtime error appears when attempting to run a shared matrix report. What “view” security permissions is the user missing?
Row Grouping
Column Grouping
Summarization field
What Function do you use to report on change detection?
Lookup Value as of Date Function