Skip to Content
Author's profile photo Sreenivasulu Dasari

How to Bypass Mandatory Prompts

Hi All.

I am explaining how to bypass mandatory prompt screen to select * value in the list of values of the specific dimension.

Follow the below steps to insert * value in the list of values.

Click On the Parameters and List of Values tab à Select the List of Values Based on Custom SQL From LOV’s  à Click on the Edit and à Specify the SQL in the SQL editor and validate the code.


sample code

SELECT Distinct ‘*’ As AG_GROUP

From  “TABLE”



SELECT DISTINCT “Specific dimension which you need to include * value in LOV’s” AS AG_GROUP

From  “TABLE”


Once the LOV’s based on custom SQL (Country Name) created à Then Go back to Business Layer à Create Filter  under country folder (Country Name) à and specify the SQL code in the where clause.


Sample Code

Country Name

“TABLE”.”FIELD” IN @Prompt (‘Prompt Text Message (* to bypass filter)’,’A’,LOV’S Name’:’

AG_GROUP’,Multi,,Persistent,{‘ *’},User:-1)

OR ‘ *’ IN @Prompt (‘Prompt Text Message (* to bypass filter)’,’A’,’LOV’s Name’:’

AG_GROUP’,Multi,,Persistent,{‘ *’},User:-1)

Save the business layer and export to repository and test able to see the * values in the LOV’s.

And pass the * values to bypass the mandatory prompt and run the report.


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.