C_BW4HANA_27 · Question #31
Which Objects can be used in the BW query "Fixed Values" area to restrict the data? (2)
The correct answer is A. Characteristics C. Navigation attributes of a characteristic. In SAP BW Query Designer, the Fixed Values area (part of the filter section) allows you to restrict query data using objects that can act as selection criteria - only Characteristics (A) and Navigation Attributes (C) qualify because they are both treated as selectable…
Question
Which Objects can be used in the BW query "Fixed Values" area to restrict the data? (2)
Options
- ACharacteristics
- BKey figures
- CNavigation attributes of a characteristic
- DDisplay attributes of a characteristic
How the community answered
(56 responses)- A93% (52)
- B2% (1)
- D5% (3)
Explanation
In SAP BW Query Designer, the Fixed Values area (part of the filter section) allows you to restrict query data using objects that can act as selection criteria - only Characteristics (A) and Navigation Attributes (C) qualify because they are both treated as selectable dimensions in the query context. Navigation attributes are explicitly enabled in the InfoObject as "navigation-capable," which grants them the same filtering power as standalone characteristics.
Key figures (B) are measures/metrics, not dimensional filters - they belong in the Columns or Rows area, and data restriction by measure value is handled through Conditions, not Fixed Values. Display attributes (D) are purely presentational; they depend on their parent characteristic and cannot be independently used for selection or filtering - they have no "navigation" capability in the query engine.
Memory tip: Ask "Can it navigate?" - if yes (Characteristics and Navigation Attributes), it can filter in Fixed Values. Display attributes only display; Key figures only measure.
Topics
Community Discussion
No community discussion yet for this question.