In this blog post we will see how to update the model with additional or new field/dimentions in a model in SAP Analytics Cloud.
- open the model which you need to update.
- Let’s say, In the current model we have imported data from an universe.
- Let’s say,The universe contains 5 columns,such as:
- Initially the model was imported with three columns, such as
- Now if we wanted to add the other dimensions C4 and C5 into the model, we can’t directly edit the dataset in the model(In Data Management tab).
- In order to bring in C4 and C5, Create two dimensions for C4 and C5 name it appropriately in the model tab.
- After creating the dimensions,Go to the Data Management tab and import the data form the same universe with the old columns and as well as the new columns. For instance, in our case we need to add C1,C2,C3,C4,C5.
- After uploading the data, the uploaded data will be in Draft data section.
- Double click on that draft data.
- The mapping screen opens up.
- Map the respective fields.
- Make sure the import method accordinly on the details pane.
- Click on Finish mapping.
- Now the model will be updated with the additional fields as well.
So This is how we can update the models in SAP Analytics Cloud with new/additional fields. We will be discussing about the import methods in detail in the upcoming blog posts.