In SAP Analytics Cloud, before you create a Story or an Analytic Application you need to prepare the data by utilizing various data enrichment options. If you are building a Story, you can even use an embedded model. But in most business scenarios when developers are involved, public data models are created which can be consumed by multiple Stories and Analytic Application. In this blog, let us discuss various aspects about managing your data in a public model to increase productivity and ensure smooth operation.
If you are interested in learning about Data Modelling in SAP Analytics Cloud, check out the blog here.
Sharing and Security
One important aspect when it comes to model management is security. You do not want your model used in a production dashboard to be accidentally deleted or modified. You need to maintain your models in folders that have custom security permissions defined. Also, if needed you can specifically share a model and give ownership to trusted users even if they don’t have access to the folder. One nice addition when you apply folder security is the option to apply the same security settings to all underlying files and subfolders. Apart from sharing the objects with specific users, you can also maintain User Groups or User Roles to have customized security.
Any user can maintain folder security by using the Share button in the File Repository.
In the share settings, you can share with new Users or User Groups, assign specific controls and also email the recipients about it. You will be able to remove or change any existing permissions too. You can customize the access where you specifically set permissions such as the ability to Share, Update, Delete, etc.
One interesting feature within Files Repository is you will be able to upload other files with formats like PDF, PPT, Word directly to any folder and assign security settings.
Suppose if your model is deleted accidentally, you can access the deleted files within File Repository Recycle Bin icon. All the deleted files are stored for 30 days. Additional information like days remaining, deleted by and date of deletion is also available. To restore, select the file and click on the Restore button on the top.
To duplicate a model, you can directly select a model within the Files Repository and copy them using toolbar options. There is no Save As option while viewing the model.
You can check the box Include Data to copy all the fact data or you can only copy the metadata and master data into your new model. Also please note that any existing import or export schedules in the model will not be copied over to the new model.
If you want to find the Stories and Analytic Application that uses the model, open the model and then check the Model Details panel where the related objects are listed.
You cannot delete a model while it is still being used in a Story or Analytic Application. A popup will show the list of references and you need to remove the models from the Story or Analytic Application in order to delete a model.
Removing Model from Story or Analytic Application
To remove any unused model within a Story, navigate to the Data tab that has the list of models and remove the model from the Story.
If the model you are trying to remove is mapped in any of the widgets in Story, then an alert shows up with the list of all widgets linked with the model. You need to either delete the widget or change the model mapped to it.
When you save the Story, if the Story has any unused models (that are not mapped to any widget), you get an alert where you can choose to remove or keep the models.
For an Analytic Application, we do not have any option to directly remove the model. However, when you delink the model from widgets and save the Analytic Application, you will get an alert similar to Story where you can remove the models that are not used.
In the second part of this blog, we will discuss various model preferences, changing the data source of a model based on LIVE connection and importing new data into models with acquired data.