In my previous blog I described how we can consume HANA Views using UDT(.unv) in web intelligence.

Consuming HANA views in Web Intelligence report

Here we will see how we can consume HANA views(variables and input parameters) in webi through IDT(.unx).

Keep in mind only JDBC middleware is supported for consuming variables and input parameters

At first make sure you have View created in HANA Studio and variables or input parameter over it.

HANA11.png

Once this is executed we can create a Variable over this analytical view

HANA12.png

This was the HANA part and after this View is executed in HANA Studio and ready to consume in BO we can now move to Information Design Tool and see how we can create connection over this HANA view and use variables and Input Parameters

HANA13.png

So now we are creating a relational connection using JDBC as middleware for HANA

You need to specify HANA server name,port number and redentials remember in order to consume variables/input parameters only JDBC is supported with webi and not ODBC.

Refer https://websmp207.sap-ag.de/~sapidb/011000358700000171062014E/sbo41sp3_rel_restric_en.pdf for this.

Once local connection is created we will now reate HANA Business Layer as below

HANA14.png

This will allow you to create data foundation and business layer in one go,once you have given names below will be the pane to select HANA View

HANA15.png

Once you click on OK here it will create both data foundation and business layer.In the data foudation once we click on table we can see the variable dependant on it.

HANA16.png

The next steps is very crucial we have created data foundation and business layer over a local connection hence inorder to publish the HANA business layer we need to first publish the connection and then point the data foundation to the published connection shortcut(.cns)

HANA17.png

Now the HANA Business Layer is ready to be published to repository and for reporting.

Now you can create webi over this HANA universe and run it successfully.

HANA18.png

Hope this blogs helps all 🙂

I am open for any comments or queries on this.

To report this post you need to login first.

8 Comments

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

  1. Sreenivas Anchuri

    Hi,

    Good info.I have a doubt here.

    If we don’t want to use Prompt in any webi report then do we have any option to disable/delete the prompt.I want it to be available in Universe.

    (0) 
    1. Pranay Sharma Post author

      Hi Sreenivas,

      There is no way as far as I know to achieve that.

      Only possibility is you can have them optional intead of mandatory in HANA.

      Regards,

      Pranay

      (0) 
      1. Sreenivas Anchuri

        Hi Pranay,

        No.I believe giving option is not solution for this.Some reports don’t require any prompt whether it is mandatory or optional.

        It is a bug.In Webi we should have an option to choose the required prompts may be in the properties window where we see list of the prompts

        Thank you

        Sreenivas.

        (0) 
        1. Pranay Sharma Post author

          HI Sreenivas,

          If I do not consider HANA Variable but take an example of relational database universe.

          There also if we have a filter at universe level it gets propagated to webi or any reporting tool.

          This is by design and in case you want to raise an enhancement you can log it at http://www.ideas.sap.com .

          Hope this helps 🙂

          Regards,

          Pranay

          (0) 
  2. Shaofeng Liu

    what’s the difference between Variable and Input Parameter.

    I have some confusion.

    Could you tell more?

    when to use variable and when to use inpu parameter.

    (0) 
      1. Pranay Sharma Post author

        Also especially the below suff will give the sql structure difference which is good to know:-

        Input Parameter is passed using PLACEHOLDER:

        The value of Input Parameter is passed using PLACEHOLDER clause.

             (‘PLACEHOLDER’ = (‘$$DISCOUNT$$’, ’10’))

        WHERE:

        The value of Variable is passed using WHERE clause.

              WHERE (“REGION_NAME” IN (‘Asia’) )

        (0) 

Leave a Reply