An EXTENDED prompt syntax is AVAILABLE since BO 3.1. It is as follows

@Prompt( ’message’, ‘type’, [LOV],
mono/multi,
free/constrained/primary_key,
persistent/not_persistent,
{‘default value’:’default key’} )

If the INDEXES for the dimension object is defined in the universe and we define the prompt condition on the object with the clause ‘primary key’ in place of free or constrained, then the filter condition will convert the prompt values ENTERED to their corresponding indexes and eliminate the join with the dimension table

An extended prompt syntax is available since BO 3.1. It is as follows

@Prompt( ’message’, ‘type’, [lov],
mono/multi,
free/constrained/primary_key,
persistent/not_persistent,
{‘default value’:’default key’} )

If the indexes for the dimension object is defined in the universe and we define the prompt condition on the object with the clause ‘primary key’ in place of free or constrained, then the filter condition will convert the prompt values entered to their corresponding indexes and eliminate the join with the dimension table