Getting your @Prompt syntax right
I have been using BusinessObjects for just over a year and have only used 4.0. I had become accustomed to the ease of defining a prompt in WebI so I was kind of surprised when I attempted to create a universe prompt in the Information Design Tool. I need to type out up 7 parameters for the prompt function (see attached image below). Really?
As a work around to what I perceive to be a shortcoming, I simply create a prompt within a query in IDT or WebI with whatever options I want. Then I view the script that is generated and copy the @Prompt function and its parameters. Now I paste that where I am trying to create my prompt. The prompt editor may not expose all of the options of the prompt, but at least it gets me started and then I can manually adjust what is generated if necessary to create the finalized version of my universe prompt.
I hope you find this helpful.
Thanks for sharing, useful post.
Missing basic functionality
functions in @prompt default value
I don't know if it's still there in IDT (I sincerely hope it is) but in BOXI 3.1 you can right-click on the SQL editor within an object or predefined condition and there is an option in there to invoke a prompt creation dialog box, making life far easier.
Thanks for sharing, great idea!
@Select(CLASS\OBJECT) in @Prompt('select xyz value','A','CLASS\OBJECT',Multi,Free)
@Select(CLASS\Date_OBJECT) between @Prompt('01 Start Date','D',,mono,free) and @Prompt('02 End Date','D',,mono,free)