C_BOWI_40 · Question #63
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue…
The correct answer is A. NoFilter(). NoFilter() removes all active filters - including ranking filters - from a measure's calculation, allowing an average to be computed across all customers regardless of any applied rank.
Question
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers. Which function should you use in the variable?
Options
- ANoFilter()
- BNoRank()
- CAverageAll()
- DIgnoreFilter()
How the community answered
(30 responses)- A67% (20)
- B20% (6)
- C3% (1)
- D10% (3)
Why each option
NoFilter() removes all active filters - including ranking filters - from a measure's calculation, allowing an average to be computed across all customers regardless of any applied rank.
NoFilter() is a Web Intelligence function that instructs the calculation engine to ignore all filters currently applied to the block or report, including ranking conditions. When a rank is applied to show only the top 20% of customers, a variable using Average(Revenue) would be restricted to only those ranked customers - wrapping it with NoFilter() forces the average to be computed over the entire unfiltered dataset. This gives a true company-wide average for comparison.
NoRank() is not a valid Web Intelligence function and does not exist in the standard formula language.
AverageAll() is not a valid Web Intelligence function; the correct approach is to wrap the Average() function with NoFilter().
IgnoreFilter() is not a recognized function in the Web Intelligence formula language and will produce a formula error.
Concept tested: NoFilter() function to bypass rank and query filters
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/09382da3-ecb0-400e-a2c6-e37d0e3f89ef/4705f2e76e041014910eba7d4b2c66fb.html
Topics
Community Discussion
No community discussion yet for this question.