Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Learning SAP Analytics Cloud
Learning SAP Analytics Cloud

Learning SAP Analytics Cloud: Collaborate, predict and solve business intelligence problems with cloud computing

eBook
$32.99 $47.99
Paperback
$60.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Learning SAP Analytics Cloud

Models in SAP Analytics Cloud

In SAP Analytics Cloud, you create models that act as the basis for all data output. A model is a representation of the business data of an organization. It is a high-level design that exposes the analytic requirements of your end users. To determine what content to include in your model, you must first identify the columns from the source data on which users need to query. Then, to establish the role played by each column, identify whether it is a measure column or a dimensional attribute. We will be learning these attributes and many more steps that will assist us in creating and viewing models and other data filtration as well.

The following topics will be covered in the chapter:

  • Introduction to models
  • Understanding measures and dimensions
  • Planning and analytical models
  • Creating a new analytical model
  • Viewing model details in the modeler interface...

Understanding measures and dimensions

You will see the terms "measures" and "dimensions" throughout this book. Every data column that you import from a source to build a model in SAP Analytics Cloud must be marked either as a measure or a dimension. Measures are the columns by which an organization gauges its business operations and performance, while dimension columns contain the data used to qualify the measures.
These terms can be further expanded as follows:

  • Measures: Measures are those fields that can be measured, aggregated, or used for mathematical operations. Measures are typically calculated data, such as dollar value or quantity sold, and they can be specified in terms of dimensions. For example, you might want to determine the sum of dollars for a given product in a given market over a given time period.
  • Dimensions: A business uses measures to evaluate...

Planning and analytical models

In SAP Analytics Cloud, you can create planning and analytical models. A planning model is a full-featured model, which comes with preconfigured time and categories dimensions for actual, budget, planning, forecast, and rolling forecast. A planning model also supports multicurrency and offers security at the level of both model and dimension to restrict access to specific values in the report to named individuals. It also comes with auditing features for traceability. The users who have planning privileges can create their own versions of model data, use allocation features, add new data to the model, and copy and paste data into the model.

In contrast, analytical models are simpler and more flexible general-purpose BI models. Analytical models are not preconfigured with categories for budget and forecast data.

In addition to these two models, you...

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...

Viewing the model in the modeler interface

Once your model is created, you are taken to the modeler area with your new model appearing in the interface. It has a tab carrying two built-in dimensions (time and account) and five private dimensions (state, city, store, manager, and product), which are created using the source data file.

The time dimension

Click on the Time dimension tab (A). The Time dimension is built into analytical models that define the start and end dates of the plan's timeline and the smallest time units that will be used in the plan. The time dimension specifies the overall time frame for the model and also the granularity--the smallest time period down to which the data will be analyzed--for example...

Browsing models

To see a list of existing models, click Models on the main menu icon and go to Browse | Models. You will be taken to the Models interface (illustrated here) with all your models listed:

Copying a model

The copy option in the model's toolbar section is a very handy option to create a new model based on an existing model. It is illustrated in the following screenshot.

When you use this option to copy a model, the data and private dimensions are also copied to the new model. Public dimensions are referenced from the copied model. Note that you can use this option only for the models created in SAP Analytics Cloud version 2016.21 or later. Further, note that if a model uses a pool dimension (which is used...

Viewing model data

As mentioned earlier, the data of the Account dimension members is not visible in the modeler. You can view this data in Stories, which is the subject of Chapter 4, Creating Stories using Charts. For the time being, you will create a temporary Story to see how the model data is reflected.

To view the model data, execute the following steps:

Upon clicking on the Story option, a wizard will initiate, and you will get the following screen:

When you click on Import & Export Data, you get a Choose how you'd like to add data screen:

Proceed further with the steps displayed in the following screenshot to add dimensions:

Viewing numerical data

We have the option of viewing numerical data. We can do...

Summary

This chapter provided hands-on exposure to creating an analytical model in SAP Analytics Cloud, which serves as the basis for all your analytical needs.

Here is the workflow to create a new analytical model from a file:

  1. Import a source file.
  2. Set name, description, and other parameters for the model.
  3. In the initial data view, choose the dimension types for the dimensions in your new model.
  4. Specify attributes for the dimensions.
  5. Cleanse your data and fix any mapping or data quality problems.
  6. If needed, create a location dimension to visualize the data in geo maps.
  7. Delete the columns that you do not plan to use in your stories.
  8. Create hierarchical relationships between columns.
  9. Start the automatic creation of the model.

In the next chapter, you will go through the second type of model, that is, planning, which has categories for budgets, plans, and forecasts. It also comes...

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Predict new opportunities and risks in a few mouse clicks
  • Eliminate complexity with tools that let you plan, analyze, and collaborate in context—in real time
  • Discover, visualize, plan, and predict in a single product with agile BI tools

Description

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.

Who is this book for?

This book targets IT professionals, business analysts, BI developers, managers, newcomers to SAP Analytics Cloud, and ultimately anyone who wants to learn from self-paced, professional guidance and needs a solid foundation in SAP Analytics Cloud.

What you will learn

  • 1. A clear understanding of SAP Analytics Cloud platform
  • 2. Create data models using different data sources, including Excel and text files .
  • 3. Present professional analyses using different types of charts, tables, geo maps, and more
  • 4. Using stories, drill up and down instantly to analyze data from various angles
  • 5. Share completed stories with other team members or compile them in SAP Digital Boardroom agendas for presentation to major stakeholders
  • 6. Export the results of a story to a PDF file
  • 7. Save time by planning, analyzing, predicting, and collaborating in context
  • 8 Discover, visualize, plan, and predict in one product as opposed to separate solutions
Estimated delivery fee Deliver to United States

Economy delivery 10 - 13 business days

Free $6.95

Premium delivery 6 - 9 business days

$21.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jul 10, 2017
Length: 420 pages
Edition : 1st
Language : English
ISBN-13 : 9781788290883
Vendor :
SAP
Category :

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to United States

Economy delivery 10 - 13 business days

Free $6.95

Premium delivery 6 - 9 business days

$21.95
(Includes tracking information)

Product Details

Publication date : Jul 10, 2017
Length: 420 pages
Edition : 1st
Language : English
ISBN-13 : 9781788290883
Vendor :
SAP
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 159.97
Real Time Analytics with SAP Hana
$43.99
SAP HANA Cookbook
$54.99
Learning SAP Analytics Cloud
$60.99
Total $ 159.97 Stars icon

Table of Contents

10 Chapters
Getting Started with SAP Analytics Cloud Chevron down icon Chevron up icon
Models in SAP Analytics Cloud Chevron down icon Chevron up icon
Planning model Chevron down icon Chevron up icon
Creating Stories Using Charts Chevron down icon Chevron up icon
Extending Stories with KPI, Filters, and Other Handy Objects Chevron down icon Chevron up icon
Analyzing Data Using Geomaps and Other Objects Chevron down icon Chevron up icon
Working with Tables and Grids Chevron down icon Chevron up icon
Collaboration Chevron down icon Chevron up icon
Digital Boardroom Chevron down icon Chevron up icon
System Administration Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.2
(5 Ratings)
5 star 40%
4 star 20%
3 star 0%
2 star 0%
1 star 40%
Amazon Customer Jun 26, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book that provides great use cases and guidelines to quickly get up to speed on the cloud. I have downloaded the trial and I am on my way!
Amazon Verified review Amazon
Cliente Kindle Jul 26, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Good book to go through the Analytics solution in the cloud. It is well ilustrated and easy to understand. Good option for the ones who are starting on Analytics or just getting in touch with the new solution in cloud.
Amazon Verified review Amazon
Shokurei Apr 05, 2018
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
I read the comments of another reviewer and have had the same issues. The reason for the issues is not a fault of the book, but of the fact that SAP are constantly updating SAP Analytics Cloud (SAC) including the user interface. Some of the things the book suggest you do are now accessible elsewhere on the screen and not immediately evident. If you can get past this annoyance this is actually a very good book which takes you through each element of the software in details with examples.SAC comes with its own sample files, although the 30 day trial does not allow you to access onsite databases, just csv and excel files. You may need “SAC connectors” to access these as well as the full version. At £15 a month for access to SAC with a minimum 12 month term it’s not expensive.
Amazon Verified review Amazon
Amazon Customer Apr 03, 2020
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
I am trying to ram p up on SAC. This book was published in 2017 and it is obsolete. I can't follow the book to produce results because the environment and process of doing things has totally changed. DON'T buy this book. IT IS OUTDATED and they are not going to give me an update. wrong.
Amazon Verified review Amazon
Robert W. Mcgaffic Jan 26, 2018
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
Off to a rough startI successfully downloaded the SAP trial software and imported the spreadsheet Bocage.xlsx file with no problems.But when I tried to change the column Date from type Dimension to Time as on page 39, I can't. The Time value is grayed out and can not be selected.When I tried to change the column Quantity Sold from type Dimension to Measure as on page 40, you guessed it -- Measure is grayed out.When I attempted to create a location dimension per page 41 and follow the instructions to "Click the ellipsis button appearing next to the Longitude column's heading then select By Coordinate from the submenu, I find the following:1. There is no ellipsis button appearing next to the column head for Longitude2. There is no submenu from which to select the value Coordinate.The author recommends downloading the SAP trial for learning purposes, but he obviously has not done so or suggested resolution of these issues.Hopefully the author or the reviewer will post instructions in how to use the SAP trial system to overcome these issues. Otherwise the book is worthless
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the digital copy I get with my Print order? Chevron down icon Chevron up icon

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela