@Gianni Ceresa our business has over 1000+ locations - we wanted to have a parameter that showed all of this. This is allowed in OTBI, for departments which is way over 1000 and locations for example, but when we need to move reports to BIP this is a limitation for our customers. Thanks.

Hi @Basavaraj Navalagi , I've come across this thread as I'm trying to do this now. I need an assignment status default values to show as: ACTIVE, SUSPENDED I can get it to work with one. When I use the ; as you have suggested. It doesn't then use a default value. Is this format correct? ACTIVE;SUSPENDED Or should there be…

Thanks for replying @Gianni Ceresa . Do you have an example of this by any chance, can't wrap my head around your comment as I didn't think the location table is infinite. ? We have 1090 locations active in the parameter query for the LOV. To get locations for employees in the data set I use joins: left join…

Hello @Bhaskar Konar Thank you for your help. I've managed to fix the solution with your help. That document gave me some extra knowledge. Appreciate it a lot!