C_BOWI_40 · Question #145
Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?
The correct answer is B. It will refresh up to three times slower. Data tracking in Web Intelligence compares old and new data values on each refresh, adding significant overhead to the process even when row count and volume remain constant.
Question
Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?
Options
- AIt will refresh up to three times faster.
- BIt will refresh up to three times slower.
- CIt will refresh faster each time the report is refreshed.
- DIt will refresh slower each time the report is refreshed.
How the community answered
(47 responses)- A6% (3)
- B74% (35)
- C4% (2)
- D15% (7)
Why each option
Data tracking in Web Intelligence compares old and new data values on each refresh, adding significant overhead to the process even when row count and volume remain constant.
Data tracking adds processing overhead rather than reducing it, so a speed increase of three times is technically impossible.
When data tracking is enabled, Web Intelligence must compare each retrieved value against the previously stored snapshot to identify changes, additions, and deletions. This comparison work is performed in addition to the normal data retrieval, causing refresh times to be up to three times slower than without tracking enabled.
Refresh time does not improve progressively with each refresh - the comparison overhead is incurred on every refresh cycle.
While refresh does become slower, 'slower each time' implies cumulative degradation per refresh, which is incorrect - the slowdown is consistent, not increasing.
Concept tested: Data tracking performance impact on report refresh
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1c0a6a3d2b6f4e76a87e49f1b22b5b5a/46d2a56a6e041014910sce01.html
Topics
Community Discussion
No community discussion yet for this question.