C_BOWI_40 · Question #110
In which two situations should you use sub-queries?
The correct answer is B. When the query filter involves values that are not known C. When the query filter for the report involves a value that will change over time. Sub-queries are appropriate when filter values are unknown at design time or need to evaluate dynamically as data changes over time.
Question
In which two situations should you use sub-queries?
Options
- AWhen the query filter involves values that are known
- BWhen the query filter involves values that are not known
- CWhen the query filter for the report involves a value that will change over time
- DWhen the query filter for the report involves a value that will never change over time
How the community answered
(59 responses)- A7% (4)
- B80% (47)
- D14% (8)
Why each option
Sub-queries are appropriate when filter values are unknown at design time or need to evaluate dynamically as data changes over time.
When filter values are already known, a standard static query filter with a constant value is sufficient and more efficient than introducing a sub-query.
When the filter value is not known in advance, a sub-query derives its values dynamically by running a nested query against the data source, eliminating the need to hard-code a specific value.
When the filter value will change over time, a sub-query re-evaluates on each refresh, automatically reflecting the latest values rather than remaining fixed to a value that was valid only at design time.
When a filter value will never change, a fixed constant condition in a standard query filter is the appropriate and simpler choice, making a sub-query unnecessary.
Concept tested: Sub-query usage for unknown and dynamic filter values
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM
Topics
Community Discussion
No community discussion yet for this question.