Welcome to the SAP HANA Academy. My
name is Bob and in this series of videos
we're going to be looking at how to
model analytic data within the SAP HANA
Extended Application Services Advanced
model. Which is also known as XS
Advanced. In this video we're going to go
through an overview of the SAP Web IDE.
We'll also look at how to create
projects and SAP HANA database modules.
We'll be focusing on using XS
Advanced for this video series. It’s a
good idea that you have some prior
knowledge of XS Advanced. So you can
get that if you go to SAP HANA Academy.
Do a search in Google and if you go to
our YouTube channel. There's a whole
series on using XS Advanced. If I
scroll down you'll see that we've got a
playlist or a section called
Application Development and Delivery and
within that we have a playlist called
SAP HANA XS Advanced model and we've
got a series of getting started and
overview videos. You only really need to
watch the getting started videos and
potentially the HDI Container and create
using videos. You don't necessarily need
to watch all of these videos to
understand what we're going to do in
this series. Now when using XS
Advanced the main tool that we're going
to use is a tool called the Web IDE. So
the assumption is is that you've already
got a user created. I've got a user
called XSA_DEV and that user
can access what's called a space. So
again if you watch that series of videos
you'll understand how to create that
space and how to allocate a user to a
specific space. In previous versions of
SAP HANA you might have used different
tools to model your various views on
your analytic data tool. Such as the SAP
HANA Studio and the web-based
development workbench in XS Classic.
Whereas in XS Advanced we use
this tool called the SAP Web IDE. Which
is a comprehensive browser-based IDE
for the development of complex
applications comprised of web-based or
mobile user interfaces, business logic
and extensive SAP HANA data models. The
Web IDE is designed to support
developers who use SAP HANA and XS
Advanced and it provides various tools
such as syntax aware editors for code
and SAP HANA artifacts. Graphical
editors for CDS data models and
calculation views. As well as inspection
testing and debugging tools. Now this
series of videos is going to concentrate
on one specific scenario. That scenario
is where users use the graphical editor
within the SAP Web IDE to refine or
slice data in database tables by
creating calculation views that depicts
a business scenario. You can then use
these calculation views for any
reporting and decision making purposes.
To give a quick overview of the Web IDE
what you have essentially is three
different perspectives. A development
perspective. You also have a Database
Explorer perspective. Which gives you the
ability to run SQL like commands on
your various objects and lastly you've
got a preferences perspective. At the
top you've got various options to do
with your projects or objects. On the
bottom this is where we can see log
information or error information and on
the right hand side you've got some
other options to do with various options
to do with development. We’re not going
to really focus on these options. So what
I'm going to do firstly is look at
building the central concepts or the
central objects in order for you to get
to be able to do modeling as quickly as
possible. So that is of course creating a
project and then loading some data. So
what we'll do here in our workspace if
you've done a brand new install you'll
have access to a single workspace. What
we'll do is we'll go and create
ourselves a new project from a template.
So there are
different types of template that you can
use. We’re going to use the default multi
target application project and select
next. Then all we need to do is give our
project a name and I'm going to call
this modelingproject. If you want to
import the data I'm using it's very
important you follow the same case and
also spelling of my object. So that is
modelingproject as one word. I'll then
click on next and essentially what we'll
have is we'll have an ID for that folder.
We'll have an application version and
this is what I mentioned at the
beginning of the video. You will need
access to a single space which you can
write to. So again if you follow that
series of videos within the SAP HANA
Academy on the XS Advanced
model. You'll see how we can create these
spaces and allocate users to them. So I'm
going to write this application or
project into my development space. So
I'll click on next and then I'll click
on finish. So here we can see that
projects been created. So when you go
within a project if I right click now
and select new you have these various
other options because we're going to be
connecting to classic tables in a
database and creating views on them. What
we'll need to do is create ourselves an
SAP HANA database module. I'll select it
and I'm going to give it a name. So again
I'm going to call mine modelinghdbmod.
Again it's very important if you want to
import the data I'm using to follow the
same naming convention. So that's
modelinghdbmod. I'll then select next.
We'll just need to give our schema a
name. Now I'm a Football fan so my data
is going to be concerning football and
then we need to tie this to a specific
version of SAP HANA. I'm using SAP HANA
2.0 SPS 02. You then need to build
these modules after you create them. So
essentially what will happen. It will
build this database module which is
within this specific project.
So I'll click next and then finish. Now
what you'll see at the bottom is that
the building of that SAP HANA database
module has started. We can see the
progress at the top right hand side.
Again this is if you haven't used the
Web IDE before. You see any messages below
or logging about what is being created.
So you can see here it's creating this
files in a specific container and you've
got a confirmation that the module was
successfully created here and also of
course within the logs it's been
successfully created here. Now you can
switch off the console here on the right
hand side and below you can choose to
turn on if there's any problems.
Obviously we've created a blank project,
with a blank SAP HANA database module.
So there should be no issues for now. So
now that we have our SAP HANA database
module if I go within the SAP HANA
database module you'll see that there's
a folder called SRC. These are the
folders these .che folders can be
hidden. So within tools or sorry within
view you can select don't show hidden
files because we don't really need to
see those hidden files. The main one we
want to look at is this SRC folder. Which
is essentially the source folder where
you store your content. So one of the
ways you can create content is by
creating a new object. So you can see
here you've got various different types
of objects. You of course have
calculation views. You have CDS
artifacts if you want to build Core Data
Services. You have analytic privileges.
These are the real ones that relate
to modeling. But an easy way to do this
is to actually load data from a zip file
and I'm going to show you how we do that
in the next video.