HTML and BEX

[Former Member]

Hello All,

I have a requirement. On the html page (or web template) i would like to have 4 drop down boxes and depending on the values selected in the drop down boxes, the selected query should run.

First is it possible.If yes then where do we begin with this?

One more thing: I have four different web item on the web template,and depending on the values selected in the drop down boxes, all the web items in the template should be updated.

Kindly reply asap.

Thanks and Regards

Pradeep Bhojak

[Former Member]

Hi Pradeep,

If you look at the properties of the drop down box, the last property is called Affected data providers, here you tick which dataproviders you will change (i.e. queries) with the data from the drop down.

Beware though that a drop down with a high data volume behind it even if it is dimension, still takes time to render the drop down and its contents, unless you limit it.

hope that helps cheers G

[Former Member]

Hello Geoffrey,

Thanks for the reply.

But is there any way we can use the normal html drop down box and use the bex query to populate data in it/

Tthanks and Rregards

Pradeep

[Former Member]

You can create a standard HTML box in a form and generate a URL that passes the result to a query.

Best regards

Dirk

[Former Member]

can you be more specific?

I have reached to a following point:

I have created four drop down boxes based on HTML and have bex data providers for populating the data in them.

Now depending on the values that you select I am submitting the values to a template.

Now there are two issues:

Every time I have to enter my userid and password for the BW server(which I do not want)

and second although the window is same, the pages are different, so every time I have to press the back button of the browser to go to the drop down box screen/page

Thanks and Regards

Pradeep Bhojak