Which external hierarchy properties can be changed the query definition? (3)

Question

Options

• ATime dependency
• BExpand to level
• CPosition of child nodes
• DSort direction
• ESuppress unassigned node

• A
  4% (1)
• B
  93% (26)
• E
  4% (1)

Explanation

When working with external hierarchies in a query definition (typically in SAP BW/BEx Query Designer), you can override three display-related properties: Expand to Level (B) lets you control how many hierarchy levels are initially expanded in the result; Position of Child Nodes (C) lets you place child nodes above or below their parent; and Sort Direction (D) lets you reverse the default sort order of nodes - all three are presentational overrides the query can apply without touching the hierarchy definition itself.

Time Dependency (A) is wrong because it's a structural characteristic defined on the hierarchy object itself (it determines which version of the hierarchy applies based on a key date), not a display property the query can override. Suppress Unassigned Node (E) is wrong because that behavior is governed at the characteristic or hierarchy level, not configurable per query.

Memory tip: Think "BCD = how it looks in the query" - Browse depth (expand level), Child placement, and Direction of sort are all visual tweaks a query can make to an existing hierarchy, while time dependency and unassigned-node suppression are baked into the hierarchy's own definition.

No community discussion yet for this question.