Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Learning SAP Analytics Cloud

By : Ahmed

3.2 (5)

Learning SAP Analytics Cloud

3.2 (5)

By: Ahmed

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

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

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

Visualization

Collaboration

Presentation

Administration and security

Signing up for the trial version

Summary

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

Summary

Planning model

Planning model

Creating a planning model

Visualizing planning model data

Viewing the text data

Spreading, distributing, and assigning values

Creating private versions

Summary

Creating Stories Using Charts

Creating Stories Using Charts

Demo models

The calculation editor

Apply conditional formatting using thresholds

Presenting data with a line chart in a story

Summary

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

Summary

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

Summary

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

Showing totals

Applying a date filter

Testing the effects of page filters on a table

Styling tables

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

Summary

Collaboration

Collaboration

Creating an events and tasks workflow

Creating an event

Creating tasks

Events toolbar

Sharing a story with colleagues and granting access privileges

Collaborating via discussions

Sharing files and other objects

Summary

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

Summary

System Administration

System Administration

Creating users

Setting a user password

Changing passwords

Importing users

Exporting users

Deleting users

Assigning roles

Built-in roles

Creating a new role

Role settings

Permissions

Test role permissions

Forming teams

Transferring the system owner role

Setting security for models

Monitoring user activities

Monitoring the system

Deployment

The export process

The import process

Summary

Customer Reviews

3.2 (5)

5 star

40%

4 star

20%

3 star

0

2 star

0

1 star

40%

Creating a planning model

Execute the following steps to create a planning model:

Click on the main menu icon, and go to Create | Model:

You can create a planning model from scratch in which you enter values manually in the cells or copy and paste data from a spreadsheet. You can also create this model type by importing data from a variety of sources. To keep things simple, you will fetch data from an Excel file named StoresData.xlsx in this exercise.

On the New Model page, click on Import a file from your computer:

On the Import Model From File dialog, click on the Select Source File button (A), and in the Windows Open dialog, browse for the StoresData.xlsx file (B) that comes with the book's source. Note that this file has three sheets carrying data for the Actuals, Budget, and Forecast categories. Start the proceeding and import data by selecting the Actuals option...

Search

Your notes and bookmarks