Wednesday 6 January 2016

Extending HANA Live Views

In this blog I will describe how we can extend HANA Live Views

I hope many of you are familiar with HANA Live.
If you are not familiar with HANA Live, then you can refer the below blog:
SAP HANA Live - Real-Time operational reporting | SAP HANA

To extend HANA Live Views we generally make a copy of it and then make changes to it as per our needs.
You can check the document given in the blog mentioned above on how to extend HANA Live Views.

Now SAP has created a new tool called SAP HANA Live Extension Assistant.
Using this tool we can easily extend Reuse Views and Query Views.

Lets start with the Installation of Extension Tool:
First download HANA Content Tools from Service Marketplace and then import Delivery Unit HCOHBATEXTN.tgz


SAP HANA, SAP Certifications
Once this Delivery Unit is installed, we can see the extn folder as shown in the below screenshot.

SAP HANA Material, SAP HANA

It also generates a role sap.hba.tools.extn.roles::ExtensibilityDeveloper and we will need to assign this role to the User to work with this tool.

Now to complete the installation, Go to Help -> Install New Software and click on Add button and enter the details as shown below:

hana, sap, sap hana

On clicking OK, we will see the Extension tool and then we need to install it

SAP HANA Certifications

Once this tool is installed, and we R-Click on any View, we can see the option Extend View.
This option is enabled only for HANA Live Reuse and Query Views and disabled for Private Views as shown below.

SAP HANA, SAP Material, SAP Certifications


We can easily identify Query Views from HANA Studio as they end with Query but we can't distinguish between Reuse and Private Views.
So to know which View is a Reuse View and which View is a Private View, logon to HANA Live Browser and check there as shown below.

hana live view, hana live, sap hana

Lets say that we want to make changes in the GLAccountInChartOfAccounts Reuse View, so we will R-Click on that view and select Extend View and then we will be greeted with the below screen

sap hana, sap, hana live

SAP HANA Live, SAP HANA

It will create a new View with the same name as the Reuse View
Here we will select the package where we want Extended View to be created.
All the fields that are present in the Reuse View are marked as Grey and we cannot change them
On the left side, we get list of all the tables that are used in the View.
These tables only show those fields that are not used in the View
So we can select any field from the table and add it, lets say we want to select SAKAN field from the table, so we will click on SAKAN field and then Click on the + button on right side of the screen, this will add it to our view

hana live, sap hana certifications


Then we will select Next... by default the Join type is Left Outer Join and we cannot change it but we can change the Cardinality of the View

sap hana, sap hana material

On the right side, it shows fields for Join. As the table SKA1 is already used in this View, so it proposes fields for Join, we can either use these fields or add our own fields by selecting + button as shown below

hana live, sap hana certifications


Then we will Validate and Activate the View

The Extended View copies the semantic properties of the Reuse View - if Semantic Node in Reuse View is Projection then in Extended View also the Semantic Node will be Projection

Below is the newly created view.

hana live view

We can also observe one more thing that after installing Extension tool, the Join Node and other Nodes are shown in a more elegant and colorful way

Now lets extend GLAccountInChartOfAccountsQuery  Query View
R-Click on the View and select Extend View, then we will see the below screen

hana live view, sap hana certifications

By default it takes the package in which we extended Reuse View earlier
It shows us those columns which are present in Query View but are not selected in Output

We can also select our extended Reuse View and then its additional fields are also available to be added to the output as shown below

sap hana certifications ,sap hana material

Lets select both the fields and Validate and Activate the View

Both the Views are available inside ExtTest Package as shown below

sap hana live, hana live


Now Lets check out the Extended Query View  and now we can see that both our selected fields are present in the View

hana live, hana certifications

The tool has both its benefits and limitations:

Benefits:

It is a simple tool.
It is easier to extend an existing Query or Reuse View if we just want to add additional Columns from the underlying Tables the View is already using
If we update HANA Live Views later on then out Extended View also get updated

Limitations:

It has many limitations at present

We cannot extend Query Views with Unions and we can also not directly extend Query Views in which Aggregation Node is present at levels other than Top Node(Node before Semantic Node).
At present we can not add fields from other Tables(Tables that are not used in a View) to an existing Reuse View, but hopefully this option will be available in next version
We cannot create Calculated Columns or change Filter options

Source: scn.sap.com

No comments:

Post a Comment