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

/wp-content/uploads/2014/06/001_482232.jpg

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

/wp-content/uploads/2014/06/002_482233.jpg

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:

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

/wp-content/uploads/2014/06/003_482240.jpg

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

/wp-content/uploads/2014/06/004_482241.jpg

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.

/wp-content/uploads/2014/06/006_482242.jpg

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.

/wp-content/uploads/2014/06/005_482243.jpg

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

/wp-content/uploads/2014/06/021_482244.jpg

/wp-content/uploads/2014/06/009_482245.jpg

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

/wp-content/uploads/2014/06/010_482252.jpg

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

/wp-content/uploads/2014/06/011_482253.jpg

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

/wp-content/uploads/2014/06/012_482254.jpg

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.

014.JPG

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

/wp-content/uploads/2014/06/015_482256.jpg

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

/wp-content/uploads/2014/06/017_482257.jpg

Lets select both the fields and Validate and Activate the View

Both the Views are available inside ExtTest Package as shown below

/wp-content/uploads/2014/06/019_482264.jpg

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

/wp-content/uploads/2014/06/020_482265.jpg

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

Hopefully, this tool will get better with time

Regards,

Vivek

To report this post you need to login first.

28 Comments

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

    1. Vivek Singh Bhoj Post author

      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

      Regards,

      Vivek

      (0) 
  1. Florian Pfeffer

    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?

    Thx.

    Florian

    (0) 
    1. Vivek Singh Bhoj Post author

      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

      Regards,

      Vivek

      (0) 
      1. Vara Yarramsetty

        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.

        Thanks,

        Vara

        (0) 
        1. Vivek Singh Bhoj Post author

          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:

          http://scn.sap.com/thread/3433018

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

          Regards,

          Vivek

          (0) 
  2. Sudarshan Survepalli

    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”.

    1. com.sap.ndb.studio.bi.model.calculation.CalculationScenario.getDefaultMember()Ljava/lang/String;

    Thanks in advance,

    Sudarshan

    (0) 
      1. Zain Naser

        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.

        Regards,

        Zain

        (0) 
        1. Vivek Singh Bhoj Post author

          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

          Regards,

          Vivek

          (0) 
  3. Neel M

    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.

    Thanks

    Neel.M

    (0) 
    1. Vivek Singh Bhoj Post author

      Hi Neel,

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

      Regards,

      Vivek

      (0) 
      1. Neel M

        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.

        Regards

        Neel

        (0) 
        1. Vivek Singh Bhoj Post author

          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

          Regards,

          Vivek

          (0) 
  4. vivek singh

    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.

    (0) 
    1. Moritz Zwerger

      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!

      (0) 
      1. vivek singh

        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.

        (0) 
            1. vivek singh

              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 .

              (0) 
              1. Prasad Ganta

                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?

                (0) 
  5. Prasad Ganta

    Nice blog Vivek.

    1)

    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?

    Thanks,

    Prasad

    (0) 

Leave a Reply