Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - Webi - How-to Advanced - Creating a Prompt that Doesn't Affect the Query and is Usable in Reports

This article explains how to create a prompt that doesn't affect the query that you can use in formulas in your report.

Add a pair of conditions for a single field (not already in the conditions) to your query

  1. Where one is for "equal to" and the other for "not equal to".

  2. Set both conditions to the same prompt value a

  3. Nest them with an or

    Two Conditions Nested with Or on Business Objects

    This creates a pair of conditions that have no impact on the data returned; the field will always be equal to or not equal to any prompt value you enter. You can now use the prompt in formulas, reformatting it to a date (use the todate() function) or number (use the tonumber() function) if needed.


=DaysBetween(<Fin Rpt File Dt> ; ToDate( UserResponse ("test date") ;"mm/dd/yy") )

Keywords:bis, irf, Launch_Pad, webi, aura, sdw, gems, BI, Business_Objects   Doc ID:43262
Owner:James I.Group:University of Chicago
Created:2014-08-27 16:41 CDTUpdated:2017-05-15 10:46 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0