Tell us what you think

We want to create the best possible experience for our learners. Your feedback helps us to improve the experience for everyone.

Explaining Modeling Options

Objective

After completing this lesson, you will be able to Differentiate between dimensions, models, and datasets.

Dimensions

Dimensions represent categories that provide perspective on your numeric data; for example, product category, date, region, cost center, and so on. Dimensions can contain properties that further describe a dimension. For example, you may have a dimension for customer which has properties such as phone number and address to further describe the customer dimension.

Dimensions can also be rolled up into a hierarchical view; for example, time (year, quarter, month), geography (country, region, location), employee structure (executive, manager, employee), and so on.

Measures represent the numeric values that you are analyzing; for example, sales revenue, salary, number of employees, quantity sold, and so on. Sometimes these quantities are contained in a single dimension referred to as an Account type dimension (and probably with the name Account, or something similar). In this situation, the numeric values represent the line items on a corporate balance sheet, income statement, profit/loss statement, and so on. But you can also present the numeric values as individual elements called Measures.

Together, dimensions and measures are the framework for viewing data, whether it be a trend line of revenue over time or a tabular comparison of gross margin across different regions.

Models

Models are comprised of dimensions and measures and represent a specific subset of data; for example, sales, production, financial, shipping, etc.

Models are the primary data sources for SAP Analytics Cloud stories.

In SAP Analytics Cloud there are two styles of models:

Analytic model: read-only
Planning model: read/write

We will look at each style in more detail in the next concepts.

The Modeler

The Modeler area of SAP Analytics Cloud is where you create models. According to your data integration strategy, you can create a new model one of 2 ways:

Create a model
Create a live data model

Analytic Models

An analytic model is used strictly for read-only data reporting and analysis. A date dimension is available but is not required, and you can remove it from the model during the design stage.

Why is a date dimension optional? One scenario is that the model represents only current data. Because users know the data is always "current," there is no need for a date dimension.

Screen shot of a sample analytic model, with the model preferences inset.

Planning Models

Planning models are pre-configured with required dimensions for Date and Version. These dimensions are required because planning activities are dictated by time frames, and the planning numbers are intended for different purposes – budget, forecast, and planning. Planning models offer support for security features at both the model level and dimension level.

When working with a planning model in a story, users with planning permissions can create their own versions of model data. These users can also write data to the model by typing new values, copying and pasting data, and using data actions.

Screenshot of a sample planning model, with required dimensions highlighted and the model preferences inset.

Datasets

A dataset is a simple collection of data usually presented in a tabular format. You can use a dataset as the basis for a story.

Types of Datasets

SAP Analytics Cloud has two types of datasets:

Embedded: Embedded datasets are embedded into a story and are unique to that story. They cannot be shared outside the story or refreshed.
Public: Public datasets are standalone datasets and can be shared among different stories.

Both types of datasets can be enhanced with basic data preparation and transformation functionality.

Neither dataset can be scheduled for a refresh; you must manually re-import the updated data. SAP Analytics Cloud automatically matches the columns of the newly acquired data to the columns of the existing data, but any prior data transformations will be lost.

If you import data from a flat file, you can only re-import a compatible file: a file that has the same number of columns as the original file, and with the same column names and data types as in the original file.

Both datasets can be secured to allow users access to the dataset or not. Specific column-based or property security, however, is not supported for any datasets.

Converting Datasets

You can convert an embedded dataset to a public dataset. However, a limitation to a public dataset is that you cannot change its data source. For example, if your public dataset was originally created from a flat file but you now want to use an SAP Business Warehouse query, you have no option to make that change. Embedded datasets, on the other hand, do allow you to change the data source via the Add New Data option.

You can also convert an embedded dataset into a model, but any transformations you made to the dataset are lost and must be recreated in the model. A public dataset, however, cannot be converted to a model.

Compare Datasets and Models

Overall, datasets and models complement each other. Datasets are perfect for ad hoc, ungoverned use cases based on acquired data. Models are used when the use case requires more governed data analysis and planning scenarios.

Diagram summarizing the data included in this concept above.

Next lesson