Skip to Content

Hello SCN,

In this document, we shall discuss about how to connect to SAP HANA Database and Create a “Information space” using “Explorer” and get the “Geographic Display” of top 3 countries by “Sales Revenue”.

To get the big data as mentioned by Ronald Konijnenburg in his blog http://scn.sap.com/people/r.konijnenburg/blog/2012/02/04/how-to-generate-big-test-data-with-a-little-help-from-sql

So with the help of one of my colleagues named Anish, We generated “BIG DATA” with the help of following tables,

Table: MYDAY:

A311.jpg

Data Preview:

A312.jpg

Table:MONTH:

A313.jpg

Data Preview:

A314.jpg

Table:YEAR:

A315.jpg

Data Preview:

A316.jpg

Table:MYCOUNTRY:

A317.jpg

Data Preview:

A318.jpg

Table: Sales Channel:

Sales.jpg

Data Preview:

PRevi.jpg

Table: BIGDATA:

A321.jpg

SQL for generating data for table BIGDATA:


insert into BIG_DATA
 select
 mycountry.country_name,
 myyear.year,
 mymonth.month_name,
 myday.date,
sales_channel.channel,
PRODUCT_SALES.product,
PRODUCT_SALES.sales_amount
from mycountry,myyear,mymonth,myday,sales_channel,PRODUCT_SALES;

Data Preview:

A322.jpg

Now building an analytic model on table BIGDATA:

A324.jpg

Now we need to create an “Information space” in “Explorer” to explore this “BIG DATA”.

Create a “new” information space and fill the”Properties” as shown below:

A325.jpg

Now define facets and measures as shown below:

A326.jpg

Now as we discussed we need to get this data on a MAP. To do this we need to edit the “COUNTRY_NAME” and make it “Geographic” as shown below:

A327.jpg

Now we need to load the “Values” of our defined country list to map them as shown below:

A328.jpg

A329.jpg

Now we need to define “unmatched” Country names as shown below:

A330.jpg

A331.jpg

Now here we choose a nearby location with the same name as shown below:

A332.jpg

I have flexibility to choose between korea and south korea. Here i choose “South Korea”.

Now we need to check the “unlocalized” list as shown below:

A333.jpg

A334.jpg

A335.jpg

Now i decide to leave the other 2 country names to be “hidden in geography chart”.

Now index the “information space” and explore it. We can see the top 3 countries list as shown below:

A336.jpg

A338.jpg

Thanks for reading this document. 🙂 Please comment your feedback.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

      1. Balaji S

        Hi Krishna,

        This exercise is quite interesting. I am trying to replicate the same but I am facing an issue while configuring the country options. I don’t find the option of edit as in your screenshot. I can just see the below screen in cloudshare explorer page.

        http://tinypic.com/r/wrjdpy/6

        Any idea.

        Thanks & Regards,

        B

        (0) 
  1. Saketh Ram

    Dear krishna.. i really impress for ur blog..so many days onwards iam struggling for SAP- SQL script which plays major role in SAP-HANA..will you please send some imp stuff regarding that one and aslo share some screen shots..

    Thank You,

    Reagrds,

    Saketh

    (0) 

Leave a Reply