Pasting a list of values to Exclude in Prompt

[james_batchelor2]

All,

How can I paste a list of values for exclusion for a dimension in the prompt? 

If you Add lines using Filter by Member, you get the interface to Paste values and that works, but they all come in "="

So now I have to manually change everyone of them to "!="??  I can't set the operator prior to adding lines and have it stick for all lines added?

These are not ranges, they are independent values. Sometimes...a lot of them.

A better way?

thanks

jim

[IngoH · Accepted solution]

hi James,

the only option I can see right now is to define the variable already as an exclude in the BEx query designer, but then it will always be an exclude.

perhaps give the end user one variable for "include" and one for "exclude"

ingo

[TammyPowlas]

I am not seeing a way to do this in Analysis Office 1.4

It is a great suggestion for Idea Place

Regards,

Tammy