You would like to highlight the deviations between budget and actual revenue in query. Which BW feature do you use? (1)

Question

Options

• AConditions
• BCalculated key figures
• CFormula variable
• DExceptions

• B
  3% (1)
• C
  95% (38)
• D
  3% (1)

Explanation

Formula variables in SAP BW BEx Query Designer act as dynamic placeholders within key figure formulas, allowing you to compute the deviation between budget and actual revenue at query runtime. By assigning a formula variable via replacement path (pulling the budget value from a plan version or characteristic), the query dynamically calculates and surfaces the variance - making the deviation visible directly as a key figure in the result set.

• Conditions (A) filter or restrict what rows/columns appear (e.g., top N results) but do not calculate or expose deviation values.
• Calculated key figures (B) can express the math (Actual − Budget), but without a formula variable to dynamically reference the budget figure, the calculation isn't flexible or reusable across scenarios.
• Exceptions (D) apply color/traffic-light formatting to cells that breach thresholds - they visually flag already-computed values but don't themselves calculate the deviation.

Memory tip: Formula Variable = "fill-in-the-blank for your formula." It's the mechanism that lets the deviation formula dynamically substitute the right reference value (budget) at runtime, so the query output shows the gap - not just colors it.

No community discussion yet for this question.