Skip to Content
avatar image
Former Member

Replacing BW Cube by HANA Views

Hi Experts,

I am working on an HANA implementation project where we need to create fresh HANA views which should produce same data as reflecting in BW Cube/DSO.

It involves implementing logic of underlying data source + logic involved in BW layers (transformations etc) within HANA views.

What would be the best approach to work on such kind of implementation.

Waiting for your suggestions.

Regards

Jitendra

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 08, 2016 at 11:11 AM

    Hi Jitendra,

    Please add system information, as well.

    Do you have ECC tables, replicated into your system or are you going to work on imported BW models in HANA.

    My advice would be to scrutinize the requirement more thoroughly. I am saying this because, from a high level the requirement might be to mirror into HANA views what you have in BW models today...but, that will not be the right approach. See what the business needs are out of this whole exercise. There might be logic or pieces of code that you can do away with when you start doing your models in HANA.

    Second, divide and conquer. Try to split out a single data flow into multiple models, that way it would be easier to develop, test and maintain.

    See what type of views would suit your needs best. I generally lean towards the Calc views instead of AN views, but that decision is based on the end results that I expect, so I would push that idea on you.

    Pay attention to joins and cardinalities because HANA does not exactly work like a traditional RDBMS.

    Learn to use the Plan VIz. to test your models as you build them. You may learn a lot using it to optimize the design of your model.

    Use as less data as you can in your models. Unlike BW, we do not persist data after every transformation, in HANA. Everything happens on the fly. So push down your filter values as deep as possible.

    Benedict

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Benedict,

      First of all thanks for such a detailed reply.

      The requirement is to mirror BW models in HANA views and then BW will be scrapped so no BW models will be used. Will surely go through Plan Viz and consider the approach you have suggested.

      Thanks a lot !!!

      Regards

      Jitendra

  • Apr 20, 2016 at 11:12 AM

    Hi jitendra,

    If you are using BW on HANA system. You can generate the HANA views without any additional effort from your side. You can just check the option "External SAP HANA view" in the settings for the corresponding infoprovider.

    A HANA analytical view will be created in the following folder (under "Content" -> System-local package) corresponding to the provider which contains the structure and data of the infoprovider. You can use these or create new views using these views as a copy template.

    Hope this helps.

    Regards

    Tharun.


    hana view.JPG (30.9 kB)
    content.JPG (13.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 13, 2016 at 09:37 AM

    hi Jatendra,

    Few more points to take care are:

    1. For complex transformation if staging and core layers are still required implement delta.

    2. Delete data from staging once its loaded to core layer.

    3. Avoid using calculations on AV and AN views.

    Regards,

    Anupama

    Add comment
    10|10000 characters needed characters exceeded