Create Live Data Model and a Story

To create a Live Data Model, navigate to the modeler section in SAP Analytics Cloud. Select Modeler.

Under the modeler, select the option live data model.

Select the system type as SAP HANA and the connection that you have created previously.

Type first three letters of the CV in the data sources section. This will show the calculation view that you have created previously in BAS.

Select the calculation view and click OK.

This will show all the measures and attributes that are part of the model.

Click on SAVE button to save the model. Specify a name to the model and then hit save.

From the home screen of SAC, select stories and click canvas type of stories under create new.

This will open the new story. click add data button.

Select data from a model in the next window, this will navigate you to the list of models that are available.

Select the model that you have created in the previous steps.

This will bring you to the data analysis section where you can analyze the data from the model.

Select the Story tab again and add a numeric point chart to display total sales amount, bar graph to show sales amount variation with respect to the products and a donut chart to show customer wise sales amount. After adding the charts, navigate to the styling section in SAC to add custom styles and colors to the charts and other objects in the story.