openSAP

Intelligent Decisions with SAP Analytics Cloud

Week 2 Unit 1

00:00:07 So, we've now finished building our story, we've themed it, and it looks like it's coming from
our company,
00:00:12 this is where we'll start adding in some of our smart features. First off we're going to talk
about Search to Insight.
00:00:19 So, remember how we first started building out the story? Let me remind you, in case you
forgot.
00:00:24 So I'm going to go into edit mode and I'm just going to manually add in a chart.
00:00:28 And as I manually add in this chart, and I'm just going to drag this down,
00:00:36 and then I'm going to start building it out. As I build it out, I'm going to select what my
measures are,
00:00:43 and I'm going to select what my dimensions are. So this isn't bad.
00:00:47 This is a pretty way of doing it. But what if it was even easier?
00:00:51 What if, instead of you learning how to use the tool, it learned how to communicate with
you?
00:00:56 That's Search to Insight. So I'm going to activate it up here, using the search icon,
00:01:01 and then all I have to do is type it in. Hey, show me my order value.
00:01:04 I don't have to know how to use this. It brings it right back.
00:01:07 Or, I could say "by product", and there you go. "For the C900 bike".
00:01:15 And even as I do this, it's able to figure out, even though I have a spelling mistake,
00:01:22 what's going on. Now, we could also say more advanced things.
00:01:27 So I could say "show order value by product for the C900". Sorry, "for last year".
00:01:36 And as I do that, it now understands what I mean, and it's showing it for 2018, when I said
last year.
00:01:43 I could also come in and I could say I want to show that order value by product as a pie
chart.
00:01:53 And it'll get what I mean there as well. And bring me back a pie chart visualization.
00:01:57 And once you find something that you really like, all you have to do is copy it back into your
story.
00:02:02 So I can copy that onto my overview page, and as I've done that and I exit back out of
search,
00:02:08 it's now added that chart over here. So look how easy it is to build using Search to Insight.
00:02:14 There's more that I want to show you. So one of the other things I want to show you
00:02:17 are Smart Insights. So, as you're looking at something, so right now I'm taking
00:02:22 a look at my units sold, and let's say I want to take a look at it by the segment, or I want to
take a look at it
00:02:27 by the product, and as I'm taking a look at this, what I might not know is why is this bike so
high
00:02:33 and this one is so low? I'd have to go and slice and dice the data
00:02:37 to figure that out. But, we can also add Smart Insights here.
00:02:41 So I'm going to click on the "...", and click Add Smart Insights, and what it does is takes a
360-degree look
00:02:47 at my data and it surfaces up for me what is actually impacting this.
00:02:52 What's contributing the most. So now it's showing me that the R200 bike
00:02:56 is the top contributor. 28% above average and it's being driven significantly
00:03:00 by current customers. Now, if you're skeptical about it, just click on it
00:03:04 and we'll show you exactly what's going on. So now it's going to pop up and show you
00:03:08 what is impacting that, I'm sorry, what's contributing to that.
00:03:10 And you can slice through here and see those top contributors.
00:03:15 Now, another thing that we could do is we can also do some time series forecasting.
00:03:21 So, let's just go ahead and take this nice chart that we have here, and I'm going to change it
over
00:03:25 to a time series chart. And I'm going to throw in my time dimension.
00:03:33 I'm going to remove that product and now you can see our order value over time.
00:03:37 But what if I wanted to add in a forecast? It's as easy as just tapping on the automatic
forecast.
00:03:43 As I activate the automatic forecast, it'll look through my data and it's going to figure out
00:03:48 what are my values out into the future. If you're particular about how it's being calculated,
00:03:52 you can actually specify, so instead of just using the automatic forecast, you also have the
option to manually
00:03:58 select linear regression, triple exponential smoothing, or even add in additional input such
as weather
00:04:04 or your competitor's stock price - something else that might be impacting your forecast.
00:04:08 But that's how easy it is to add in a forecast into what you're looking at.
00:04:13 Now the final part that I want to show you is what you can do with Smart Discovery.
00:04:17 So, we had gone through, we spent all this time together, building out this dashboard, we
could have had it build
00:04:23 the entire dashboard for us. So that's why we waited to show you this until the very end.
00:04:27 So I can go ahead under More and I can activate Smart Discovery.
00:04:32 Once I activate Smart Discovery, I can say I want to build a report based on Order Value or
something like that,
00:04:38 and just hit Run. And as I'm doing this, this is like a data scientist
00:04:42 in a box, it's going to build out my entire report for me. So, before I can even send an e-mail
over to my data scientist,
00:04:50 asking for help, it's going to come back, and have built everything and all the insights.
00:04:56 So let's take a look at what it came back with. So you can see it's created an overview page
for me -
00:05:04 Key Influencers, Unexpected Values, and Simulation. On my overview page you can see
that breakdown
00:05:10 of all my orders, you can also see it by segment. It's added in those Smart Insights that we
saw earlier,
00:05:16 and you even see it over time, and adding on that time series forecast, and you can see it's
slowly sloping downwards.
00:05:23 So you might want to know, why is my order value going down? Check out your key
influencers.
00:05:29 With your key influencers, it shows you what is most important,
00:05:33 so for your order value. Top thing is units sold, followed by product,
00:05:38 followed by number of customer meetings. And look at this, it builds the dashboard in the
same order.
00:05:42 So here you go. It was units sold, product,

2
00:05:47 and there's your number of customer meetings. So each time you run this, based upon your
data,
00:05:51 you're going to get something totally different on the other side.
00:05:55 So it will build it out dynamically, and surface to you the most important insights.
00:06:00 Now, you can also go through and do some needle-in-a-haystack work. So, we were looking
at thousands of rows of data
00:06:06 of order values, but what if there was an outlier? What if something was amiss?
00:06:11 You would have had to manually go through each and every one of those. But with this,
what it does
00:06:15 is it actually draws out what is considered the normal line, and will help you identify quickly
all of your outliers.
00:06:22 So here, we can see, we have 31 unexpected values, and it's showing us each and every
one of those.
00:06:28 What was expected and what the actual value was. And it goes all the way down to the
detail level.
00:06:34 So you can follow up with that sales agent, you can see exactly what was going on in that
situation,
00:06:39 and it's all being surfaced for you. And, finally it'll build out a simulation.
00:06:45 So with the simulation, you could say I have a product. So let's say I want to take a look at
my C990 bike,
00:06:52 and what I want to do is I want to target retail, and I'm going to go after prior customers.
00:06:57 Well this is what your average order value is predicted to be. So all it's doing is it's taking a
look at all of that
00:07:04 historical information, and it's based upon what data set you're looking at, it's going to run
an algorithm on it
00:07:10 to try to surface to you these types of simulated values. This gives you, the end user, the
ability to do this type of simulation.
00:07:17 So, we've taken a look at some of the smart features that exist within the tool, and again,
this is included
00:07:23 in your core license and I highly recommend all of you start using this immediately.

3
Week 2 Unit 2

00:00:07 We are done. We have built an amazing dashboard.

00:00:11 It's got all of these Smart Insights. It is fit to share with the entire universe.
00:00:16 But how do we do that? So that's what we want to talk about next.
00:00:19 Collaboration. So let me show you first the basics.
00:00:22 As you come in here, the first thing you need to do before you can even share
00:00:25 or do anything is save it. Hopefully you've been doing that
00:00:29 throughout this entire process, but once you save it, then you'll have this option highlighted
00:00:34 where you can start sharing it. So instead of having it where you send them,
00:00:37 you know, a static file or something like that, what we prefer is that they'll get access
00:00:43 to the live URL with the live data. And that means those insights,
00:00:47 everything is going to be up to date. So as we come through here,
00:00:50 you can share that story with additional users or teams and you can grant them different
levels of access.
00:00:56 Now once you're done sharing it with them, you'll also be able to interact with them
00:01:00 right from within the story. So, for instance, if I want to come in here
00:01:05 and I'm coming in as a viewer and I say, oh, this is so interesting, what a great insight, well,

00:01:10 I can come in and add my own comment right on it. So I can say, hey, this is a great insight.

00:01:19 And then once I place the comment, this is really important for the young millennials
00:01:23 in the workforce, they're able to like their own comment and give themselves a pat on the
back.
00:01:28 So this is just some of that collaboration capability. Now I can do that on a chart level.
00:01:33 I could also add a comment right on a page level. So you can see up here as I click on the
page,
00:01:39 I can also add a comment right there or I can even do some conversation
00:01:43 throughout the entire application, from the collaboration panel right up here on the right.
00:01:48 Now, I did talk about the fact that we're presenting it with this nice interactive type of demo,

00:01:54 but what if you do want something that's a little bit more static? Don't worry,
00:01:57 we have options for you there as well. So as you go over these different charts,
00:02:01 you have the ability to export them. So you have the ability to export these out,
00:02:05 you can get a CSV file of it, if using a table, it could be an Excel file,
00:02:08 and then you also have the ability right from the story itself, where you could be saving it
00:02:13 as well and exporting it in a variety of formats. So you can see we can export this out
00:02:18 to PDF or to Google Slides today. Now with this nice report,
00:02:24 let's say I did share it live to someone, and they want to be able to consume it,
00:02:27 how would they do that? Well, they can do it with their mobile device.
00:02:31 So you don't have to redesign everything. This is a design one can consume in multiple
ways.
00:02:36 So since we used the responsive design, this will also show up on their mobile device.
00:02:42 We also have a device preview mode that shows you what that's going to look like.
00:02:45 So right here, you can see as I go into my device preview mode that I have the option of
choosing

4
00:02:50 what type of screen size I want to see this on. So right now I'm looking on the Web.
00:02:54 Let's go ahead and take a look. What would this look like if I switched this over
00:02:57 to be on my phone? And you can see, it's just realigned everything
00:03:01 to fit for that type of screen size. So you can say, what does it look like on my tablet?
00:03:05 What does it look like on any of these different screen sizes or devices?
00:03:08 And let's say you find something where it doesn't look how you were expecting it.
00:03:12 You can actually adjust that. So let me jump back over to the phone view
00:03:16 and let me show you what I mean with that. So while I'm on the phone,
00:03:19 let's say I want this to be smaller for some reason. You can go ahead and you can jump into
the Designer panel,
00:03:26 and you can select that object, and you can actually modify how that's going to look for that
specific screen size.
00:03:33 So as I'm making this adjustment, note up here at the top,
00:03:36 it's saying that it's applying just for the small phone chart.
00:03:39 So you have this type of really granular control, so you make sure it looks exactly
00:03:43 as you'd like on the different screens. Now keep in mind,
00:03:46 when it dynamically built out that dashboard for me, it's the same thing for me here.
00:03:51 It's all mobile. So I just had to design it that one time.
00:03:54 It's going to look great forever. Now there's other things that you can do
00:03:58 in terms of collaboration once you're done. So let me exit back out of this mode
00:04:03 and let me show you a couple other really neat things. One other thing that's really
important
00:04:08 to be aware of is the idea of bookmarking. So let's say you've designed one report,
00:04:13 but you have so many different teams accessing it, and these different teams all want to
view it their own way.
00:04:19 Normally, what they'd have to do is they'd have to go through
00:04:22 and they'd have to either save a copy, which means you're going to have hundreds or
thousands
00:04:26 of copies throughout the organization, or every time they go into it,
00:04:29 they have to set their filter values again. Instead of doing that, you can actually bookmark it

00:04:34 and have it be the way that you want it. So if they want to format,
00:04:37 if they want to choose something like a certain filter or they want to be able to choose,
00:04:42 you know, what is going to be the date, whatever story or page filters that they're looking at,

00:04:47 they can then go ahead and they can say, once they're done, in their view mode,
00:04:51 they can go ahead and they can bookmark it. Now it's disabled right now
00:04:54 because I must've made a change to it, but once I save this, you'll see what I mean.
00:04:58 That you'll have this bookmarking capability pop up. So let me hit Save,
00:05:02 and then View, and check that out.
00:05:08 Now you have this bookmarking option and you can bookmark your current state.
00:05:12 You can create either personal or global bookmarks. So personal bookmarks, just like what
they sound,
00:05:17 they're just for you, but you can actually share those personal bookmarks
00:05:21 or you can create global ones as a story owner and make it where they're available to
everyone.

5
00:05:25 So I could create global bookmarks for each of the regions or for each of the departments,
whatever I wanted to do.
00:05:30 And then I optionally can also make it as my new default as I'm saving this.
00:05:35 So that time, every time I enter into the story, it will be viewed just the way that I want to.
00:05:41 What's also really cool with this is we showed you explore mode in the very, very beginning.

00:05:47 You can actually bookmark that explore mode as well. So if I came in, I took to look at my
unit sold,
00:05:53 what I want is I want the end user to be able to further analyze this.
00:05:57 So I'm going to activate, from the Designer panel, the exploration mode.
00:06:10 So once I've enabled the explore mode, you'll see this brand new icon pop up right over
here.
00:06:15 Now when they're in view mode and they're viewing that icon, they actually have the ability
of creating their own view
00:06:21 of the data when they're exploring it. So I'm going to go ahead and tap on this now,
00:06:25 jump into my exploration mode and once I've done so,
00:06:32 I can actually create my own brand new view and my capability of doing bookmarks
00:06:38 will work against this as well. So let's say I want to show a heat map
00:06:42 or something like that. Cool.
00:06:44 You can go ahead and do that and let's do it where it's based upon the segment and the
status.
00:06:50 And there you go, and you can save that view and you can make this your new default view
and bookmark it.
00:07:00 So lots of capabilities in here in terms of when you're sharing, collaborating, and
personalizing
00:07:05 this for your own use. Don't forget that when you're all done,
00:07:08 you can also pin different charts to your home screen. So if I see a chart that I like,
00:07:12 like I really like this geomap, I can go ahead and pin this
00:07:16 and now it's going to save it onto my home screen. So this just shows you some of
00:07:22 the collaboration capabilities inside of here. I hope you've enjoyed our time together
00:07:26 and please do reach out. Inside of the course materials,
00:07:30 there's an area for you if you have any questions about any of the topics that I've covered
so far.
00:07:34 Thanks so much and good luck.

6
Week 2 Unit 3

00:00:05 Welcome to week two, chapter three. In this chapter, we'll be covering
00:00:09 Digital Boardroom and Mobile. We'll have examples for creating
00:00:13 Digital Boardroom presentations and agendas as well as viewing content on your mobile
device.
00:00:21 Digital Boardroom is built on top of SAP Analytics Cloud. It's a separate application
00:00:26 still viewable through the browser that takes the models and the stories
00:00:30 and brings many of those stories together in a single shared experience.
00:00:36 Digital Boardroom works best on large touchscreen devices, but it does work on any
available screen
00:00:42 where you can display the content using a Chrome browser. Digital Boardroom works best
for bringing content
00:00:49 across multiple lines of business so you can break down those silos in your organization
00:00:54 and make decisions based on all of the available information.
00:00:59 Any of the features that you see within stories are also available within Digital Boardroom
00:01:05 with an additional layer for adding filtering across those multiple stories, meeting minutes,
00:01:09 adding jump links to be able to navigate among the content. Digital Boardroom also allows
you
00:01:16 to do financial simulations. It allows you to tell the story behind the numbers
00:01:21 in a collaborative environment in that shared experience. For mobile, Mobile uses
responsive layouts
00:01:31 and allows you to access your content on your iOS device, whether it's on a mobile phone
or on a tablet.
00:01:38 The same content that you create once you can view in a story,
00:01:42 you can view on your mobile device, and you could also view that same content
00:01:46 when you add it into a presentation on Digital Boardroom. The mobile app also has some
special features
00:01:52 that are unique to the mobile device like being able to annotate
00:01:55 and share the content via text message or email directly from your mobile device.
00:02:01 You can directly link into the mobile app using deep linking,
00:02:04 and you can see the documentation for more information on how to do that.
00:02:10 Digital Boardroom and Mobile are really designed for business users for viewing the
content.
00:02:16 So although there is a design time experience within stories for creating those charts,
00:02:20 creating the data structures, the tables, for your business users who want to view the
content
00:02:26 on their mobile device or in their meeting rooms, Digital Boardroom and Mobile
00:02:30 are the best experience for that. In this example, we're going to create
00:02:35 a Digital Boardroom presentation. There are two types of Digital Boardrooms
00:02:40 that you can create, an agenda and a presentation.
00:02:43 An agenda is more structured where one item flows to the next one
00:02:47 whereas a presentation allows for more dynamic links. So to start with, we'll create the
name
00:02:53 and the style that we'll be using, so a Dashboard,
00:02:57 and the first thing to do is import the stories that we'll be bringing in from exercises we've
run before.

7
00:03:03 So here, I'm navigating to some of the saved examples of stories.
00:03:07 Stories can be either responsive or canvas layouts. In this example, we're going to import
two different stories.
00:03:14 Any of the pages can be chosen to show in the Digital Boardroom.
00:03:20 After importing the stories, we're going to choose which ones we want to show up in our
topics.
00:03:25 A Digital Boardroom is arranged into different topics, and within those topics,
00:03:29 you can have pages from a story. Whether it's for three screen, one screen, or two screen,
00:03:35 you still create your Digital Boardrooms within this creation experience.
00:03:39 You can choose as many story pages as you'd like. If it overflows the amount of screen real
estate,
00:03:46 you can swipe right or use the navigation buttons to navigate to other stories within your
Boardroom.
00:03:53 So here, we're going to add another topic. So the first one we created was Overview,
00:04:02 and now, we add in the Shipping and the Transactional Overview,
00:04:10 and we're going to change the topic title there. So after we're happy with it,
00:04:21 we're going to add another topic. We're going to call this one HR,
00:04:26 and this is going to be from my second story. In a Digital Boardroom,
00:04:30 you can have stories from multiple different areas brought into a single experience.
00:04:36 The whole design for Boardroom is that your different lines of business
00:04:39 can be combined into that single executive experience. So here, we're bringing in the HR
pages,
00:04:44 and after this, I'm going to define specific navigation. So first, we'll save it,
00:04:55 and the next step here, we're going to define custom navigation,
00:04:58 what are called jump links. So I'm going to define the source location for my page,
00:05:05 so here, from the Overview, I want to allow my end user to be able to navigate
00:05:10 to the HR page, and then, later, also the Shipping and Transactional page.
00:05:16 So here, I'm selecting, when I use the Context Menu, which pages am I going to be allowed
to go to.
00:05:37 Now here, within the Financials, I'm going to navigate with context,
00:05:42 so if I drill down on a particular product category, for example,
00:05:45 so here, I'm picking the tile. Let's say I've navigated by
00:05:52 whichever department or product category, right here, so let's say Soft Drinks.
00:05:59 At runtime, I would be able to pass that context over to the Shipping and Transactional
page,
00:06:07 and it says "Apply selected dimension as a filter", so I'm going to choose that.
00:06:13 Close. And here, I'm going to add a Topic Filter.
00:06:20 So a Topic Filter allows you to set a filter across the entire topic.
00:06:24 So, if the dimension is available on all the stories, then that filter would apply everywhere.
00:06:30 So here, for example, Region, if I select that Topic Filter,
00:06:34 when I change it at runtime, it would apply to both the Product Category,
00:06:38 the Financials, to the Product Analysis, the Overview, Financials - any page that I navigate
to.
00:06:46 The next thing I'll do is I'm going to change the styling of my Digital Boardroom.
00:06:50 So here, there's a theming that I can apply. So here, I'm going to change the theme from
Light to Dark.
00:06:58 Just as I have a preference for the dark backgrounds on a bigger screen.

8
00:07:03 Then I'm going to apply that. See what it looks like, so this is a preview of what that can look
like.
00:07:16 This is where I would change the font settings, any background images, the styling.
00:07:21 This can override the story without having to change the story.
00:07:25 And here, within the presentation, I can choose whether I'm optimizing it for a single screen,

00:07:29 or a multi-screen, or a preview window. Typically, for a single screen,

00:07:34 I recommend keeping it at the one-page option. Here, I'm also going to add, in the Context
Menu,
00:07:42 I'm going to add the Meeting Minutes. So these are different chart actions.
00:07:46 The Context Menu allows you to launch Explorer, if I want to do the chart details from here,

00:07:53 so I drag on the Meeting Minutes where I want it to show up in the radial dial.
00:07:56 Click Apply. Very good, and now I've created my Digital Boardroom.
00:08:05 So now I'm going to save it, and then, I'm going to preview it
00:08:10 from within the Digital Boardroom preview experience. This is the runtime version
00:08:21 of the Digital Boardroom presentation that we just created. If you remember the difference
between the agenda and the presentation
00:08:28 is that the presentation is more free-flowing, and we can navigate more easily
00:08:32 between the different topics. So here across the top,
00:08:35 we have our three stories that we added in, Overview, Financials, and Product Analysis.
00:08:41 We can navigate by swiping, by using these navigation tabs down here,
00:08:46 or by tapping on the tabs across the top. All of these charts are interactive.
00:08:52 So for example, if I want to drill down on 2019,
00:08:59 I can go through the hierarchy and look at the data there. Going back to the Overview,
00:09:06 if you remember, we created a couple of jump links. These are also available through the
Context Menu.
00:09:12 By tapping and holding, the "Jump to..." appears, and then I can choose which one I want to
go to
00:09:19 and the context passed to it. So here, we tap on Shipping,
00:09:23 and then, the Digital Boardroom will take us to that detailed information.
00:09:27 And here, we'll see a table and a chart showing the information we want to see
00:09:32 during our presentation. Going back to our Overview,
00:09:39 we can also look at the Meeting Minutes that we might want to create
00:09:43 and any that were created in a previous presentation. So here, I tap on Meeting Minutes,
00:09:49 and up comes the information that I've entered previously as meeting notes during the
presentation.
00:10:00 For best results, we strongly recommend Digital Boardroom to use a 4K screen. In this
example, it's a large 4K screen, an 86- inch from LG,
00:10:08 connected to an external laptop with a great video card. It's a touchscreen environment,
00:10:14 and it works best in a shared meeting, and Digital Boardroom is built on SAC, Analytics
Cloud,
00:10:20 so all the content that you create here was built in the Story Builder,
00:10:24 and then, Digital Boardroom created on top, and then, we see it at runtime.
00:10:28 In this exercise, we're going to create a Digital Boardroom agenda.
00:10:33 This is a more linear type of Digital Boardroom than the presentation.
00:10:37 So here, we'll enter the name, and then, we'll choose the "Agenda" type,

9
00:10:44 so more of a traditional boardroom meeting structure. So here, you can see the layout of the
designer
00:10:50 is a little bit different than the Presentation Builder. So we're going to create the name
00:10:54 of the first topic in the agenda we want to cover, but we still need to import the stories.
00:10:59 So here, we're going to import two of the stories that we've created before.
00:11:02 So the first one will be the CORPORATE_OVERVIEW, and the second one we'll bring in
00:11:09 is the Completed_13 story. And here, we can see the available pages
00:11:18 within those stories. So the first thing I'm going to do is add a picture
00:11:23 that goes into the Overview section. This'll be displayed at runtime
00:11:27 when we're running our Digital Boardroom presentation. And I'll put my name as well as the
expected amount of time
00:11:35 it'll take to cover that topic. And now, I'm going to add some content
00:11:39 from my stories into this agenda. So here, I've added the Overview.
00:11:43 I can add the Product Analysis, and then, at runtime, when this is going,
00:11:47 you'll be able to see this information during your boardroom presentation meeting.
00:11:55 Next, I'm going to add some details so that during the presentation,
00:11:59 I can have some context that'll flow during the topic. So here's a page that'll be available to
link to,
00:12:08 Corporate Financial Details. I'll pick a story that I've imported
00:12:11 into this Presentation Builder, it'll be the Financials.
00:12:15 I'll close this. Next, I'm going to create a second agenda item,
00:12:26 maybe call this one HR. I'm going to add a topic to this one as well
00:12:33 to put some content in there from the Human Resources pages. Now I save it,
00:12:51 and here, I'm going to go through some different settings. So this is where I can define
00:12:55 if it's going to be for one screen, two screen, or three screen.
00:12:57 I can say what's available in the Context Menu. I can change the font sizes,
00:13:02 so here, I want to change it to be a little bit bigger. I can also change the way navigation is
done,
00:13:08 so enable or disable the swipe right, swipe left. We save it. I'm going to assign a topic
name.
00:13:20 Now I'm going to go preview it. This is the runtime version of the Digital Boardroom agenda
00:13:31 that we just created. For best results, we highly recommend using a 4K screen.
00:13:36 In this case, it's a 4K, 86-inch screen from LG, connected to an external laptop
00:13:41 where the graphics card can push 4K. So here, you can see we have more structure
00:13:47 in the agenda as compared to the presentation, which is more free-flowing.
00:13:51 So to start, we're going to navigate to the Overview and see, across the top, the stories that
we created.
00:13:57 All of this content is fully interactive. I can navigate between the stories
00:14:01 by tapping on the navigation or swiping or tapping on any of the tabs in here.
00:14:08 I can look further into the details during my meeting by tapping and holding, bringing up the
Context Menu,
00:14:15 and then, I can see the details. So here's the Details page,
00:14:20 and this is going to launch, in this case, a list of revenue.
00:14:24 It could be a list of transactions. It could call out to an external system.
00:14:28 I can change filter values here. This is all interactive again.
00:14:31 I can change to Gross Margin. I can swipe up, I can tap and look

10
00:14:39 at a particular piece of information. I can drill down.
00:14:42 Again, fully interactive based on the story content that we've created.
00:14:47 Now once I'm done looking at this, I can close the Details window
00:14:51 and go back to the Agenda Builder to continue on with the next topic.
00:14:56 So here, we have the second topic, so we'll click on the HR topic,
00:15:01 and again, the story information that I had before shows in the Digital Boardroom.
00:15:08 All the content, again, continues to be fully interactive, and now, I can continue on with my
presentation.
00:15:14 Then once I've done this topic, I go back to the Agenda Builder,
00:15:18 and any other topics that I've added will show up here. In this example, we're going to show
the mobile app
00:15:25 displaying one of the stories that we created in the previous exercise.
00:15:30 So here, first, we're going to log on to our Analytics Cloud tenant.
00:15:36 I'm going to put in my username and password to log on to the system.
00:15:40 You can replace it with your own username and password there. And once we've logged on,
00:15:44 we see the list of stories that are available to me. Only the responsive layouts will display
here
00:15:50 my list of stories. So I picked the first one, the Chapter 13 Designing Mobile,
00:15:55 and up comes the story. Now I choosing to zoom in to one of the stories here,
00:15:59 the Annual Salary by Office Location, tapping on one of the bars to see more details about
it.
00:16:05 Then I go back to the story. Any of these,
00:16:08 any of these bar charts are interactive. I can also switch to different pages within the chart.
00:16:14 And if I want to do some annotations, for example, draw a circle around that
00:16:18 and then share it with one of my colleagues, I can do that within the mobile app as well.
00:16:22 The mobile app supports both iPad and iPhone, both on iOS. And here, we're going to
change from a different measure.
00:16:32 We're going to change from Sales Revenue to Gross Margin. You can see the story
updating and the data changing.
00:16:38 This'll be the same data as what you see in the Web application story.
00:16:43 Next, I'm going to switch over to one of the Digital Boardroom presentations that we made.
00:16:48 I'm going to open up the Transactional Overview, see the chart and the table.
00:16:52 You can see it looks a little bit different. The charts are the same.
00:16:55 The table's the same, but the layout is a little bit different
00:16:58 on the iPad than what it is on the screen because of the available real estate.
00:17:02 Next, I'm switching over to Human Resources, here opening up the third page, the Salary
Overview,
00:17:08 and then, seeing the content that's available on my mobile app.
00:17:13 In this session, you learned about Digital Boardroom and Mobile as part of the SAP
Analytics Cloud,
00:17:18 and how the viewing experience is unique to the form factor in which you're viewing it.
00:17:23 You learned the difference between a presentation and an agenda
00:17:27 and when to use each of those. You also learned how to connect
00:17:31 the SAP Analytics Cloud mobile app to your stories and presentations.
00:17:36 In the next session, we'll learn about advanced data modeling.

11
Week 2 Unit 4

00:00:06 Hello and welcome to this unit on advanced data modeling. Models in SAP Analytics Cloud,

00:00:11 are really the foundation for data discovery. They are a representation of business data
00:00:16 of an organization, and depending upon your use case, you'll find different types of models
00:00:21 in SAP Analytics Cloud. In week one, unit three,
00:00:26 Jacob dragged and dropped a spreadsheet onto the home screen of SAP Analytics Cloud
00:00:31 and started to do some data exploration and build this story.
00:00:35 That with the cloud workflow will generate what we call an embedded model.
00:00:40 Embedded models are a type of particular story and they can't really be consumed in
multiple stories.
00:00:48 Public models, on the other hand, can be consumed in multiple stories
00:00:52 and are visible in the files area of SAP Analytics Cloud. Typically someone in IT or a power
user
00:00:59 will create the public model for consumption via the broader user community.
00:01:05 It's also entirely possible to publish an embedded model as a public model
00:01:10 so it can be consumed in multiple stories. There's also the concept
00:01:15 of what we call analytical and planning models. Analytical models are used for BI workflows.

00:01:22 And as the name implies, planning models are used for planning scenarios.
00:01:27 Planning models extend analytical models and give you more control over your data,
00:01:32 such as setting up budgets and forecasts, creating your own versions of that data,
00:01:38 copying and pasting data. You'll get to learn more about planning models
00:01:43 in week four. In addition, there's also the concept
00:01:48 of acquired and live models. Simply put, when a model's built on data
00:01:53 that's acquired into SAP Analytics Cloud, that model is an acquired data model.
00:01:59 In this case, the model not only contains the business semantics, but also the data.
00:02:06 Planning models are typically acquired data models, because users will want to attract with
the data,
00:02:12 create their own versions, copy data, and so on. Live models, on the other hand,
00:02:17 are a representation of semantics already defined in the source system,
00:02:22 and do not contain any data. The focus for this unit
00:02:25 is on building an acquired, analytical data model. I'll be covering live models in the next unit.

00:02:32 So let's take a look at how you can actually build an acquired analytical data model.
00:02:39 So on my screen here, I have a spreadsheet open, that I'll be using for building the model.
00:02:46 So on the spreadsheet, I've got several different columns, Right, so you can see the
employee ID here, first name,
00:02:51 last name, and some additional attributes for those employees.
00:02:56 And also, their office location. So got employees in about five different
00:03:02 office locations at the moment. In addition to that, I've got their age
00:03:06 and their annual salary as well. If I scroll down, you can see the number of records
00:03:12 that I have in here. So I've got several different employees in this spreadsheet.
00:03:17 For this employee, i172, their salary is about $150,000, okay?

12
00:03:25 Then if I go in, I also have another version of this spreadsheet, which has some additional
information in it.
00:03:32 So in this spreadsheet, for that same i172 employee that I showed you just a little while ago,

00:03:38 the salary for that employee now has been raised to $200,000.
00:03:42 Pretty nice chunk of change. I've also added some additional users.
00:03:48 So I happened to open up another office in Vancouver and I hired a few employees in that
region.
00:03:54 So now I also wanted to bring those new employees into my model, as well.
00:04:00 The third file that I have is this lat-long file. So this latitude of...
00:04:06 so the city field basically represents the various locations where I have my employees
00:04:11 and lat-long represents the associated latitude and longitude values for those cities.
00:04:17 So what I'd like to start off with is loading up my first file,
00:04:21 which does not have the Vancouver data in it, okay. So one thing I wanted to do is
00:04:27 show you first quickly how you would create an embedded model.
00:04:32 So you've seen this before already. So I could simply drag and drop this file
00:04:36 onto my home screen here. And at that point, the product's going to start loading up
00:04:42 that data behind the scenes and start to go into the screen,
00:04:45 where I can go in and do some additional data I'm doing. So as the data's being loaded
here,
00:04:51 I can go in and start to create my charts and whatnot, if I wanted to. Or I can start to do
some of the cleansing work
00:04:58 that you've seen already. We're now going to go through the process
00:05:05 of building a model, using an embedded model, but what I wanted to show you is
00:05:09 this Publish Model option that's available. So once I've gone through and I've done
00:05:13 some data cleansing of the model, I've maybe built a story on it,
00:05:17 I want to share this model with additional users. I want other people to actually consume this
model in their stories.
00:05:23 I can use this Publish Model option as a way to expose this to other users.
00:05:27 So other stories can be built on top of that model.
00:05:31 The other workflow that you can use to create an embedded model is this Create Story
workflow.
00:05:37 So if I go into "Create", "Story", and I go into the option of...
00:05:41 maybe Access and Explore Data again. Choose option data uploaded from a file.
00:05:48 Even in this scenario, the model that would be built
00:05:51 would be only tied to this specific story and will be an embedded model.
00:05:56 But that's not what we're going to be doing today. So what we're going to do today is
00:05:59 we're going to go ahead and build a model from scratch. So we will create a model.
00:06:06 So this is not going to be an embedded model, this will be a public model.
00:06:11 In order to build my model, I've got some files, so the same spreadsheets
00:06:15 that I was showing you earlier. I've uploaded those spreadsheets to Google Drive.
00:06:21 So you can see the ways... different data sources that we can connect to.
00:06:23 So you can obviously import a file from your computer, but there are a wide variety of data
sources
00:06:28 that are available for building your models, or acquiring data to build models.
00:06:33 There are several different SAP applications. So if you've got SAP BW, you can use BEx
queries

13
00:06:39 and connect to those BEx queries and start to query that data. Bring it into SAP Analytics
Cloud.
00:06:45 You can also connect to, for example, your BI platform, Universes, and also leverage the
logic
00:06:51 that you already have in those universes and acquire the data into SAP Analytics Cloud.
00:06:56 For today, as I mentioned before, I want to use the Google Drive option.
00:07:00 So I'll connect to Google Drive, and I've already got a connection to my Google account,
00:07:09 and I want to pick my HR employee salary information. We'll use the first rule of the
spreadsheet
00:07:16 as the column headers, and at this point the product's going and reading that file
00:07:21 and starting to bring that data into SAP Analytics Cloud. Once that data is brought in,
00:07:26 I can click on that data set and I will start to go through the process
00:07:31 of loading that data and getting me to the page, where I can do some additional data
wrangling
00:07:35 on that data set. One thing that's kind of cool here is
00:07:40 obviously I'm looking at this in a grid view at the moment. So I see all my different columns
and different measures
00:07:46 that I have, but I can also go into this card view, and this is a pretty nice way
00:07:52 of looking at your data as well. One of the things that's nice here is,
00:07:58 if you have a lot of dimensions and measures, say 50 or 60 plus dimensions,
00:08:02 it's kind of hard to see that in the column mode, or in the grid view.
00:08:06 So it's easier to look at that information in this grid format.
00:08:12 One thing you will also see on here, is this quality indication.
00:08:16 So if I had data that was not correct, or if I had some missing data
00:08:21 for some particular dimension, or some measure, I would see this green bar here change
into a red color,
00:08:27 to indicate that there's some quality issues with that data, and I would need to do some
cleansing of it.
00:08:34 So let's go back into the grid view again. So I'm going to start to do some manipulation
00:08:39 of the data that I have here. So let's take a look at this first name and last name,
00:08:43 and what I would like to do is I want to combine these two together,
00:08:46 so I have just one employee name. And I can use the concatenation option,
00:08:52 to start combining these things together. So then I have a...
00:08:56 And I can bring in this to Employee_Name. Other things here, if I look at this Department
field,
00:09:09 I can see the greatest values for this dimension. So I can see that my engineering
department
00:09:16 has 37 employees, and you could see the other departments that I have as well.
00:09:21 But one thing that's kind of amiss here is this sales manager that's showing up in my
department.
00:09:27 Obviously, I don't have a department called Sales Manager. So really this should be
changed to Sales.
00:09:32 So if I click on this, I can actually do some data cleansing here
00:09:36 and I can use the transformations that are available within this interface
00:09:42 to change the values for the dimension numbers. So do a create...
00:09:47 what I would like to do is replace this value with Sales.
00:09:52 So instead of having Sales Manager as a department, I'll have Sales as a department.
00:09:58 As I do that, you'll see that column values should get updated with Sales.

14
00:10:05 A few other things that I want to show you on this interface here is...
00:10:09 let's look at this Annual Salary column here. So at the moment, because I have strings
inside here,
00:10:16 this is showing that this is actually a dimension. What I would like to do is actually turn this
into a measure.
00:10:21 But before I can do that, I need to basically strip out the numeric value from this data set
and do a bit of transformation on this.
00:10:31 So to do that, I can go in here and do another... create a transform on it, and what I'd like to
do is
00:10:38 I want to use the extract option. So when I basically extract a numeric value
00:10:42 between the dollar sign and the USD, so what I will do is I'll use the "between" option here,
00:10:50 and let's... the first value it's going to look at is the dollar symbol, and then the USD, and
that should be it.
00:10:59 So now you can see I have a new column called Annual Salary that doesn't have the dollar
symbol in front of it,
00:11:06 or the USD at the end of it. So I no longer need my first column.
00:11:10 I can actually delete this column, because I've already got one that I would like to use.
00:11:15 Now I can turn this into, rather than being a generic dimension,
00:11:19 I can turn this into a measure. Let's do the same thing with the Age column.
00:11:25 I'd like to have the Age column as a measure as well, instead of a dimension.
00:11:32 It should be pretty much good to go here. One other thing I wanted to show you was
00:11:35 how you can actually create calculated dimensions in this. So when I use this formula option
here
00:11:40 and build a new calculated dimension that basically looks at the employee salary
00:11:47 and classifies those employees. So I'm going to call this SalaryClass, I guess.
00:11:56 We'll use the if-then logic here. We'll look at the employees' annual salary,
00:12:01 So if you hit the square brackets key, you'll be able to look at all the different dimensions
00:12:05 and measures that are part of your model and you can start to pick from those.
00:12:09 So we'll look at the annual salary. And if that annual salary is, let's say,
00:12:14 greater than 50,000, I want to call, or I want to classify that employee as level one.
00:12:23 For everyone else, it's level two. Obviously, I can add some more logic to this if I wanted to,

00:12:32 but for our purpose, this is sufficient. So I can do a preview of the data set.
00:12:38 So I can see what it looks like. So any employee that has a salary of over
00:12:42 is level one and anyone that's less than 50,000, is classified as level two.
00:12:47 So now I have a new calculated dimension in my model, that I can use as well.
00:12:53 So I think I'm good to go at this point. So I'm going to go ahead and create my model.
00:13:05 I can save this model in one of the folders and you can give it a name as well.
00:13:16 So at this point, the system's going through and creating the different dimensions and
measures for me.
00:13:28 My model's now been built. So by default, you'll be going
00:13:31 into this Data Management view. We'll come back and explore this in a little bit,
00:13:35 but I want to show you what the model looks like. So within the modeling interface,
00:13:39 you'll see various different dimensions that were part of our original data set.
00:13:45 One of the things that's kind of neat here and sort of unique is this account dimension.
00:13:49 An account dimension really is more of a planning concept. So typically in planning,

15
00:13:54 you would have several different measures representing maybe your income statement
measures,
00:13:59 and they will all be showing up under the account dimension. So whenever we have a
measure in SAP Analytics Cloud,
00:14:05 it will show up in the account dimension. So in our case, we have two different measures,
00:14:10 age and annual salary, and you see those here. So let's look at this annual salary measure.

00:14:17 I can look at some details about them, I'm sure I can rename it if I wanted to, as well.
00:14:21 But there are some additional options here. We'll explore some of these in a little bit here,
00:14:25 but you can change the scaling factor, you can change the decimal places, and so on.
00:14:29 You can also set thresholds here, if you wanted to, on those measures.
00:14:34 If I set the thresholds at the measure level in the model, they would be applied to any stories
that use that model.
00:14:43 So instead of doing it at the story level, as you've seen in the previous weeks,
00:14:47 you can also set thresholds at the model. Let's take a look at the dimensions as well.
00:14:54 In the dimensions, so you can see the various different dimensions, so let's look at the
Department.
00:14:59 You can see the different values that were part of the departments that we have.
00:15:04 And here, if you look at the properties of the dimension, we can do some things like data
access control.
00:15:10 And if I turn this option on, basically what this will allow me to do is
00:15:14 determine which users can read data from those particular dimensions.
00:15:18 So I can control both read and write access to that dimension.
00:15:22 And write access is only available for planning model, but for an analytical model,
00:15:25 we would just use the read access option to control which users can see
00:15:29 which data from that dimension. All right, at this point, pretty good
00:15:38 to go ahead and start building my model, if I wanted to, or start building my stories rather,
00:15:42 if I wanted to, but one thing I also want to do is, now that I have my model built,
00:15:47 I forgot to bring in the latitude and longitude data. So if you remember correctly from the
Excel file
00:15:53 that I showed you, I had a separate Excel file that had the lat and long values
00:15:58 for the different cities where I have my employees. So I want to bring that in as well.
00:16:03 So one of the things you can do is, even after you build your model,
00:16:06 you have the option to rebuild your model. When I click on that, it tells me
00:16:11 what that rebuilding will do and what kind of objects it will impact.
00:16:15 So if I build several different stories on top of this model already,
00:16:19 rebuilding will impact those stories potentially, so you want to be careful about,
00:16:24 or understand at least, which stories would be impacted by that. All right, let's click OK here.

00:16:34 So what I want to do now is I want to bring in that second data set
00:16:37 into this model as well, all right? So what I can do is I can use this combine option
00:16:44 and I want to get data from a data source, select my Google Drive again.
00:16:50 We'll select the Google account that I have. I want to bring in my latitude and longitude data
set.
00:17:02 So as I do that, as the system's importing the data, what I will see is those two additional
columns
00:17:08 now being listed in my column, or in my data set. But before I see that, what I would need to
do is

16
00:17:15 I would need to link these two data sets together, based on some common dimension.
00:17:20 So in my case, the city represents the different locations where I have my employees.
00:17:26 So I want to use that city field and in my original data set,
00:17:31 it was the office location that had the different cities
00:17:35 where I have employees. So now that I've done my linking,
00:17:39 I can also change how I do the joins between these two data sets.
00:17:45 I can look at the... do a left join, or I can do an inner join.
00:17:49 For my purpose, I'm going to leave it as the default. So let's combine these two together.
00:17:57 All right, so I should see the two columns that were in the secondary data set
00:18:02 that I just brought in show up here. So now I can do a few more things.
00:18:06 I can actually go in and do some geo- enrichment. All right, so I can look at my office
location
00:18:11 and I can go in and build a geo hierarchy based on coordinates.
00:18:17 So let's look at... we'll leave the name as default. The location ID is going to be our office
location.
00:18:24 We'll use the lat-long columns to determine the hierarchy,
00:18:31 the geo-location for those office locations. So let's click on Create.
00:18:40 A few other things that I want to do here is I want to also build the level-based hierarchy,
right?
00:18:44 So if you look at my columns here, I've got my offices in two regions -
00:18:51 EMEA and North America - and in different countries within those regions and I've got
different cities.
00:18:57 This is a natural geographic hierarchy that I would want to show my data in.
00:19:01 So I can actually build a hierarchy as well, a level-based hierarchy.
00:19:06 We'll call this office hierarchy. Usually you'll build this from the bottom up.
00:19:15 So at the bottom, the bottom dimension would be my location. The next one would be my
country, and then the region.
00:19:26 If you do end up picking these in the wrong order, you can move these things around as
well if you wanted to,
00:19:31 but for us, it's good. I will have a level-based hierarchy in my model as well,
00:19:38 that I can use to build my stories. So I can actually then drill down on that hierarchy.
00:19:44 There's also this transpose option that's available. This is useful if you want to pivot your
data set,
00:19:51 and alter, basically, your rows into columns and vice versa. So that's something you can
use
00:19:57 with some specific types of data sets. It's not going to be useful for what we're trying to do
here,
00:20:01 but just be aware that this is also an option that's available for you.
00:20:06 All right, so I'm pretty much ready to rebuild my model here.
00:20:08 I think I'm good to go. So I'm going to go ahead and click on the rebuild model option.
00:20:13 Before I do that, let's go ahead and delete these additional columns that I have, that I don't
really need.
00:20:19 So this latitude column that I have in here, I don't really need that anymore,
00:20:23 because I've already built my geo-location. So let's delete this column,
00:20:28 and we'll also delete the longitude column as well. So let's go ahead and rebuild our model.

00:20:52 So the model's now been built and it again takes me back to the Data Management view.
00:20:56 So let's go back to the modeling view again. We can see the additional dimensions

17
00:21:01 that were there, so let's look at this office location again. We'll see that the office hierarchy is
now here.
00:21:09 We would also see these additional custom properties that indicate that we've done some
geo- enrichment
00:21:14 on this dimension. All right, so what I want to do here
00:21:18 before I start to build my stories is go into this account dimension again,
00:21:23 and I want to add some additional measures that were not really part of my original data set.

00:21:28 So one thing you can do is you can click on the plus button here and add some measures.

00:21:33 So what I would rather do is I would look at the average age of the employee.
00:21:39 So instead of looking at the age as a sum, which doesn't really make sense,
00:21:43 you don't really add ages together, I want to look at the average age of the employee.
00:21:48 And that's where this exception aggregation comes in quite handy.
00:21:52 All right, so I want to build this on my age. I want to look at the average age of the
employees.
00:22:05 Average age. I want to look at... so the aggregation
00:22:10 that I want to use here is average (AVG) and I want to calculate it on the employee ID
dimension.
00:22:20 So whenever you do exception aggregation, you always have to select a dimension
00:22:25 that you want to work on. So again, this is going to give us that average age of the
employees,
00:22:31 and you'll see what this will look like later when I build a story on top of this data set.
00:22:36 I'm also going to add one more measure, let's call it count of employees.
00:22:46 In this case, the formula's just going to be number one, because I just really want to
00:22:52 count the different employees that I have. The aggregation type, or the exception
aggregation type rather,
00:22:57 for this would be count. Again, I want to work off of the employee ID dimension.
00:23:07 So now I have two additional measures that I can use. So this exception aggregation
workflow is quite handy
00:23:12 if you want to build some additional measures in your model. Again, these measures that
you build in the modeler
00:23:20 will be available for any story that's using this model. So a lot of the stuff that I just showed
you
00:23:25 in building these custom measures, is also possible in the story workflow
00:23:28 that Jacob covered before, but for our purposes,
00:23:31 you can also build these in the modeler. So let's save this.
00:23:40 We'll go and build a story on top of this. Let's add a canvas page.
00:23:50 I'm going to add a table first. We'll use our model that we just built.
00:24:09 Let's look at all the different measures. So right now, I'm just looking at the age measure,
00:24:13 but I want to look at all the other measures that I have, including the ones
00:24:16 that I created in the modeler. So I click OK, and we'll add a couple of dimensions to the
rows.
00:24:21 So let's look at Department, or let's look at Office Location and maybe Department.
00:24:30 So I can expand this. All right, so one of the things that I did earlier
00:24:38 was build that office hierarchy, right? So I can start to expand this now
00:24:42 and I could start to drill down into the different regions
00:24:46 and get a look at the employees that I have in the various different regions.

18
00:24:51 So one thing you'll notice is that is in Canada I only have one office, which is Toronto.
00:24:57 If you'll remember correctly, I do have that additional data set
00:24:59 that I want to bring in later, which has employees in Vancouver.
00:25:02 So we'll see how this chart, or this table, gets updated when I bring in that additional data
set.
00:25:09 One other thing you'll notice, is this age measure here, right?
00:25:13 So it's really basically aggregating all the ages for the different employees
00:25:19 that I have in these different departments, and obviously that doesn't make sense.
00:25:23 Really you want to be looking at the average age for the employees, and that's why I built
that average age measure,
00:25:29 using that exception aggregation option that was available in the modeler.
00:25:33 We also have the count for employees for the different departments.
00:25:37 So what I'm going to do is I'm just going to remove the age measure here, because it
doesn't really make sense
00:25:42 to have that in our analysis. Let's take that off, and I have a story
00:25:49 that I can build on top of that model. Let's add one more chart on here.
00:25:54 We'll add geo visualization. Just to highlight that the enrichment that I did,
00:26:00 that geo-enrichment that I did earlier, we can see our different offices,
00:26:04 that I have in different locations on a geo-map as well. So let's go in and select our model
one more time.
00:26:14 The location dimension that we created earlier, and maybe we'll look at annual salary of the
employees.
00:26:21 So you could see the different locations and these bubbles represent, or the color of the
bubbles
00:26:27 and the size represent the annual salary of the employees. Rather the color, actually,
represents
00:26:34 the annual salary of the employees. So I've got these five locations
00:26:38 that I had in my original data set. So let's save this story.
00:26:45 I'll give it a name HRDemoStory. I'm going to save it in the same folder,
00:26:54 where I saved my model. There we go.
00:27:02 We should have a story that's saved now. The next thing I'm going to do now is
00:27:05 I want to go in and bring in that other file that had some additional data in it,
00:27:10 and show you how you can actually refresh the data in the model.
00:27:14 All right, so we'll go back to our modeling workflow again.
00:27:20 Let's go into our folder where we created that model. We'll open up that model, but before I
do a refresh
00:27:29 of the model, one thing I want to do is I want to upload the updated version of that file
00:27:34 to my Google Drive. So here I'm going to load up a newer version
00:27:39 of that file that I have. So it's the HR Employee Salary,
00:27:45 this is the one that has the updated information. So once that's done, I can go into the Data
Management view
00:27:56 of the modeler to start to do updates to my model, or update the data in the model, rather.
00:28:04 So if I go into Data Management, there are several different options here,
00:28:08 right in the scheduling. So if I click on my original file,
00:28:11 I can see that I can set my schedule based on a repeating schedule if I wanted to.
00:28:17 So if my models of my data set are getting updated on a regular basis,

19
00:28:22 I can bring in that additional data set into the modeler, based on some schedule that I've
set.
00:28:29 For my case, I don't really need to do this. In addition, you'll see different settings here for
data import,
00:28:35 and a lot of these settings are quite unique and they do different things when you use them,
right?
00:28:41 So this update option, what this will do is it will add new members.
00:28:47 So in my case, because I had that Vancouver data as part of my dimension that I want to
bring in,
00:28:53 it will add that, and it will also update additional fact values,
00:28:59 or additional measures that were in the model, right? So if you remember correctly, I also
had
00:29:04 updated the salary for one of the employees in my Excel file.
00:29:10 So I want that new salary to be reflected in my model. That's what this update option will
allow me to do.
00:29:16 The append option is used if you want to append more data to your existing data set
00:29:22 that you already have in your model. So this is quite handy if you were saying,
00:29:26 maybe connecting to a BEx query, for example and you maybe brought in data into the
modeler
00:29:31 for one year, and now you want to refresh that model with data for the next year.
00:29:36 You could have some sort of a query filter in your query. Then you just change the date for
the query filter
00:29:44 and only bring in the data for that other year that you want to bring in. That will append the
data
00:29:49 to the existing data that's already in the model. The other two options, "Clean and replace"
00:29:55 and "Clean and replace subset of data", are really just only working with the fact data, right?

00:30:01 So this is just going to be updating the different facts, or the measures that you have in your
model.
00:30:09 This "update dimension with new values" is important, right? So because I want to bring in
those dimension members,
00:30:16 Vancouver in my case, I want to really have this option checked on here as well.
00:30:22 So those are just a few of the options that are available in the modeler, in the scheduler
rather.
00:30:27 So I want to do a refresh of this now. And as I run this, this is actually hitting the
spreadsheet again,
00:30:34 and it should be bringing in those additional several rows that I added to my data set.
00:30:44 All right, so my data's been updated. I can look at the status of both of my schedules,
00:30:49 it's refreshed both my latitude and longitude file and also my HR_Employee data set that I
brought in.
00:30:56 And we also saw a message where it said that it brought in 179 rows, all right?
00:31:03 So I can go into the modeler again and I should, if I look at my office location,
00:31:09 I should see the Vancouver data in here now, with the Vancouver member in here for that
dimension.
00:31:17 Let's go and take a look at our story one more time. One thing you'll notice right away is,
00:31:29 in the office location here, I have now a value for Vancouver in here as well.
00:31:35 In addition, if I look at my geo-hierarchy, or my table here, I have some data for Vancouver
in here as well.
00:31:45 I can also show you that the salary for that one employee, where they got a pretty nice
raise, a $50,000 raise rather.

20
00:31:53 I can also show you that the measure, or the value of the salary for that particular person,
00:31:58 should also be updated here as well. So I'm just going to change my table structure
00:32:03 a little bit to look at the different employees. So let's, instead of looking at
00:32:08 office location and department, let's just look at the employee ID dimension.
00:32:14 Right, and we'll do top n on this, just so we can see the top few employees in the...
00:32:25 Let's look at the top 10 employees. We want to do it on annual salary.
00:32:37 So you can see that employee ID i172 now has a salary of 200,000.
00:32:42 So that's how you can actually update your model data, also bring in additional data into the
modeler,
00:32:48 combine your data model, even after you've rebuilt the model once already,
00:32:53 to bring in additional measures, additional dimensions that you want to bring in.
00:32:58 So let's flip back to our presentation. So in this unit, you learned the different types of
models
00:33:05 that are part of SAP Analytics Cloud. You also learned how to wrangle data,
00:33:09 so that was where you went in and cleaned and made changes to the data set in the
modeler.
00:33:16 You learned how to build a model and enrich the model by combining data from another
source, as well.
00:33:22 In the next session, we'll learn about, we'll see how you can build an SAP Analytics Cloud
model
00:33:28 on top of a live source like SAP HANA. I look forward to seeing you there.
00:33:32 Thank you.

21
Week 2 Unit 5

00:00:05 Hi, and welcome to this last unit of week two. So up to this point in the course
00:00:09 we've looked at data import scenarios with SAP Analytics Cloud,
00:00:13 and in this unit we're going to switch gears and look at live data connections,
00:00:17 with a focus on SAP HANA. So one of the key benefits of live data connections
00:00:22 is that there's no need to replicate data into SAP Analytics Cloud.
00:00:27 So in the previous unit I imported data from a spreadsheet, defined my dimensions and
measures,
00:00:34 and also discussed how data access controls can be defined in the model.
00:00:39 There's no need to do that with live data models because we leverage the existing data
model for analysis.
00:00:46 So as I mentioned in the previous unit, a live model in SAP Analytics Cloud is a
representation
00:00:51 of a model that's been defined in the source system. So this also means that we can
leverage
00:00:57 the authorization framework that's been set up in that source system.
00:01:02 So there's no need to define data access level controls in the modeler in SAP Analytics
Cloud.
00:01:08 In addition, the data is live, so the stories always show up-to-date information
00:01:13 as soon as I open or refresh that story. And if you remember in the previous unit,
00:01:18 I had to schedule a refresh of the import data model to populate it with updated data.
00:01:23 I don't have to do that for live data models. Now at the moment we support HANA, BW,
S/4HANA,
00:01:30 BPC, and universes for live connections out of the box. Third-party data source support is
possible with partner solutions.
00:01:38 Customers can also leverage HANA's smart data access capabilities
00:01:42 and use virtual tables that come from third-party sources to build HANA views, and this way

00:01:48 live connections to HANA can be used to connect to many other sources that are supported
with
00:01:52 the HANA smart data access feature. Similarly, customers can build business objects
universes
00:01:59 and use live connections to connect to hundreds of third-party databases
00:02:02 supported with the universe layer. So let's look at what's possible with live connections
00:02:08 with SAP Analytics Cloud. So for this session, we'll focus on
00:02:12 live connections to SAP HANA. So on my screen here, the first thing I'd like to show you is

00:02:19 the version of HANA system that I'm using. So I'm using HANA 2.0 here, with SP3 on it,
00:02:26 and in addition, I've got the EPMMDS binary installed as well, and you can see the version
of the EPMMDS binary.
00:02:35 So it's important that if you're using HANA 2.0 that you install the compatible EPMMDS
binary.
00:02:43 It's not going to be installed by default, you'll have to go and download this
00:02:46 from the Service Marketplace and install it on your HANA 2.0 system.
00:02:51 In HANA 1.0 system, the EPMMDS binary was installed by default with the HANA
installation,
00:02:58 and that's not the case with HANA 2.0. The version of HANA system and the associated

22
00:03:05 EPMMDS binary also dictate which features are exposed to SAP Analytics Cloud.
00:03:13 So the higher version of HANA and later version of EPMMDS binaries, you'll see that you'll
be able to
00:03:20 take advantage of the latest and greatest capabilities that SAP Analytics Cloud has to offer

00:03:25 for live connections to SAP HANA. So the other thing that I want to show you
00:03:30 are the different models that I will be using for building my different calculation views in
HANA
00:03:36 that I'll be using to build my models in SAP Analytics Cloud later.
00:03:39 So I've got this Pacifica order finance calculation view, I've got this Pacifica shipping info
calculation view here as well.
00:03:47 And if I look at the order finance view first, you can see that it's of type "cube",
00:03:54 that means it's a standard calculation view. And in here there are several dimensions and
measures that are exposed, right?
00:04:02 So I've got some order information, some product information, and so on,
00:04:06 with some measures that are, you know, available for me to do my analysis.
00:04:13 From the shipping info model, I've got some additional information about those orders.
00:04:19 I've got ship date, order received date, and so on. So there are several date fields in here.
00:04:25 So if I look at the ship date field, you can see that it's of type "date",
00:04:29 and this is important because I can use a date field that's coming from my HANA calc view

00:04:34 and that I can build a time-based hierarchy on this date field in the modeler in SAP Analytics
Cloud.
00:04:41 In addition, there is this store field, and also this latitude and longitude field in here,
00:04:47 and this is coming from this table that has been used to build this calculation view.
00:04:53 The reason I'm mentioning this is because I use this store field and this
00:04:58 latitude and longitude field that's in this particular table, and what I've done is I've built
another
00:05:04 calculation view using those fields. And the way I built that calculation view,
00:05:12 not a calculation view but a dimensional view rather, is I basically took the store field from
the table
00:05:18 that's used to build that shipping model, and I used a lat-long, and I copied those values
00:05:25 into a new table, and I basically did enrichment using those lat-long values.
00:05:33 And I use those lat-long values to build the store location dimension,
00:05:37 which is of type "ST_GEOMETRY". So, the instructions on how to build these, you know,
00:05:44 location views or these dimensional views for geo-enrichment are available in the help guide

00:05:52 for SAP Analytics Cloud, so you can find the details there. In this view, this location view
that you see here,
00:06:01 I'll be using that in conjunction with the Pacifica shipping info model,
00:06:07 shipping info view rather, later to build my model in SAP Analytics Cloud, and I'll be
enriching the shipping
00:06:14 info model for the geo-data using this location view that I have here.
00:06:20 One thing to note here is this particular location view is under the special package called
SAP_BOC_SPATlAL,
00:06:30 and this package is where you would store models that you'll be using for doing geo-
enrichment
00:06:38 of your transactional views later. So my Pacifica shipping info and order finance models

23
00:06:44 are my transactional models - they don't have to go under the spatial package, but the
model
00:06:50 that has a location field of ST_GEOMETRY, that needs to go under this
SAP_BOC_SPATlAL package,
00:06:57 so it's available for consumption later when I do geo-enrichment in the modeler in
00:07:02 SAP Analytics Cloud. Right, so other things,
00:07:06 this location view is of type "dimension", so it's not of type "cube".
00:07:13 So just be aware of that as well when you're creating your model,
00:07:15 you make sure you select the category as dimension when you build the model.
00:07:20 So let's go ahead and leverage these models in SAP Analytics Cloud - so I'm going to go
through
00:07:27 and create a new model. In this case we'll want to use "Get data from a datasource"
00:07:35 and we'll use a "Live Data connection" option here, and at the bottom here are the different
data sources we can connect to
00:07:42 to acquire data into SAP Analytics Cloud, so we're not going to be using those,
00:07:46 but we'll be using the live data connection here. And let's select my HANA system.
00:07:53 I already have a connection that I've built to that HANA environment,
00:07:57 so I can leverage that connection, and I can see the different set of views, calculation views,

00:08:03 that are exposed to me in this UI here. So the views that you see here are the ones
00:08:10 that my user ID has access to for that HANA system, so that's the user ID that I use
00:08:16 just to authenticate to the system. So I'm going to use this Pacifica shipping info model,
00:08:22 that's my transactional view, to build a model in SAP Analytics Cloud.
00:08:28 Right, so as soon as I select that model, I basically get a representation
00:08:33 of the HANA calculation view in the modeler interface for SAP Analytics Cloud, and you can
see
00:08:40 that this interface looks quite different than what you saw before when I went through the
process
00:08:44 of importing data from a spreadsheet, and started to build my model in SAP Analytics
Cloud.
00:08:51 I had the ability to do some transformation. I could combine dimensions together and so on.

00:08:57 Those features or those capabilities are not available in the interface for live data models
00:09:02 because we're really just expecting the HANA modeler to actually do that work for us in
underlying source system.
00:09:09 Right so, you don't need to start to join these dimensions together or do some
transformation of the data
00:09:15 in those dimensions because that's expected to be done in the source system.
00:09:20 Having said that, there are still some features in here that are quite useful. So I can start to
hide some of these dimensions
00:09:26 that are exposed from the underlying calculation view. So in this case I've only got a few
dimensions,
00:09:31 but if you have a calculation view with several different dimensions, and not all of those
00:09:36 dimensions are relevant for analysis for a business user, I can just put a check mark next to
that dimension
00:09:42 and hide that dimension from the user. And when I do that, when I try to go build
00:09:47 a story on top of this model later, those dimensions will not be visible for analysis.
00:09:55 So other things I can do is I can also start to group these things together, so I can
00:09:59 create a group called "demo" in this case. And as soon as I type in the group name

24
00:10:05 next to these dimensions, you can start to see that those dimensions are now categorized
00:10:09 under a folder structure, and this also makes it easier for me to then find
00:10:14 dimensions later when I want to build my stories. So that's one way you can just kind of
categorize these dimensions.
00:10:20 I don't really need to do that for my purpose here, but that's available for you if you have
00:10:24 lots of dimensions in your environment. Under measures, I can see the list of measures
00:10:30 that I have in my source system. I get set thresholds on those measures, so again,
00:10:37 if I set a threshold on a measure here in the modeler, any story that uses that model will be
able to
00:10:43 take advantage of those thresholds that have been defined already.
00:10:46 I can also hide some of the measures here, and in addition, I can create or I can use these
00:10:53 scaling options to control the number of decimal places and so on that I have for that
measure.
00:11:00 I can also create calculated measures in here. Just like I created a calculated measure
when I did
00:11:07 import data workflow in the previous unit, I have the option of creating calculated measures
here
00:11:13 in the live data model as well. And I can also use the exception aggregation workflow
00:11:19 to create those measures. A few other options in here.
00:11:24 So under "Model", "Preferences", the view that's used to build this model, I can see that
here.
00:11:35 We'll come back to this Search to Insight option in a few minutes here.
00:11:39 A couple of other things. This Access and Privacy option controls whether the user
00:11:43 is allowed to export data to CSV format from this model. And under the Data and
Performance option here,
00:11:51 I can check this option on, called Optimize Story Building for Performance,
00:11:56 and if I have this option checked on when I build a story on top of this model, that story will
be showing me cached data
00:12:03 until I click on the refresh button of that story. So if you're always expecting to show
00:12:07 the latest and greatest data from your HANA system in your stories, you want to keep this
option turned off.
00:12:14 Right, so that's the model preferences. I'll show you the Search to Insight option in a little bit
here.
00:12:19 The other things you can do is also Change Data Source. So if I have a HANA model built
on top of, say,
00:12:26 my development HANA environment, and I now want to point that model to a calculation
view that I have
00:12:32 in my production HANA system, as long as the model structure behind the scenes is the
same between
00:12:38 these two HANA environments, I'm able to use this Change Data Source feature
00:12:41 to then re-point the model to my production HANA system. So let's do that geo-enrichment
that I talked about
00:12:50 using my location view that I have under that SAP_BOC_SPATlAL package.
00:12:55 So if I click on this icon here, I can select my location identifier,
00:13:00 so in my case the location identifier is coming from my transactional view, which is my
Pacifica shipping model in this case.
00:13:06 So when I use a store field, the location view that I want to use is this workshop store
location view.
00:13:13 So this was the one that was under my SAP_BOC_SPATlAL package. So you can see that
only the views that were under that

25
00:13:20 special package in the HANA environment are the ones that are visible in this UI here.
00:13:28 And we want to use the store ID field that was an allocation view to do the mapping.
00:13:38 So that's pretty much all I have to do to do geo-enrichment of my Pacifica shipping info
model.
00:13:43 Again, most of the work of doing the geo- enrichment is done in the HANA environment,
00:13:47 following the instructions that are available in the SAP Analytics Cloud help guide.
00:13:52 Let's create a time-based hierarchy using those date fields we had in the HANA view.
00:13:57 So I can use this option to create a new time-based hierarchy,
00:14:01 so let's do it on maybe the ship date. And I can define the levels of the hierarchy.
00:14:07 So I can go either year, half year, or month, but I'm going to choose the most granular
option here.
00:14:13 And in this case, when I drill down in this time-based hierarchy, I'll go from year,
00:14:18 then to half year, quarter, month, and day, and so on. And the lowest level of granularity
that's available
00:14:24 for time-based hierarchies in this live HANA scenario is up to the day level.
00:14:32 So, I've created that time-based hierarchy, I can then leverage this hierarchy layer for
00:14:36 doing time-based calculations in my stories. So, I am going to save this model now,
00:14:46 and I'll put it under my public folders, and we'll call this "Demoshipping",
00:14:56 and click OK. So I've done the same process for my finance model as well,
00:15:03 so if I open up my PacificaFinance model here, I went through the exact same steps
00:15:09 that I just went through to build that model. So under Measures, you can see these
additional
00:15:13 calculated measures that I have here. So this discount percentage here is a calculated
measure.
00:15:18 This number of orders is a calculated measure, and it's using that exception aggregation
workflow
00:15:24 to create those measures. And under All Dimensions, I've grouped these dimensions
00:15:30 into some sort of a logical category just to show how that feature works.
00:15:33 And I've also hidden some of these dimensions that I don't need for analysis.
00:15:39 So under Preferences, what I like to show you next is that Search to Insight option.
00:15:43 So Search to Insight is something you've seen already before in week one.
00:15:49 And what this option allows you to do is basically type in your search queries and the
system
00:15:56 will automatically generate a visualization based on your search criteria.
00:16:00 And you can use natural language search to be able to search for, you know,
00:16:05 fields in your models that you have and the system will automatically create the visualization
for you.
00:16:10 So in order to do that, I need to create, basically, an index, or I need to index my HANA calc
view in this case.
00:16:16 And I've already done that indexing for you ahead of time, but I can refresh that index if I
want to,
00:16:24 and this will go through and basically re-index my HANA view.
00:16:28 And this index that's been created here will be stored in SAP Analytics Cloud.
00:16:35 So we'll store the different dimensions and the measures, and the members that are part of
those dimensions as well.
00:16:41 So my indexing is now done, I can save this model, and now I can start
00:16:46 to build my stories on top of this. So let's go ahead and see what's possible
00:16:52 when you create a story on top of a model that's been built on top of a HANA view.

26
00:16:58 So the first thing I'm going to do is use the Search to Insight option.
00:17:02 And this is similar to what you've seen before here, so I can say "show sales revenue",
00:17:09 and as I type things up, I should get a listing of the different models that I have.
00:17:13 I can pick from these models and then I can start to build my visualizations,
00:17:20 and then I can copy these visualizations onto a canvas page in a story.
00:17:24 So I'm not going to do that here. What I'd like to show you is actually
00:17:28 I want to build a new canvas page here, and what I'd like to do is add a chart
00:17:36 using the models that I have in my LiveHANAModeling folder.
00:17:43 So the first thing I like to do is use this Pacifica shipping model that I built.
00:17:48 And this model has several fields in here, so before I start to add measures and dimensions

00:17:54 to create these visualizations, what I want to do is I want to link this field,
00:17:59 or link this model to my PacificaFinance model, and we can do that using this linking option.

00:18:07 So let's add the PacificaFinance model to here, to this UI. And we'll link these fields on a
common dimension,
00:18:20 which is this order number, and we want to do this on... instead of you looking at the
description,
00:18:26 we'll do it on the ID instead. And you can see the values come up
00:18:31 and the join is now defined. So once I click on Set,
00:18:35 now these two models are linked together. I also want to link this Pacifica shipping model
00:18:43 to my model that I created in the previous unit, which was based on acquired data model.
00:18:49 So let's create another model link. In this case, we're now using a live model,
00:18:53 we'll be using the model that I built in the previous session, so which was
00:18:57 this HR_Employee_Demo, and in this case, I'll be using the Employee_Name and Sales
Manager,
00:19:05 and we'll use the employee ID here as well. So what this linking allows me to do, basically,

00:19:12 is use measures and dimensions from these models interchangeably.

00:19:18 So I can pick a measure from one model and a dimension from another model,
00:19:23 and generate a visualization. And this allows me to plant the data between
00:19:28 models in a story within SAP Analytics Cloud. So let's see how this works.
00:19:33 So I'm going to pick a dimension from my Pacifica shipping model, so let's look at Sales
Manager,
00:19:42 and the measure that I'll use is from my finance model, so let's maybe look at Gross Margin.

00:19:50 And I'm going to change the chart type to a tree map as well.
00:19:57 And now let's bring in the dimensions from the employee model that I have that was based
on an acquired data set.
00:20:05 So I'm going to use this option to add a tooltip dimension, and in this case, in the tooltip,
00:20:11 I'll use my HR_Employee_Demo model and I'll use Gender as a field in this model.
00:20:20 And what this is doing is basically really planning the data between those three models
00:20:24 to truly generate the visualization. So as I hover over this data set here,
00:20:31 you can see that I'm looking at both my finance data coming from my finance model,
00:20:37 the Sales Manager information's coming from my shipping model, and this Gender
information is coming from
00:20:42 my HR employee model that I built based on an acquired data set.

27
00:20:47 So this is a pretty powerful feature that allows you to plan data between not just acquired
models
00:20:52 but also between live models and acquired models. So let's add one more page to this story
here
00:21:01 to show some additional features. So in this case I'll add another chart.
00:21:07 We'll use the PacificaFinance model in this case to get started.
00:21:13 And in this case, I want to use the date dimension that was enriched
00:21:19 to a time-based hierarchy. So I'll use the Order Date here,
00:21:23 and we'll look at Gross Margin again. And because this is a hierarchy now
00:21:29 I can choose some levels of the hierarchy, so let's go down to level two by default in the
visualization.
00:21:35 And even in the visualization itself I can then drill down further to the next level.
00:21:40 So at the moment, I'm basically looking at my gross margin for the first half and second half
of 2018.
00:21:49 So, because I have a time-based hierarchy now, I can start to do some additional
calculations in here,
00:21:54 so I can look at my gross margin for the previous year. So this is possible because I had
that
00:22:00 time-based hierarchy in my model. Right, so I'm looking at my... so this dark bar here
00:22:07 is basically representing the gross margin from the previous year, the light one is for my
current period.
00:22:14 So it's only for the second half and the first half of 2018. I can also add variance using that
time hierarchy that I have.
00:22:23 So let's add a variance to this chart as well, and we'll use our Order Date again.
00:22:29 And we'll look at previous year versus current period, and let's change the display option.
00:22:36 Instead of having it as a bar, we'll just add it as a data label.
00:22:40 So you can see that my gross margin in the previous year for the second half of 2018 was
less than what I had this year.
00:22:52 So we're actually on a positive trend here. So now that I have this variance on my
visualization,
00:22:58 I don't really need to see my previous year values here, I can even just get rid of them.
00:23:03 So I can get rid of the previous year measure, and this chart has enough information
00:23:08 based on the numbers that I see here using the variance to give me information on how my
H2 and H1 gross margin
00:23:15 compare to what I had in the previous period for the previous year. Right, so let's add one
more thing here.
00:23:27 Let's add our... let's add another canvas page here,
00:23:34 and we'll build a geo-map, and in this case I'm going to use our
00:23:41 Pacifica shipping info model. So let's go ahead and select our model,
00:23:51 and we have the location dimension that I showed you earlier. So this is a store location
field that I enriched earlier.
00:24:00 And for measures, I don't really have any useful measures in here, so I'm just going to
create a new one just to show that
00:24:06 we can actually create calculated measures directly in the story as well.
00:24:10 So let's build an aggregation and we'll look at number of orders.
00:24:15 And in this case it's going to be a count of dimensions, and we'll count the number of orders
that we have.
00:24:23 Right, so now I have another measure, basically I'm looking at number of orders
00:24:26 based on my store location. I can look at it in its current format,

28
00:24:32 which is a bubble layer, but I can also edit this layer
00:24:35 and look at it using a choropleth layer. And when I have a choropleth layer,
00:24:41 then I can drill down into that choropleth layer as well. Just going to make this a little bit
bigger so we can see this better.
00:24:50 Right, and let's focus on the United States. So because this is a geographic hierarchy,
00:24:57 I can go in and drill down into this, into these fields here.
00:25:02 And let's drill down into the United States, and my mouse has been acting up a little bit.
00:25:10 So let's drill down into United States, and as I drill down you can see that
00:25:16 I'm taken down into the next level in the hierarchy, which is the different states that I have.
00:25:21 So that's sort of the normal drilldown paths that are available.
00:25:27 But other things you can also do when you're using this custom choropleth layer on top of a
HANA system,
00:25:33 is you have the option to define custom drilldown paths or custom hierarchies.
00:25:38 So I'm going to use this custom hierarchy just to show you how this works,
00:25:41 and then we'll talk about how this is accomplished as well. So again, I've got the same data,
same view.
00:25:49 Again I'm going to select United States. So when I drill down here,
00:25:53 instead of going down to the state level, what I'm going down to is basically a custom shape

00:25:59 that I've defined, or custom regions that I've defined for United States.
00:26:03 So I have the western region, I have the eastern region, and Alaska at the top here.
00:26:08 So as I drill down into this eastern region, I also have then further classification,
00:26:16 so either north-east or south-east. And I can drill down into the south-east region
00:26:23 and get down to the state level. So you can see instead of going
00:26:26 from my country to my state, I'm actually going from my country
00:26:30 to a custom region that I've defined in the HANA system. So in order to use these custom
regions,
00:26:36 I really, I need to have basically those shape files imported into my HANA environment.
00:26:43 I need to define these custom regions in my HANA system to be able to leverage what I've
just shown you.
00:26:49 So again, instructions on how you would do this in the HANA system are available for you to
use
00:26:55 on the SAP Analytics Cloud help page. There are also several SAP notes and blogs
available
00:27:00 for you to learn how you can do this. So that's pretty much all I wanted to show you
00:27:06 in terms of the different feature sets that are available. There are obviously other features
that you can leverage.
00:27:12 We don't have time to go through all of them, but they should be sufficient
00:27:16 for our purpose at the moment. So I'm going to flip back to my presentation here
00:27:21 and just close off the session here. So in this module we talked about several different
topics.
00:27:29 We talked about the benefits of using live data connection on top of SAP Analytics Cloud.
00:27:37 We also covered how to build live models on top of SAP HANA, and plan models,
00:27:43 plan between models in an SAP Analytics Cloud story using both acquired and live models.

00:27:49 We also built geo-visualizations and we created time-based calculations using

00:27:55 the time-based hierarchy that was available to us. In week three, we'll have Thierry Brunet

29
00:28:01 go through the Smart Predict features of the product. We look forward to joining you in the
next week.
00:28:07 Thank you.

30
www.sap.com/contactsap

© 2019 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.

The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.
National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable
for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and serv ices are those that are set forth in the express warranty statements
accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality
mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are
all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation
to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from e xpectations. Readers are
cautioned not to place undue reliance on these forward-looking statements, and they should not be relied upon in making purchasing decisions.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trade marks of SAP SE (or an SAP affiliate company) in Germany and other
countries. All other product and service names mentioned are the trademarks of their respective companies. See www.sap.com/copyright for additional trademark information and notices.