BusinessObjects Board

Displaying LOV in dropdown list box in WEBI ?

building semantic layer
#1

[Corrected Spelling of Title for better searchability -CP 2/22/2004]

Hi All,

Here i have one requirement. User doesn’t want to click the show values on the WEBI to select for the prompt. He wants to see all the values in the Dropdown List box when the prompt popwindow has appear.It is Possible?. I didn’t get any Idea. Pls Help me in this.

  1. How can display the defalut values in the prompts boxes.(Publishing the report after purging.)

  2. How can use the cascading prompts in webI?.

Pls guide me for these requirement.

Thanks
Tella

ptella (BOB member since 2003-11-26)

default values in prompts
#2

  1. You can setup your object in designer to automatically refresh on open, but your user will still have to click Show Values

  2. When you Purge the cube, it only purges the datacube. It does NOT purge all the defaults for the prompt boxes. So, whatever was typed in at last run will show up in your prompt box. One of our best practices, is to run the report prior to publishing, then fillin default prompts. Stuff like:
    :arrow_forward: Date Prompt: YYYY-MM-DD
    :arrow_forward: Matches Pattern Prompt: %NAME%
    Yes, purge your datacubes prior to publishing (your report will load quicker), but the prompts will still be as per the last run

  3. Cascading prompts are a function of the object (in designer). So you can setup a cascading prompts for WebI same as Full Client

Chris Pohl :us: (BOB member since 2002-06-18)

#3

I think it does purge the prompt values also. At least it did in 5.x/2.7[/quote]

Steve Krandel :us: (BOB member since 2002-06-25)

#4

I had a similar requirement sometime back and couldn’t find any workaround for that.

Yes it does purge the prompt values in 5.x when one purge the MicroCube.

Sri

Sridharan :india: (BOB member since 2002-11-08)

#5

Yep, it does purge the prompt values also :oops: … what Chris meant to say …

One way you can purge the cube is by running the report one time filling in bogus default values for your prompts … Stuff like:
:arrow_forward: Date Prompt: YYYY-MM-DD
:arrow_forward: Matches Pattern Prompt: %NAME%
:arrow_forward: Standard Character Prompt: “Click Show Values for a list”

Chris Pohl :us: (BOB member since 2002-06-18)

#6

Will that not fetch data from the DB Chris??? Suppose we have a Date Prompt what exactly are you telling to do to retain the Prompt Value but purge the Cube… Possible to provide more details…

Thanks
Sri

Sridharan :india: (BOB member since 2002-11-08)

#7

Chris is purposely filling them in with bogus values. This will generate a “No data to fetch” message, which has the same effect as purging via Data Manager. What you are left with on the next refresh is essentially a template … pre-filled with examples of how the prompts are to be filled in. Neat trick actually!

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#8

Thanks Dwayne & Chris… Yes its indeed a good trick…

Sri

Sridharan :india: (BOB member since 2002-11-08)