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

Creating a new analytical model

Execute the following steps to create a new analytical model. The screenshot has numbered steps for sequence to be followed for creating an analytical model:

Selecting a source file

You can import data from an external file, such as an Excel spreadsheet or a comma-separated-values file, into a new model. If the data is saved in separate sheets in the Excel workbook, you will see a drop-down list from where you can choose which sheet to import:

The source data must include columns that can be used to create dimensions in a new model, and it must also include transactional data (measures). The transactional data is not visible in modeler, only in the output that is generated.

You can connect...