Skip to Content
0
Former Member
Apr 25, 2016 at 08:18 PM

Multiple Criteria for Analysis Prompt

36 Views

Hey guys, first post so I hope I can explain exactly what I need (that I couldn't find).

We have some analysts that use BEx for reports since it allows the user to paste in multiple items to exclude from a query. When using Analysis 1.4, the Prompts window allows you to add additional lines by hitting the + sign to the right or using the 'Add Lines Using Filter by Members'. However, using that feature and copying in a list of thousands of ID numbers, it sets all those in as "=" as default. We need them to be "!=", but if you change the sign first in the drop down, it still defaults back when you add the lines in. Is there a way to exclude a long list of criteria numbers? Thanks!