In the first part of this blog, we learnt about security options, deleting and duplicating a model, finding references and about removing the model from the story. In this blog, let us check out the options in model preferences, remapping data source and adding new data to existing models.
The model preferences are different for Acquired and LIVE models.
1. Acquired Model
General Settings allows you to change the name and description of the model. Access and Privacy are where you enable Data Locking and Data Access Control. You also have options to enable Data Audit and restrict the export to CSV. Your current privileges for the model are also displayed at the top.
In the Fiscal Time tab, you can change any particular date to be in Fiscal Calendar. You can change the starting month and also choose how the fiscal year is denoted. You can also choose the fiscal period to be denoted as Period or Month.
If your Model is planning enabled, you will also be able to change the From and To Date. For example, you can import actual data into the model and then increase the To Date till the next six months. This way you can do forecast planning by enabling unbooked data in the table widget.
The other two tabs are for Currency Conversion which is discussed in detail in the blog here. The last tab Data and Performance has an option where you can enable Optimize Story Building Performance which will stop automatic updates on a chart or table so that you can build your Story faster.
2. LIVE Model
For LIVE Models, the preferred options are limited. You have options to change the description, index the model to Search to Insight (supported for BW, HANA and S/4 HANA connections) and enable Model Translation.
Under Access and Privacy, you only have the option to restrict CSV export. Apart from that, you also have the option to enable Optimize Story Building Performance like Acquired model.
Changing Data Source of a LIVE Model
If you have a model with LIVE connection, you will be able to remap the underlying query and also change the system. This could be very useful when you need to remap the data from Development to Production System. Also, if desired you can change the query to a different one within the same system. If the fields of the query changes, then you may need to remap the widgets that use this model. Please note that if the model is indexed to Search to Insight, the index will be deleted once you change the data source and you need to re-index the model for Search to Insight to work again.
Adding Data to Existing Acquired Models
While creating a model you can either start with a blank model or import data from a source. Either way, you will be able to add or replace new data into the model. For removing the fact data (i.e. all the measure values) from the model, you can use the Delete Facts options within the model.
Data import and Import/Export Job options are available in the Data Management tab. For importing new data, you need to import that as a draft data source. Then select the draft data source and map the fields of draft data source and model. You will also be able to do transformations and some other options that were available while you created the model by importing data. You can check the progress made in mapping the fields on the top. To map attributes like description or property, double click the dimension so that it expands to show all the attributes. Once the mapping is complete, you can choose between options like an update, append or clean and replace to add this newly imported data. You can check the full details in the blog here.
Please note that if your model has any Public Dimensions, then it’s best to create a blank model, link the public dimension and then import data into the model. If you have import jobs for Public Dimension, then you need to first run the import job of the public dimension and then run the import job for the model. Also, if your model is enabled for Currency Conversion but your data is already pre-converted, remember to enable the option Pre-converted Actuals within Model Preferences.
To know more about Data Modelling in SAP Analytics Cloud, check out the blog here.