C_BOWI_40 · Question #115
You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data…
The correct answer is A. =[Revenue]/RefValue([Revenue]). When data tracking is active in Web Intelligence, the RefValue() function retrieves a measure's value from the reference data snapshot, enabling variance calculations.
Question
You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?
Options
- A=[Revenue]/RefValue([Revenue])
- B=[Revenue]/PreValue([Revenue])
- C=[Revenue]/HistValue([Revenue])
- D=[Revenue]/BaseValue([Revenue])
How the community answered
(17 responses)- A65% (11)
- B12% (2)
- C18% (3)
- D6% (1)
Why each option
When data tracking is active in Web Intelligence, the RefValue() function retrieves a measure's value from the reference data snapshot, enabling variance calculations.
RefValue([Revenue]) returns the value of the Revenue measure as it existed in the reference data set defined for data tracking, so dividing the current value by the reference value correctly computes the relative variance ratio between the two data states.
PreValue() is not a valid Web Intelligence function for data tracking - it is not part of the standard formula language for retrieving reference snapshot values.
HistValue() is not a standard Web Intelligence data tracking function - it does not exist in the formula language for comparing current versus reference data.
BaseValue() is not a valid Web Intelligence formula function - it is not recognized in the data tracking context for retrieving reference measure values.
Concept tested: RefValue() function for Web Intelligence data tracking variance
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8d2e8dde24af4c29b0efbc9f4a9f3e56/4696a4f56e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.