Skip to Content

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.

/wp-content/uploads/2014/05/1_464528.png


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.


/wp-content/uploads/2014/05/2_464529.png

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.


/wp-content/uploads/2014/05/3_464530.png

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply