Forum Discussion
saustermiller
1 day agoNew Contributor
Answered my own question for Dimension vs Measure...
In OneStream BI Viewer, dimensions are qualitative, descriptive data points (e.g., Entity, Account, Time, Scenario) used for grouping, filtering, and defining the structure (rows/columns) of a report. measures are quantitative, numerical data points (e.g., Sales, Amount) that are aggregated, summed, or calculated, forming the cell data in a grid or chart.
Key Differences:
- Function: Dimensions provide context (labels), while Measures provide values (metrics).
- Behavior: Dimensions group data without summarizing. Measures perform summary calculations like Sum, Average, or Count.
- Usage: In a Grid component, dimensions are typically assigned to row/column headers, while measures populate the cells.
- Data Type: Dimensions are often strings or dates. Measures are numeric.
For instance, in a sales dashboard, "Product Category" is a dimension, and "Total Revenue" is a measure.
Related Content
- 2 years ago