SAP

Author

Maddy Wilson

Maddy Wilson

Maddy is a content creator for SAP Analytics Cloud. She has a passion for everything digital and enjoys finding creative ways to simplify complex concepts. When she’s not behind her computer you’ll find her enjoying live music, watching a play, or paddling with her dragon boat team.

Keep in touch

Subscribe for the latest news, updates, tips and more delivered right to your inbox.

Subscribe to updates

Category

Learning

Connect with us

View this article in Spanish.

Models in SAP Analytics Cloud contain rows and columns of data, and every column in a model is defined as a dimension or a measure.

What’s the difference between a measure and dimension?

Measures are numerical values that mathematical functions work on. For example, a sales revenue column is a measure because you can find out a total or average the data.

Dimensions are qualitative and do not total a sum. For example, sales region, employee, location, or date are dimensions.

When dimensions and measures work together, they help answer complex business questions. For example, take a look at the visualizations below.

Chart 1 Chart 2
Chart showing the measure total of sales revenue Chart showing the measure of "sales revenue" in relation to the dimension of "region"

Chart 1 visualizes a single measure, in this case, “revenue”. The visualization only answers one question: how much profit did we make? Chart 2 visualizes the measure “revenue” in relation to the dimension “region” to show profits by region. Exploring profits by region will help answer questions about regional performance.

So, are all numbers measures?

No. Not all columns containing numerical data are considered measures. A satisfaction rating, for example, makes more sense as a dimension. Say your model has a column that contains product ratings out of 5-stars. Knowing that a certain product line received 10,000 stars in total is not particularly interesting. However, knowing which products in that line received the most 5-star ratings is useful.

Define your data and you’ll be well on your way to discovering actionable insights with SAP Analytics Cloud. Start today with a free 30-day trial. 

 

SAP Analytics Cloud earns a top ranking from BARC

See how SAP Analytics Cloud performed in the world’s largest survey of Business Intelligence software users.