🎴 Flashcard Mode
Enterprise Technology Fundamentals: Lotus Notes, SAP Retail, and Data Warehousing
Card1 / 20
Mastered0
Review0
QuestionClick to flip
I want to see number of orders against team size of the team processing the orders. Which is the fact and which is the dimension?
AnswerClick to flip back
A
Order count is the measure, Team Size is the dimension
💡 Explanation:
Order count is clearly a measure/fact (numeric aggregate being analyzed). Team size is a dimension - it's a descriptive attribute of the teams processing orders, used to group or filter the order counts. In dimensional modeling, measures are the numeric values we analyze (facts), while dimensions are the context descriptors (who, what, where, when) we analyze across.