cancel
Showing results for 
Search instead for 
Did you mean: 

Hana Sourced Input Parameters & Variables as Webi Filters

Former Member
0 Kudos

Gurus not sure if I should post this in Webi, IDT, or Hana forum not having any luck in the WebI forum so moving to HANA .  We recently upgraded to Version: 4.1 Support Pack 4 Patch 4 of BOBJ before this we couldnt use Hana Input parameters in WebI documents now we can but there is a slight issue.

In Hana the Input Parameter/Variable has a description like this:

Plant:

in Design Studio it shows properly.

But when it shows in the webi prompt box it looks like this:

Plant: [MACH1.Extensions_Custom.IMWM.Query/CA_IMWM_ALL_TO/MSEG_WERKS_IP]

Everything in the [] is defining where the prompt is coming from and the name of the input parameter it makes the box very hard to read especially when you have 5-6 lines like this.

Has anyone else encountered this?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

There is a workaround for this. You can shorten the length of the Prompt.

1. You can create a special package in HANA just for your input parameters/prompts and maintain a dummy view. Give it a name "P"

2. Create one calculation view in this package and give a short name "FYP" or just another letter "Q".

3. Create a dummy "measure" in this view.

4. Create input parameters in this view that you can use in your Universe based on HANA view.

5. In IDT - Data foundation, insert this newly created view and make a join to the main view.

6. Modify your derived table query to use the parameters from the newly added view.

Now the name will be shortened in Webi as per the screen shot below.