Skip to Content
Author's profile photo Noel Scheaffer

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?

<img />

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,

Noel

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for sharing, useful post.

      Author's profile photo Former Member
      Former Member
      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Brenden Kennedy
      Brenden Kennedy

      Thanks for sharing, great idea!

      Author's profile photo Former Member
      Former Member

      @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)