New Modeler in SAP Analytics Cloud
Data is the oxygen in this digital era. It becomes important to understand the data with correct and proper semantics. Often data is referred to as Knowledge, and it won’t make sense only with data, so we want Information. The information would emerge when we properly arrange the data.
Therefore, it becomes important to collect data from multiple sources and make it meaningful information. So, in SAC, we do it with models. In business terminology, A model is a representation of the business data of an organization or business segment.
SAC has introduced a new model structure as shown in Figure 1.
Figure 1: New Modeler view on SAC
New modeler helps to improve performance, including three important benefits.
- Improved model experience.
- Improved calculation capabilities.
- Enhanced Currency Features.
Improved the model experience
The model experience is very much important, as the model is the first preliminary step for Story and Analytic Application. So, SAC has improved the model experience keeping in mind different kinds of users. It becomes important how the user creates a model, interacts, and uses it in a story or application designer especially focused on enhanced navigation.
Improved calculation capabilities
You can add measure calculations to your model and can reuse them across the different stories and analytic applications. Based on dimension properties, account values can be changed from positive to negative respectively. This will be easier for users like accountants to analyze data. There is an intuitive formula editor which helps to highlight syntax and in turn to improve accuracy and easily read formulas.
Enhanced Currency Features
Currency conversion tables help to take source data from different currencies in a model and convert it. This conversion can be a single currency for aggregation or into a set of currencies from a dimension. Multiple base currency measures can be added to models along with that currency conversion measures can be added on top of them. You can import currency data from the different data sources into a currency conversion table and schedule as required.
Steps to Use
Login to SAC Tenant. Once credentials are validated, Go to My Files and click on the ‘+’ symbol, and select model on SAP Analytics Cloud as shown in Figure 2.
Figure 2: Navigation to Model selection
Figure 3: Creating a new model
Select the ‘New Model’ option from Create Blank Model window as shown in Figure 4.
Figure 4: Creation of Blank Model
It is easier to convert the model which is a classic account model to a new model. To convert open existing classic model as shown in Figure 5 respectively.
Figure 5: Model conversion from classic to new
So, clicking on the button Migrate to New Model Type in the modeling area helps you to convert the model to a new model. If models are already used on Story or Analytic Applications, we cannot convert to the new model. And if we want to know where it is used click on the ‘Details’ option on the right side of the model window as shown in Figure 6.
Figure 6: Model details
In this blog post, we learned an overview of the new SAC modeler which helps to improve performance, including three important benefits. To learn even more about the new model type and to keep up to date be sure to check out the help documentation. Please feel free to share any feedback in a comment under this blog post and if you have any further questions on SAP Analytics Cloud be sure to leave a question in the community also here.