Skip to Content
Author's profile photo Former Member

SAP HANA: Geographic display of “BIG DATA” using “BI4.0 Explorer”

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.

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Muralikrishnan E
      Muralikrishnan E

      Hi Krishna,

      This is helpful.I could able to visualize this feature in our landscape.

      Rgds,

      Murali

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Murali,

      Agreed. And thanks for your feedback 🙂  

      Regards,

      Krishna Tangudu

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      Thanks for you blog.

      Which map is it? Does it works on google maps?

      Author's profile photo Aby Jacob
      Aby Jacob

      Dear Krishna,

      Excellent work , Thanks !!  🙂

      Author's profile photo Rama Shankar
      Rama Shankar

      Krishna,

      Nice blog - thanks!

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Nice article Krishna,

      Regards,

      Vivek