How to Bypass Mandatory Prompts

[former_member4998]

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”

WHERE "TABLE”.”FIELD" = "TABLE”.”FIELD"

UNION ALL

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

From  "TABLE”

ORDER BY AG_GROUP

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.