Skip to Content

As a part of (our University unit bco6181 ) six minutes presentation I connected SAP Visual Intelligence to SAP HANA Analytic view and show measure(s) on graph. I demonstrated the whole thing in the class successfully but there were certain things that I could show in presentation. For example, from creating schema to creating and loading tables with data (from csv files). It was another excited thing that I did with SAP Hana and this time l learnt even more about SAP technology. I am going to share my experience and data that I used.


Cloud Setup:

This time I used the same setup which I discussed in my previous blog here and as shown below. I really did not need DC for this exercise as I connected to HANA with database user. However, I used it for DNS (Domain Name Services) and for logging on to CLIENT using Windows Domain user.

SAP Hana Instance – HANADB – Rev 48

Windows Server 2008 R2 – DC (Domain Controller) – and hosted AD (Active Directory) services

Windows Server 2008 R2 – CLIENT  – SAP Hana Studio and Visual Intelligence installed

Source Data:

I completed a unit “Business Intelligence” in Semester 1 2012 from sapvu  In this unit’s final exam, we (group of two) were provided with csv files to create InfoCube in SAP Business Warehouse and then use created InfoCube to do reporting and analysis in SAP Business Explorer (BEx). So I decided to use one of the exam excercise data for my presentation. Data has following

     Dimensions:

     Region (DIMREGION) – Region_NO,Region_Description

     Department (DIMDEPARTMENT) – Depart_No,Department_Description

     Sales Representative (DIMSALESREP) – Sales_RepNo,SalesRep_Description,Depart_No

     Product (DIMPRODUCT) -Product_No,Prod_Description

     Fact Table:

     Order_No,Region_NO,Sales_RepNo,Product_No,Qty_Purchased,Purchase_Price,CurrencyType,Ord_Date

     Measures:

     Qty_Purchased    

     NetSales = (Qty_Purchased) X (Purchase Price)

Steps Performed:

Overview

Created Schema



Created Tables by importing csv files


Created Package to store views

Created Analytic View and connected view to SAP Visual Intelligence

Findings:

I locked my Hana user while connecting with SAP Visual Intelligence. I entered the incorrect password more than 3 times. So I found following sql commands from here

Login to HANA system with admin access (SYSTEM user will do)

Find users with failed attempts:

select * from sys.INVALID_CONNECT_ATTEMPTS where user_name=’ANGADS’

Drop attempts to user:

ALTER USER ANGADS DROP CONNECT ATTEMPTS

Once above commands were performed then I changed the password of my user.

I am Curious to Know:

How do I change the the NetSales data type to show $ and AUD?

Can I create more visuals with this analytic view?

Should I have done it differently?

What are the other views can I create with this data?


To report this post you need to login first.

6 Comments

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

  1. Tammy Powlas

    Well done

    Thank you for taking the time to record and document

    I wonder what security experts will think of your SQL to get around the locked user 🙂

    Keep sharing your knowledge

    Regards,

    Tammy

    (0) 
    1. Angad Singh Post author

      Thanks Tammy,

      Security experts know that it cant be done without the admin access.;-) I have edited the blog. I respect that you believe in sharing knowledge.

      Sincerely,

      Angad

      Share knowledge to gain knowledge

      (0) 
  2. Gerard Wong

    Hi Angad, it was nice meeting you in BCO6181 class last Wednesday.

    I am from SAP Netweaver Process Orchestration & ABAP background. Visual Intelligence with Analytic View on HANA is amazing, it can present data differently in a quick way, unlike the conventional ABAP report (less presentable 😛 ). Thanks for sharing this blog.

    You have also cleverly presented SAP’s cloud computing concept in your use case above. More and more cloud technology will be deployed in innovative ways.

    Excellent work!

    Cheers,

    Gerard

    (0) 
    1. Angad Singh Post author

      Thanks Gerard.

      Please do share your knowledge with us time to time. If anything we can do together for learning purpose then it would be really great.

      Sincerely

      Angad

      (0) 
  3. Joshua Fletcher

    Well done Angad, you’ve used a really comprehensive approach to show the whole process – great!

    Re displaying $, I don’t think Visi can do this currently – and the currency is not possible in Visi itself – you’d probably need to have multiple measures in the Analytic View, one column per currency type.

    You can typically find lots of different ways to visualise the data, but when analysing data, I find the best approach is to tell a story that shows something that might not have been visible previously. And the more dimensions you can add, the more detail you have and the more visible variations are.

    Thanks again for your contribution! 🙂

    Cheers,

    Josh

    (0) 
    1. Angad Singh Post author

      Thanks Josh,

      Now, those are expert suggestions. They are so handy in real world.

      I hope to contribute more and more on SCN.

      Sincerely

      Angad

      (0) 

Leave a Reply