In this SAP HANA Cloud tutorial, we will learn How to Create SAP Analytics Cloud Story and its different modes.
Also, we will see how to bookmark the story and export the story to a pdf file in SAP HANA.
Moreover, we will see how to import your own dataset and explore it using the data view, after this, we will know how to create a story from the imported data.
What is SAP Analytics Cloud Story
The main platform for reporting and analyzing data is an SAP Analytics Cloud narrative. Due to the fact that it can include interactive elements, highly visual charts, detailed tables, or a combination of these, it is frequently referred to as a report or a dashboard.
When a story is started (opened), it does so in View mode by default. You can still use the extra features and interactive parts of the story while in this mode.
Various Working Modes of SAP HANA Cloud Analytics Stories
The two working modes for all SAP Analytics Cloud stories are:
- View: View is the default mode when a story is opened. With the exception of any interactive components included in the plot, you have virtually little control over the story in this mode. In other applications, read-only is comparable to it.
- Edit: You do, however, have complete control over the story’s layout in Edit mode. You can include new pages and other things in the narrative. The story’s aspects can be rearranged. The tale can be altered or given further interaction.
These are the different working modes of SAP HANA Cloud Analytics Stories.
Check out: How to Work With SAP HANA Cloud Integration
How to Create SAP Analytics Cloud Story
In SAP Analytics Cloud, stories are at the foundation of the user experience. They enable interactive data exploration for insights, information visualization using charts and tables, and sharing, presenting, and discussion of your discoveries with peers. Knowing a few fundamentals is helpful before you start.
The story consists of two things, the data view, and the story view. A data view that allows real-time data exploration, and dynamically changing visualizations. Creating stunning, dynamic dashboards for yourself or others is possible in the Story view.
The measures and dimensions specified in the story’s model or dataset hold the key to the underlying data, regardless of the view you are on.
- Measures are numerical values that give your data meaning. For instance, sales volume, salary, or staff size.
- The categories that makeup dimensions give your data meaning. for instance, the type of product, the time, or the place.
Together, they provide the basis for analyzing data in unique ways, whether it be through the comparison of gross margins in various geographic areas or a trend line of revenue over time.
Consider attributes as columns in a dimension table because they are part of dimensions. Now we know about stories, let’s Set up and import the data.
You can import data from a wide range of local and cloud-based data sources using SAP Analytics Cloud. For example, we will use the CSV file COVID-19 Vaccination Trends in the United States, downloaded from Kaggle.
To import the downloaded data go to the Home page of the SAP Analytics Cloud. Drag your file into SAP Analytics Cloud’s Home screen from your computer. When the pop-up displays, click on the Prepare Dataset option.
You’ll see the Data Manipulation view in your recently generated story once the data has been loaded into a model.
Measures and dimensions have been automatically mapped to your column data. The value should be set as a measure in our example data, while the other columns should be assigned as dimensions.
For a better dataset overview change the mode to Grid View as shown in the below picture.
Next, select the column whose properties or details you want to change or view and click on Navigate to details icon as shown in the below picture.
Now you see the dimension properties and column details that you can change according to your need.
In the above picture, you can see the column details like data type, statistical type, and conversion format. You can modify these properties depending on the requirements.
You can also explore the data, to explore the data click on the Data Exploration option in the mode section of the toolbar.
Charts are automatically suggested as you choose and uncheck metrics and dimensions in the Data view. In the facet pane, click on Show Dimensions (+).
From the dimensions select the Date and Location as shown in the below picture.
Then from the Measures select Admin_Dose_1_Daily and from date select 2020 and Location as AK (Alaska). After selecting, It displays a numerical point chart with the value of 23,460 vaccine doses daily in Alaska(AK) in the United States.
Although SAP Analytics Cloud offers a powerful designer where you can create more permanent pages with visualizations and other interactive components, the Data view is an excellent approach to gaining quick insights into your data.
To create a new story page, copy your current chart from the Data view to the first page of your story, and choose “Copy to Page 1” as shown in the below picture.
The Story view is automatically selected as your current view as you can see in the below picture.
Now you have successfully learned how to create the story or story page in SAP Analytics Cloud.
Have a look: What is SAP HANA Cloud Graph [Detailed Guide]
SAP HANA Cloud Analytics Stories Bookmarking
To preserve various parts of a tale, create bookmarks. You might want to build up many states or scenarios when viewing a tale instead of returning to the same view of the data each time. For instance, you may have added filters or prompts to a number of the pages in your tale.
Every time you want to witness a different situation, you don’t want to have to take the time to reset them all. When the story begins, you should see one scenario and then quickly move on to another.
Both private and public bookmarks are available. A private bookmark can always be saved, while a global bookmark requires proper authorization.
Save the current state of your story after you are happy with how it appears.
- Choose (Bookmark) > Bookmark Current State from the menu.
- Give your bookmark a title.
- Make the bookmark Personal or Global as desired.
- Choose if you want to make it the new default bookmark.
- Choose Save.
When you write your story and save it, a default bookmark is generated for you. Do the following to access the default bookmark or any other saved bookmarks:
- Choose (Bookmark) > Open Saved Bookmark from the menu.
- Choose either the default bookmark or a saved bookmark.
You can also share your personal bookmarks when viewing a story.
- Choose (Bookmark) > Open Saved Bookmark from the menu. Pick a personal bookmark from the My Bookmarks section, and then click (Share).
- Add Users or Teams: Include every person or group you wish to share with. To access a list of accessible users, either type a username or choose (Add usernames or teams). Choose Share.
SAP HANA Cloud Analytics Stories Export a Story to PDF
From the File menu, you can export the entire story in either View or Edit mode to a .pdf, .pptx, or Google Slides file type. You should be aware that there is no export option for .csv, .xls, or .xlsx file types under the File menu. Exporting is solely a presentation format operation.
In various regions of the story elements, there are choices for exporting the story’s data. To export the stories, first, you should create a story that will be exported. Here we are going to use the sample stories that SAP HANA Cloud Analytics provides.
Click on Explore a sample story as shown in the below picture.
Select any sample story like The Best Run Juice Company shown in the below picture.
Click on File as shown in the below picture.
Then click on the Export option.
After clicking on Export,
- Select either PDF, Google Slides, or PowerPoint (.pptx) from the File Type drop-down menu in the dialogue.
- Select the pages you want to export under General Settings: Select the Range, the particular pages, or all.
- If you want to go on working as the file is being processed and saved, choose Enable export in the background. Until the export is finished, you might notice a slower response time.
- To include an appendix with the filter settings and variables specified for the story, choose Insert Appendix.
- Batch Exporting, Selecting this option will allow you to export some or all of the members of a story filter
After clicking on Export, a progress bar appears to show the export process.
Then you see the pdf file downloaded at the left bottom of your browser as shown in the below picture.
This is how the story is exported in SAP HANA Cloud Analytics.
Additionally, you may like some more SAP tutorials:
- How to Use Select Statement in SAP HANA Cloud
- How to Create a Foreign Key in SAP ABAP
- How to Create Lock Object in SAP ABAP?
In this SAP HANA Cloud Analytics tutorial, we have discussed SAP HANA Cloud Analytics Stories and its two-mode data and story. Then learned about how to import the data, explore the data, and created the story page. Also learned how to export the story to a pdf file.
- What is SAP HANA Cloud Analytics Stories
- SAP HANA Cloud Analytics Stories View and Edit Mode
- SAP HANA Cloud Analytics Stories Export a Story to PDF
- Creating a story in SAP HANA Cloud Analytics
I am Chris Waldron, working as a Senior SAP HANA Consultant at Halliburton, Houston, Texas, United States. I have been working in SAP for more than 15 years, especially in SAP IT consulting and business consulting. I worked in various industries in Sales & Distribution, Customer Relationship Management, banking, Risk Management, etc. And I am an SAP Certified Development Specialist – ABAP for SAP HANA 2.0 and SAP HANA Modeling Certified consultant. Read more