Advanced Composite Reporting Flashcards
What are Dynamic Data Rows?
Dynamic Data Rows use Advanced Reports as sub-reports to populate the control field
They sort data based on business object instead of referring to output columns.
How does the report determine its content?
The report dynamically determines content when you run the composite report
Any sorting defined in the subreport carries over to the rows in the composite report.
What are some use cases for Dynamic Data Rows?
Use Cases include:
* Create summary without drill down
* Display specific levels of hierarchy
* Create custom totals, hiding control field details
* Filter data to specify what is shown
Examples include displaying only summed rows for an entire hierarchy or particular groupings of cost centers.
What must match in an Advanced subreport?
Advanced sub report business object must match control field in composite report.
What types of cells are defined in the report?
Types of cells include:
* Calculation
* Data
* Label
* Conditional override
Each type serves a different purpose in data presentation.
What are Data Cells and their functionalities?
Data Cells enable you to retrieve data from subreports and can be configured at intersections of different types of columns/rows
They can apply filters for subreports and map subreport prompts.
What operations can Calculation Cells perform?
Calculation Cells can perform:
* Difference
* Divide
* Multiply
* % increase
* % decrease
They can also be used with outlining.
Where can Label Cells be placed?
Label Cells can be placed at the intersection of a control column and an empty row
They can contain static or dynamic text.
What is the purpose of Conditional Value and Format Cells?
Conditional Value and Format Cells display 0 or actual value based on a true/false condition and can override style and formatting of an undefined cell.
What is the default alignment of column headings when outlining?
By default, when outlining, the column headings are not centered.
What options are available for Column Headers?
Options for Column Headers include:
* Generate Column Headers
* Generate and edit Column Heading Rows
* Generate and edit Column Heading Cells.
What is the function of the Expansion Hierarchy in a composite report?
The Expansion Hierarchy allows setting up hierarchies associated with the business object and configuring subsequent hierarchies to expand on primary hierarchies.
Fill in the blank: The report determines its content when you run the _______.
[composite report]
