Skip to Content

Extending HANA Live Views

Hi Everyone,

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


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


It also generates a role 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:

The path would be http://hostname:80[instancenumber]/sap/hba/tools/extn


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


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.


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.


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



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


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


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


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.


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


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


Lets select both the fields and Validate and Activate the View

Both the Views are available inside ExtTest Package as shown below


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


The tool has both its benefits and limitations:


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


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

Hopefully, this tool will get better with time



You must be Logged on to comment or reply to a post.
    • Hi Mayuresh,

      Go to Service Marketplace -> Software Download Center -> Installation and Upgrades -> Browse Our Download Catalog -> SAP In Memory(SAP HANA) -> SAP HANA Addons -> SAP HANA Content Tools

      Download the zip file from this link and then you will see three SAR files inside it and extract HCOHBATEXTN00_0.SAR file using SAPCAR and then you will get the delivery unit



  • Hi Vivek,

    thx for the great blog.

    Do you have experience for the extension of HANA Live Views not delivered by SAP. As far as I know, the classification if a view is a private, reuse or query view is done by a special SAP tool. A partner for example has not the chance at the moment to make the same classification. He just can do that on an organizational way for the moment 🙁 . So I think the extension tool cannot be used for such views? Or do I oversee something?



    • Hi Florian,

      Yeah, we cannot classify a View and it is not possible to extend a View created by us. It can be used only for HANA Live Views



      • Vivek: This is very helpful blog and you provided the step by step process for extending the view.

        What is your experience with HANA live views? All SAP HANA live views are calculation views (No attribute and analytical views). Is there any reason behind?

        Are we loosing the performance by not creating attribute views and analytical views?

        What is your suggestions on this? Can we go ahead and create only calculation views as SAP created or create standard process attribute and analytical and calculation views.

        Really appreciate your answer on this.



        • Hi Vara,

          We have implemented GRIR App and Working Capital App based on HANA Live and the Customer was happy with the performance. But HANA Live Views may not give you all the information that you require, so you will need to enhance them.

          HANA Live is a standard content and it uses a lot of tables and there are few Query Views that use more than 40 tables and sometimes instead of using HANA Live Views, you can create your own views as your reporting requirements can be fulfilled by 2 or 3 tables.

          To get an understanding of HANA Live Query View, you have to drill down one by one to the Private Views and it takes a lot of time.

          Why only Calculation views are in HANA Live has already been discussed here at SCN. Please read the below thread:

          I would not suggest creating only Calculation Views as in many OLAP Scenarios, Analytic Views will provide better performance then Calculation Views.



  • Hi Vivek – This is an excellent blog. Thanks for sharing.

    Am trying to follow this and am getting the below error while trying to validate the change. The change is quite simple – just choosing an additional field in the MATERIAL view. Could you kindly suggest where might I be wrong.

    An internal error occurred during: “Validating View”.


    Thanks in advance,


      • Hello Vivek,

        Great blog and very helpful. Thanks.

        All the SAP delivered calculation views sit on top of private views and may be some ECC tables ?

        If a customer wants to create his own view, would that require creating a private view ? Can not the attribute, analytic and calculation view directly connect to a table without a private view ?

        Hope you can clarify this.



        • Hi Zain,

          HANA Live is a standard SAP pre-delivered content which contains of only calculation views

          All the SAP delivered calculation views sit on top of private views and may be some ECC tables ?

          -> Private Views are generally on top of ECC tables and then on top of these there are reuse views and on top of reuse views we have query views.

          If a customer wants to create his own view, would that require creating a private view ?

          ->No, If you want to create your own view – there is no need to follow the way HANA Live works

          You can create your own views as you want

          Can not the attribute, analytic and calculation view directly connect to a table without a private view ?

          -> Yes you can create these views directly on tables



  • Hi Vivek,

    Wonderful blog and very helpful.

    I have one small question on the HANA Live installation, I have checked the Service Market place for ECC I am able to find only one Delivery unit which contains almost 1000+ views, is their a way to only install selected views for example for SD two Views and for MM two views …just based on the requirement.
    If yes can you please let me know the process.



    • Hi Neel,

      It is not possible to select a particular view for deployment in HANA when you do import from a delivery unit.



      • Hi Vivek,

        Thanks a lot for your reply ,
        so the only way is to take the entire delivery unit and then replicate only tables required so only those views will be activated rest will be inactivated.



        • Yeah,

          One way is that – the other way – is to runt the SAP provided script that creates the empty tables so that all views get activated



  • Hey Vivek,

    Know its a preety old thread, but I am having a problem in Extension. When I right click and do extend nothing happens.

    I am on HANA studio version – 2.1.16 and the HANA revision 92.

    Can someone help, if any else addon is required.

    • Hi Vivek,

      did you already solve your issue?

      I’m facing the same problem, I’m on HANA Studio 2.2.13, Extensibility Tool is v1.3.0 and HANA on SPS10.

      Would be great to hear your solution.

      Many thanks!

      • Hey Moritz,

        No, resolution, I ended up installing Kepler rather than HANA Studio and then adding SAP tools over it. , it works in that.

        Its not working in HANA Studio.

          • Hey, the note says to upgrade to SP12 , and obviously thats not simple, generally the client is alaways 1-2 SP down than the latest one.

            I am on SPS 9. The extension kit doesnt works with Studio,

            So i downloaded Eclipse and then installed SAP HANA tools and it worked. on SPS9 also .

          • I have downloaded eclipse and installed SAP HANA add ons. But when i right click on the view, it doesn’t show the option for Extend View. In the HANA studio, atleast it is showing the Extend view option though it will not do anything after clicking it. Am i missing something in the eclipse as it is not even showing the Extend view?

  • Nice blog Vivek.


    Wanted to understand the last point in the benefits section.

    If we update HANA Live Views later on then out Extended View also get updated”.

    Eg: If we extend a HANA Live view (add new display fields) into another package and then if there is new version of HANA live view is provided (some more fields enabled etc), then does that automatically update the extended view?

    2) Also need help to know the process for HANA live views implementation? Do we install the HANA

    live views in Dev and then move only views needed to the production or just

    install all of the views in production directly? Any recommendation or best practices?



  • Hi All,

    I can see Extended View option when I Right click on Live View but when I click on Extended View it is not opening further window.

    Kindly Advice me. Please find the below image for reference.