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,
- Adding a variable for an attribute
- 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.
Step 2: Select any of the attribute which you want to see in prompt section. Add filter on that
Step 3: Fill the related information on that, normally we no need to select in this wizard. It will take all the values.
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.
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,
By default, it will be direct type. Create a new parameter as it is.
Simply creating parameter will not give prompt. It has to be engaged with view. It is possible in two methods.
- Use the parameter in calculated column
- 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.
That’s it. Now validate and activate.
Now you will get prompt in webi.
Use parameter in expression
You can see filter option in every projection. Just edit the expression under filter folder.
Point the parameter over there.
Again validate and activate.
These are the ways to create a prompt in HANA studio.