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

Examining data behind a visualization

While working on charts in a story, you sometimes want to see the underlying data to evaluate the results being displayed on those charts. Here's how you can examine the data behind the charts.

Select the KPI chart, and select Examine (A) from the More menu. A grid will appear in the lower section of the page (B), with all the values that the chart is based on along with hierarchies:

If you make any changes to the chart's definition in the Builder panel or apply any filters on the chart, the data being displayed in the grid is also affected. To test this scenario, uncheck California and Oregon in the Location filter, and keep the Nevada state checked. As you can see in the following screenshot, the applied filter not only affects the chart (A), but the data in the grid is also filtered to only display the selected state (B).

...