Exploring Advanced Mode in SAP Analytics Cloud Stories

Objective

After completing this lesson, you will be able to describe the use of Advanced Mode in story design.

Reasons to Use Scripting in Stories

You might be wondering why you would want to add scripting and the advantages it can offer?

Most modern analytics tools avoid scripting to simplify the designer’s tasks. While this allows more people to use the system, many users have more complex business requirements and want to move beyond the limitations of the scenarios built into the tools.

Adding scripting to a story in SAP Analytics Cloud will allow you to move beyond present narratives, to respond to user interaction in a custom way, to present result sets in a different way, and to dynamically alter a layout. Scripting allows for more creativity and the ability to respond to more multifaceted business requirements.

Examples of Scripting in SAP Analytics Cloud Stories

The examples below are just an indication of the possibilities available with scripting in SAP Analytics Cloud. For example, using scripting in a story in SAP Analytics Cloud will allow you to design a story that:

Uses a dropdown to display dynamic values.

An SAP Analytics Cloud story with a dynamic dropdown displaying data for Product Rating.

Shows the top 3 results as an image.

SAP Analytics Cloud story showing top three results as an image.

Calculates values using R language.

SAP Analytics Cloud story showing values calculated using R language.

Displays a different layout that is dependent on the device used to access the story.

SAP Analytics Cloud story displayed in Auto and Generic Phone as examples of dynamic display.

Advanced Mode Functionality

Using Advanced Mode in an SAP Analytics Cloud Story

Using Advanced Mode in an SAP Analytics Cloud story lets you add custom logic to your story with more widgets, functionality, and scripting capabilities.

Watch this short video to learn more about Advanced Mode, including turning it on and the additional functionality available to you.

Training System

There are two ways that you can practice the topics introduced in the lessons and exercises:

Using your own system.
Using an SAP Analytics Cloud trial.

Using Your Own System

You will not be able to use the same stories and data used in the exercises and demos. However, you can apply the knowledge and skills that you learn in the lessons to your own stories.

Using an SAP Analytics Cloud Trial

If you don’t have access to your own system, you can download the SAP Analytics Cloud Trial. You will not be able to use the same stories and data used in the exercises and demos. However, you can apply the knowledge and skills that you learn in the lessons to the sample story provided in the trial.

Note that access to the trial is time-limited.

Optional Exercise: Create a Story with KPI Tiles and Tab Pages

This story is used in all exercises in this learning journey. This practice exercise is designed not only as a review of story-building but also demonstrates how the story has been set up as we will start each exercise with the pre-built story.

Business Scenario: Before starting to enhance your SAP Analytics Cloud story using scripting, you want to use Advanced Mode to create a story with a panel containing two KPI tiles and two tab pages containing a time series chart and a table.

Task Flow: In these practice exercises, you will:

Create story and add a panel widget
Add KPI tiles to a story panel
Add a tab strip with two tab pages to a story
Create a time series chart on a tab page
Create a table on a tab page

Task 1: Create Story and Add a Panel Widget

ExerciseStart Exercise

Task 2: Add KPI Tiles to a Story Panel

ExerciseStart Exercise

Task 3: Add a Tab Strip with Two Page Tabs to a Story

ExerciseStart Exercise

Task 4: Create a Time Series Chart on a Tab Page

ExerciseStart Exercise

Task 5: Create a Table on a Tab Page

ExerciseStart Exercise

Log in to track your progress & complete quizzes