Hi, and welcome to the SAP HANA Academy. My name is Julie.
In this series of videos, we're taking a look at the new SAP HANA Express edition.
In the series so far, we've downloaded and installed SAP HANA running in a virtual machine on a laptop.
We have configured it and connected to that SAP HANA database using the Eclipse tools.
We used the Eclipse development perspective to create a schema and create users
and assign some roles and access privileges to those users.
So the next thing we want to do is load in some sample data so we can start to create a model.
There are a couple of different ways that we can load in data.
We're going to do the simplest way in this video
Which is simply to do a File Import.
We're going to do this as SAP HANA content, data from local file,
All we need to do is select our system repository.
We can browse to our local file
We can open up a CSV file
So it's recognized that it's a comma delimited file
We need to tell it whether a header row exists in the file or not.
In my particular file it does, so I'm going to check that box.
Then for the target table, if I tell it to Create a New Table then I want to identify which schema I want it to use.
We created the 'STS' schema in our last video, so we'll use that.
Next, I want to give the table a name, so this is actually our fact table of our customer orders.
if I was adding this information into an existing table instead, then, I could simply pick Existing and select the table.
I will click Next. It's going to go out and read my file,
and it's going to give me my data table definition and some mapping suggestions.
Now it's read through my data in my file,
it's used the header row to identify what the table structure might look like,
it's looked through and determined what the data types would be based on the source file,
and now what I need to identify which of the fields are my key fields
So i'll click product_Id, customer_Id and order_Id, employee_Id,
and Orderperiod_Id to be keys in my new table.
If I click Next, it's going to show me what my data looks like.
If I scroll to the right, I can see all of my different data fields.
If that looks good, I can click Finish.
Now if I refresh my schema,
and look at my tables, I now have a customer order table.
I can right click and do Data Preview.
Here I can see the rows I just loaded into my table now.
It's a really small CSV file, it only loaded 200 rows, but you get the idea of how to load in sample data.
Now I can start to actually look at my data for a reasonability check.
I can look at my unit price, What's my min and max value?
What kind of discounts am I giving?
Do my order periods or my quantities look correct?
I actually have an analysis tab here,
so I could start to actually look at net sales, by order Id etc.
So our data is in our table, but that's only part of our data as that's just our fact table.
Next we want to go ahead and load in a couple of additional tables which are our dimension tables.
Let's go ahead and load those files.
We could do file import
Data from local
into our system
browse for the file, let's pick the product file this time
It's a comma delimited it has a header row. We want it to go into 'STS'.
This is going to be the Product dimension
It's going to look at my file and see my categories. I need to identify which ones are my keys
My product _ID is the key here.
I can click Next if I want to see what it looks like, or I just click finish and it's brought in the data.
Next we can do that for the rest of our files, bringing in our customer file and
Then we can start to actually create our Model or star schema with our dimensions files
This one actually doesn't have a header row. I want it to load into 'STS'.
And this is going to be our dimension Customer table. Click Next.
Here's our customer_ID field which we will make our key field
And we will Click Finish.
So now if I refresh the schema, I should be able to see all three tables.
in our next video, we'll take a look at creating a calculation view which is our data model using those three tables.