Book Image

Learning SAP Analytics Cloud

Book Image

Learning SAP Analytics Cloud

Overview of this book

The book starts with the basics of SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud) and exposes almost every significant feature a beginner needs to master. Packed with illustrations and short, essential, to-the-point descriptions, the book provides a unique learning experience. Your journey of exploration starts with a basic introduction to the SAP Analytics Cloud platform. You will then learn about different segments of the product, such as Models, Stories, Digital Boardroom, and so on. Then, you are introduced to the product's interface: the Home screen, the main menu, and more. Then comes the hands-on aspect of the book, which starts with model creation. Next, you learn how to utilize a model to prepare different types of stories(reports) with the help of charts, tables, Geo Maps, and more. In the final chapters of this book, you will learn about Digital Boardroom, Collaboration, and Administration.

Preface

What this book covers

What you need for this book

Who this book is for

Reader feedback

Customer support

Free Chapter

Getting Started with SAP Analytics Cloud

Getting Started with SAP Analytics Cloud

Anatomy of SAP Analytics Cloud

Data sources and models

Administration and security

Signing up for the trial version

Models in SAP Analytics Cloud

Models in SAP Analytics Cloud

Understanding measures and dimensions

Planning and analytical models

Creating a new analytical model

Viewing the model in the modeler interface

Browsing models

Viewing model data

Planning model

Creating a planning model

Visualizing planning model data

Viewing the text data

Spreading, distributing, and assigning values

Creating private versions

Creating Stories Using Charts

Creating Stories Using Charts

The calculation editor

Apply conditional formatting using thresholds

Presenting data with a line chart in a story

Extending Stories with KPI, Filters, and Other Handy Objects

Extending Stories with KPI, Filters, and Other Handy Objects

Key performance indicators (KPIs)

Story and page filters

Creating a chart to display key performance indicators

Adding a reference line to a chart

Setting individual chart filters

Adding dynamic text

Adding static text

Creating hyperlinks

Examining data behind a visualization

Creating an aggregation calculation

Pinning and commenting on a data point

Saving your story

Analyzing Data Using Geomaps and Other Objects

Analyzing Data Using Geomaps and Other Objects

Working with story pages

Location clustering in geomaps

Applying a filter to a geomap

Linking different models

Creating a combination column and a line chart

Using predictive forecasting through a trend time series chart

Working with Tables and Grids

Working with Tables and Grids

Copying objects between pages

Applying ranking

Copying objects to the same page

Grids and tables

Working with tables

Applying filters to a table

Showing/hiding table elements

Sorting table data

Applying a date filter

Testing the effects of page filters on a table

Creating formatting rules

Setting visibility filters

Swapping the table axis

Freezing table rows and columns

Using KPIs in a table

Working with grids

Creating a blended table

Copying objects, pages, and stories

Copying grouped objects

Saving a story as a PDF

Creating a personalized dashboard by pinning story objects

Adding text notes to the home screen

Collaboration

Creating an events and tasks workflow

Creating an event

Sharing a story with colleagues and granting access privileges

Collaborating via discussions

Sharing files and other objects

Digital Boardroom

Digital Boardroom

Optimizing the display

Creating an agenda

Creating agenda sub-items

Enabling data exploration

Setting navigation targets

Enabling touch cell input

Starting a meeting

Adding annotations

Stopping an online meeting

System Administration

System Administration

Setting a user password

Changing passwords

Importing users

Exporting users

Assigning roles

Creating a new role

Test role permissions

Transferring the system owner role

Setting security for models

Monitoring user activities

Monitoring the system

The export process

The import process

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Sorting table data

Execute the following steps to sort the dimension values in a table:

Click on the Net Revenue cell.
Select the Sort options, and then choose Value Sorting (A) from its menu. Not all values in a table can be sorted. The sort options icon is only enabled for dimensions that can be sorted.

In the Create Value Sorting dialog box, set Type to Descending (B) to sort the values in descending order. The Direction list carries two options: Vertical and Horizontal. This list is only enabled if more than one sort direction is possible in the table. If you choose Vertical, the column the dimension is included in will be sorted. If you choose Horizontal, the row the dimension is included in will be sorted. For this exercise, keep the default Vertical option (C) selected. Make sure that Account is set to Net Revenue (D). For Date, select Q1 (E) using the Edit icon...