Help with webi prompts

[jaburke]

Hey,
I have created a webi doc and I want to have 3 prompts associated with it. Let's call them appliance_type, model, and color. I want them to default to 'all' if the user doesn't specify a value. So he can choose appliance_type of stove and leave the defaults for model and color so he gets all stoves, regardless of model and color. Same with the others, if I am making sense.
How can I accomplish this in webi? Oh Crystal was so much simpler. Do I have to build the prompts into the universe or can I do it in the webi doc design?

Thanks,
Jennifer

 

[dbomrrsm]

In Webi drag in the dimension you want to filter on.

Select operand type of Prompt and tick the Set Default Values box. Then select all values.

Do this for all three dimensions.

This way the user will have to physically remove the ones they dont want so as in your example if they selected appliance type of stove and ran the query they would get all models and colours as they are populated with all the models and colours values.

The only way you can bring in the use of ALL is buliding a predefined filter in the universe.

Hope this helps.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[blom0344]

You cannot under ANY circumstances leave a prompt blank.However you can build a OR construction that always defaults to true.

example:

@Select(WORKFLOW\Workflow Name) like @Prompt('Fill % for all values','A', 'WORKFLOW\Workflow Name','mono','constrained') OR
@Select(WORKFLOW\Workflow Name) = @Prompt('Fill % for all values','A', 'WORKFLOW\Workflow Name','mono','constrained')

Ties Blom