C_BOWI_40 · Question #53
Which statement describes a benefit of using the NoFilter() function?
The correct answer is C. It overrides report ranking. The NoFilter() function in SAP BusinessObjects Web Intelligence removes report-level filters and ranking when calculating aggregate values.
Question
Which statement describes a benefit of using the NoFilter() function?
Options
- AIt overrides query filters.
- BIt overrides query ranking.
- CIt overrides report ranking.
- DIt overrides universe security
How the community answered
(34 responses)- A6% (2)
- B3% (1)
- C85% (29)
- D6% (2)
Why each option
The NoFilter() function in SAP BusinessObjects Web Intelligence removes report-level filters and ranking when calculating aggregate values.
Query filters are enforced at the SQL/data-retrieval stage before data reaches the report layer, and NoFilter() cannot modify conditions applied there.
There is no 'query ranking' concept in Web Intelligence; ranking is exclusively a report-level feature, making this option technically inapplicable.
NoFilter() instructs the report engine to compute a measure as if no report-level ranking or filter conditions are applied, so the aggregation reflects the full dataset rather than the filtered subset. This is specifically useful when a ranking filter would otherwise exclude rows from a calculation. It operates only at the report layer and has no effect on query-level or security-layer constraints.
Universe security restrictions are enforced at the semantic or data-source layer and are completely outside the scope of the NoFilter() function.
Concept tested: NoFilter() function overriding report-level ranking
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/9c1a9dee-8b0c-4e3f-aab3-e4cc6e877e74/46d79a6f6e041014910ded01120ca65c.html
Topics
Community Discussion
No community discussion yet for this question.