BusinessObjects Board

Optional query parameters from excel

Hi all.

I’m doing a dashboard in which I need to pass some optional parameter to my universe query from the excel spreadsheet.
I need to pass a list of Id that is loaded on the excel, but sometimes this list can be empty and in this case I want all the data.

The problem is that in this case the query fails because it gets a syntax error since it get something like “WHERE CENTERS_DELIVERY_NOTES.ID_CENTER IN (,)” and this is incorrect.

Is there a nice person that can give me any idea about how to handle this? :roll_eyes: :oops:

p.s. sorry for my english, not my mother language :slight_smile:


Fratty (BOB member since 2013-06-25)