It has been a while since we introduced the New Model in SAP Analytics Cloud. With its measure-based layout, it brings a lot of benefits in terms of performance, calculations, currency conversion, and more. It has also been the foundation for innovation ever since and we added features like weekly and user-managed time dimensions, currency variables, data import API, geo-enriched public dimensions etc. exclusively to the New Model.
We are not at the end of our journey yet though. However, we are taking a big step now and we are adding functionality to the New Model. It is our ambition to make the New Model the one and only model type for acquired data in SAP Analytics Cloud making classic account models and datasets obsolete. No worries, existing models/datasets shall still work. We just plan to block the creation of new classic account models and datasets at some point, but we are not quite there yet (more details in the What’s next section).
In this blogpost, I want to give you an overview of the new features and changes in UX that we are introducing based on the upload and transformation of a standard data set. We thoroughly researched the UI changes with customers and ran a beta testing phase to make sure we absolutely hit home with this delivery and the future plans! Please note that the features described here will be made available in a controlled release in QRC4 2023. General availability is scheduled for QRC1 2024.
First things first, let’s look at the model creation workflow. We will focus on the new data first workflow. With that, we are adding functionality that was only available in the classic account model and datasets until now.
Modeler Home Screen
You will notice that we tidied up the Create New section of the Modeler landing page. You now have the simple choice between creating a local model in SAP Analytics Cloud or creating a Live Model. As all changes apply to the New Model only, let’s go ahead and see what happens when we create a new local model.
Model Creation Dialogue
A dialogue appears asking us whether we want to create a model from data, so, using a data source (like a file or one of your system connections) or whether we want to start with a blank model. The classic account model option remains available for now.
We loaded a file and immediately, we are taken to the Model Structure page (you can wrangle your data later on). You will notice that it looks quite different now. This is the same for data-first and structure-first workflows.
The New Model UI
We are enhancing the concept of dimensions. From now on, not every dimension must have an own master data table (dimension table) associated with it. The dimensions we see in the screenshot are just columns in your model data until you create dimension tables for them. Some features are only available in dimensions with dimension tables but don’t worry, the product will let you know what needs to be done as soon as it is required. Basically, we are adding a flexible feature of our datasets to the model and make it available for most of the consumption workflows.
What can you do with dimensions without dimension tables?
What additional features are available for dimensions with dimension tables?
Unless you need one of the above-mentioned features, you can stick with the dimension without master data. This will benefit the performance of your model.
Now, let’s look at some examples for the workflows.
Our data set has a customer ID and a customer description. Both are dimensions right now.
Customer ID and Customer Description in Separate Dimensions
But we know that the description belongs to the ID. So, how can we unite them? There are different options that we will run through based on this simple example. In the background, the system will group the columns.
Our data set has product ID, product description, a bike type and a product group. We already know how to turn dimensions into properties of another dimension. So, we have done that already.
Product Dimension with Properties
Now we want to create a level-based hierarchy. We can do that easily when we go to the product dimension.
First, we must convert our longitude and latitude columns from measures to dimensions as the system had identified them as measures. We do that via the context menu:
Convert Measures to Dimensions
Afterwards, we can assign the description, add the other properties, and create the level-based hierarchy:
Region Dimension with Properties
As said earlier, some features are only available for dimensions with associated dimension tables. So, let’s add one. Again, we support multiple options to do so. Note that in any case, you can also choose to make the dimension table public (create a public dimension).
Create Dimension Table from Sidepanel
In any case, the dimension table will be created for you. You can manage it directly in the side panel, preview in the data foundation table, and edit members separately in the dimension table.
Edit Dimension Table
We are offering an accelerated workflow to create standard dimensions (dimension tables) like version, date, and account. Just change the dimension type via the context menu of the dimension.
You will see that the workflows are tailored to the distinct dimension types.
When adding dimensions, you can choose accordingly whether you want to create a dimension table or not or whether you want to add an existing dimension table (so, an existing public dimension). So you see that the dimensions without dimension table feature can also be used at any time, not just when creating your model with data.
The graph view will show dimension with dimension tables as dedicated branches. Dimensions without dimension tables and measures will be shown in the core of the graph only. Hence, the graph view gives you a good overview of your model structure and meta data.
Graph View
You probably know our wrangling functionality that allows you to transform your data upon import. Great news – we are decoupling this feature from the data import process so that you can transform your data whenever required!
Transform Data
Timestamps are now available in the New Model! They are an own dimension type that can be found amongst the other dimension types. They always are dimensions without dimension tables.
Timestamps
As mentioned before, we are having a controlled release with QRC4.2023 and plan the general availability for QRC1.2024.
What you saw here is just the first milestone delivery of a larger endeavor to make the New Model the only model type for acquired data in SAP Analytics Cloud.
Here is what we have planned for the future (multiple deliveries; no timeline yet):
At a certain point, we want to disable the possibility to create classic account models and datasets. However, there is no timeline yet and we are aware of some functionality that still needs to be added to the New Model (e.g., combine data).
You have now gotten to know the new functionality of the SAP Analytics Cloud New Model. Most significantly, you should keep in mind that it now offers a data first workflow, dimensions without dimension tables and the wrangling of the fact table. Make sure to get your hands on the system as soon as you can and try it out as the introduced changes are significant. We are looking forward to your feedback.