[Music]
SAP Analytics Cloud is a powerful
solution for working with live data from
SAP BW,
but if you're coming from a BW
background, this means jumping into a
whole new environment. In this video
series, SAP Analytics Cloud Global
Product Evangelist Ingo Hilgafort
leads you through some key details on
how to make the transition. Welcome to
the first video on how you can leverage
SAP Analytics Cloud in combination with
SAP BW. We will start with a very simple
BW query, which we can see right now in
the modeling tools. We can see we have a
couple of key figures in the columns, we
have one dimension in the rows, we have
several dimensions in the free
characteristics, and we even have two
attributes for dimension Sold to Party.
In addition to those elements, we also
have three variables, so we have a
variable for Product, for the Calendar
Month and for the Country, so when we
move into SAP Analytics Cloud and we
start building our model, we should
actually find all these elements then in
SAP Analytics Cloud.
So here we are in SAP Analytics Cloud,
and as first step we're going to create
a new model.
We'll choose the option to get the data
from a data source. We use the live data
connection option, choosing BW as a
system type...we choose our connection.
We're getting logged on using single
sign-on and we can now type in the
technical name of our query. In this case,
this is query prompting, and we click ok.
So now SAP Analytics Cloud is going to
generate the model, and here we are. It
shows us the list of measures, it shows
us the decimal places that it was able
to retrieve from our BW query,
and it also shows us the list of all the
dimensions. Now the interesting part here
is that on the left hand side we see the
technical name of the dimensions. Here we
see the descriptions based also on the
language we have been logged in and we
also have the ability to actually group
our dimensions and we have the ability
to hide some of them if we would like. We
can also, if we want to, change actually
the description. As an example, we can
change here and say this is just
calendar month. We could also group, for
example, all our dimensions around
product and create a group called
product dimensions.
I'm just going to copy and paste that to
the other items related to the product...
we'll have customer dimensions,
and we have time. So now all these
groupings we should then actually be
able to find when we start building a
query. On the right hand side, we see the
hierarchy actually shown as well, so just
to give us an idea how it's going to look
like when we build a story.
We also have the ability, in case our
source data does have that information,
to configure a dimension for the version,
in case for example you have data such
as actual, budget, and forecast, you can
configure the dimension here and then
you can choose which dimension members
will be actual, budget, and forecast.
One of the items that you will notice is
that the variables that we looked at in
the BW query are actually not surfaced
as part of the model. The variables will
show up when you create a story, but you
do not see them right now as part of the
model. So now we do have all the
information, well you can just go back to
the measures here, or you can save now
our model and then we can start building
our story. So we're going to click on
Save, choose a folder, we're just going
to say this is our BW model 01
and save the information.
Now that you've created a model based on
data from a BW query, you're ready to
work with that data in the story, which
is covered in the next video in the
series. Please subscribe to the SAP
Analytics Channel to keep up to date
with this video series and other SAP
Analytics Cloud content. In the meantime,
you can learn more about working with SAP
BW and SAP Analytics Cloud by clicking
the link. See you next time!
[Music]