Using Analytic View on SAP HANA with SAP Visual Intelligence


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

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?

Comments

Post a Comment

Popular posts from this blog

SAP HANA Input Parameter - Derived from Table - Use Expression in Filter Value

Image
Recently, I have experienced something while modeling HANA information view that I want to share with everyone.  Case:  Dynamic Filter for projection with current Fiscal Year and Fiscal Period.  Method: There are different parameter types that we can use to do this. I decided to use following "Derived from table" type as shown below:  Challenge: When filtering column then it displays list of values from the same HANA information view and we can select the date. Now, as the requirement is current Fiscal Year and Period so how do we filter the column to dynamically select current date in "Filter Value" section? Solution: Like everyone, I expected it to understand the expression. So I tried following and it worked. I used the expression  currentdate() I was aware that I could use expression in the "Default Value" section (as explained in SAP HANA Developer Guide) but didn't expect it to work in "Filter Value".
Read more

SLT Replication Issue Due To Timeout Reading Logging Tables

In our company we use SAP LT (Landscape Transformation) replication server to replicate tables from SAP ECC system to SAP HANA in real time. SLT creates trigger for each table that we want to replicate and whenever there is change it stores the changes in the logging table. Later on, these tables are used to update replicated tables in SAP HANA.    This system is really useful when you really need real time replication to SAP HANA. However, it also causes performance issue if proper monitoring is not being performed. Just recently, we faced an issue where we were trying to replicate a large table "VBFA" to SAP HANA in production environment. Every time table replicate status changes to "ERROR" after the initial load. It started to fail when ever SLT tries to read change/delta stored in logging table. This tables replication worked fine in DEV and QA environment.   After troubleshooting and taking help from SAP support we found that in the program generated
Read more

SAP HANA Content Security Roles Setup

Image
A few months ago I was given a task to implement content security in SAP HANA. The main purpose for this task was to provide Business user access to information models created in SAP HANA. For example Finance user should only view finance package and can access information models in that package via BI tools such as Analysis for excel. So, after a research and few discussions with various people (one of them was from SAP Melbourne) I came up with following security model. Let's assume that content is maintained in following structure: So based on each type of privilege I created the roles as shown below: System Privilege Roles These roles are mainly needed for System admin tasks (technical role) X_HNS = S for System Privilege role Role Name Privilege Type Assigned Privileges X_HNS_USERADMIN This role can create users, change their passwo
Read more