Skip to Content

In most of the cases end user will prefer to get user input screen before checking the report output, it is a place where user can filter their requirements from overall data.


User input screen can be achieved using prompt option in Webi report. Creating and configuring prompt options is possible on various levels.


Prompt usually will be created on webi report itself, apart from that we can able to create prompt on IDT universe. In case, if you are using HANA as a source then you can able to create prompt in HANA view.


In HANA view, we can create prompt in 2 different ways,

  1. Adding a variable for an attribute
  2. Adding a parameter.


Adding a variable for an attribute:


Step 1: Create a view as usual in HANA studio. In the semantics layer you can see that output fields which you selected in view.

H1.png


Step 2: Select any of the attribute which you want to see in prompt section. Add filter on that

H2.png

Step 3: Fill the related information on that, normally we no need to select in this wizard. It will take all the values.


H3.png


H4.png



Step 4: Validate and activate the view.

Step 5: Get the view in IDT and built a universe for that, then in webi check the prompt option by drag and drop the field which you created variable.


H5.png

Check the result for prompt.


Adding a Parameter


As like variable, we can create a new parameter for the view. It has different type like below,


P1.png

By default, it will be direct type. Create a new parameter as it is.

P2.png


P5.png


Simply creating parameter will not give prompt. It has to be engaged with view. It is possible in two methods.

  1. Use the parameter in calculated column
  2. Use the parameter in filter expression

Use the parameter in calculated column,


Create a new calculated column in view and in expression, point the created parameter.


P6.png


That’s it. Now validate and activate.


Now you will get prompt in webi.


P7.png

Use parameter in expression


You can see filter option in every projection. Just edit the expression under filter folder.

P9.png

Point the parameter over there.

P11.png


Again validate and activate.


These are the ways to create a prompt in HANA studio.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply