Composite (New) Flashcards
Creating a composite report:
After selecting the composite report type, what do you do?
enable business objects to use for filtering and grouping data throughout your report
–> drives the available values for the control field
T/F: Business object must match the dimensions, such as rows/ columms, used in the subreport and compiled in composite report
True
What is required when using hierarchical filtering in a lookup data row, column or cell?
Populate the hierarchical filtering in the Hierarchy Structure business object filter
If a field does not have a hierachical structure, it’s not available.
Row Types for Composite Report
Lookup Data
Combined Data
Dynamic Data
Calculation
Empty
Row Type: Combine Data is commonly used for what?
Calculation to create a total row and sorting
Row Type: Dynamic Data - uses the results of which subreport?
Advanced subreport
Can also apply an aggregate calculation
Row Type: Lookup Data
Allows you to specify what data to include in the row.
What is outlining used for in composite reports?
a configuration for composite report hiearchies that you can use in WD and when exporting to excel
How can you define hiearchies in composite reports?
By using an outline structure
What do outlines structures consist of?
It consists of one or more hiearchies and enable you to “nest” hierarchies our group by fields
What is a functionality of nesting?
Nestng allows you to drill down to lower hiearchies that may consist of ledger accounts or categories
What does an outline structure consist of?
a primary hierarchy definition and the expansion hierarchy grid
can identify each outline structure by a required title and optional desription.
Setting in subreport: “No default value”
What is behavior in subreport and composite report?
Subreport: No prompt appears when report is run
Composite Report: No prompt appears in the configuration
Setting in subreport: “Do not prompt at runtime” checkbox
What is behavior in subreport and composite report?
Subreport: None
Composite Report: Makes it non-configurable
Setting in subreport: “No default value” and “Prompt at runtime”
What is behavior in subreport and composite report?
Subreport: Prompt appears with no value when report is run
**Composite Report: ** Prompt appears in the report configuration and you must save it before you can set column configurations
Setting in subreport: “Specify default value at runtime” and “Do not prompt at runtime”
What is behavior in subreport and composite report?
**Subreport: **Prompt runs with specified value at runtime. No prompt appears.
**Composite Report: **Prompt does not appear in the report configuration. Prompts runs at subreport level
Setting in subreport: “Specify default value at runtime” and “Prompt at runtime”
What is behavior in subreport and composite report?
Subreport: Report runs with specified value and prompts user at runtime.
**Composite Report: **Prompt appears in configuration screen. If you do not make a change, no prompt appears when the composite report runs (uses the default value specified in the configuration)
What happens when you modify a prompt in the composite report to “Prompt user for value at runtime”
You cannot set a default value. The prompt configuration settings for a composite report are in the report settings.
If the prompt does not display in report settings, what may be the cause?
Select the “Populate Undefined Prompt Defaults” checkbox
Since you cannot delete subreport prompts at the composite report level, what can you do instead?
- In config setting - set to “Prompt user at runtime
- In report setting - set to “no default value” and “do not prompt at runtime” <– can use same subreport in multiple composite reports
