Which objects can be affected by the key date in a BW query? (3)

Question

Options

• AKey figures
• BNavigation attributes
• CDisplay attributes
• DHierarchies
• EConditions

• A
  8% (5)
• B
  75% (44)
• D
  17% (10)

Explanation

In SAP BW, the key date determines which version of time-dependent master data is read when the query executes. Navigation attributes (B) and display attributes (C) can be defined as time-dependent in the InfoObject, meaning their values change over time - the key date pins which value is valid at that moment. Conditions (E) are also subject to the key date because their evaluation can be influenced by the time-dependent state of the data being filtered.

Why the distractors are wrong:

• A (Key figures): Key figures are stored transactional measures aggregated from fact tables. They reflect what was posted during the selected time period, not a point-in-time master data snapshot - so the key date does not apply to them.
• D (Hierarchies): Although hierarchies can be time-dependent, they are controlled by a separate hierarchy key date setting in BW, not the general query key date, so they are not in the same category as attributes and conditions.

Memory tip: Think "NAC" - Navigation attributes, Attributes (display), Conditions - these three all hang off master data context that a single key date can pin in time. Key figures live in the fact table, and hierarchies have their own date knob.

No community discussion yet for this question.