Which two fields are examples of dimensions used in semantic layer views? Note: There are 2 correct answers to this question.

Question

Options

• APosting dale
• BItem code
• CItem quantity
• DDocument total

• A
  74% (26)
• B
  17% (6)
• C
  9% (3)

Explanation

Posting date (A) is a clear dimension because it is a time-based descriptive attribute used to slice, filter, and group data - a textbook example of a dimension field in any semantic layer. Document total (D) qualifies as a dimension in this context because it represents a pre-aggregated, document-level descriptive attribute that characterizes the document as a whole, rather than a value intended to be further summed across records.

Item code (B) is incorrect because it functions as a foreign key or reference identifier that points to a dimension object (e.g., a product master), not a dimension field in the view itself. Item quantity (C) is a measure - a numeric, additive value designed to be aggregated - which is the opposite of a dimension.

Memory tip: Dimensions answer descriptive questions like "when?" (Posting date) or "what overall?" (Document total), while measures like quantities are things you count or sum, and codes are keys that link to dimensions rather than being dimensions themselves.

No community discussion yet for this question.