User Prompts

[ADB1]

All,

I have a simple list report with some columns that have been built after the sql has been ran. By inserting a formula, If Then Else, in this case. I want to be able to filter and have a prompt appear on this column. I can't add a prompt on a condition in the query panel due to the If Then Else being a user variable, and not a Universe object.

How would I build some prompts on the user created variables?

Thanks in advance.

Ad.

 

[skrandel]

You should be able to build a prompt at the query level that doesn't affect the rows being returned

Something like:
yourobject = 'Enter a value'
OR yourobject <> 'Enter a value'

Then at the report level, you can use a defined filter that does =<your_local_dimension> = UserResponse('Enter a value',,,,,) I'm not supplying all the parameters, but you should get the idea.

Steve Krandel
VERITAS Software