topic Re: AMO Filter vs Enterprise Guide Filter in Microsoft Integration with SAS

AMO Filter vs Enterprise Guide Filter

deleted_user — Mon, 27 Mar 2006 21:34:45 GMT

Hi,

I believe that the filter option on the Enterprise Guide query builder is much better and safer than the one in AMO. The reason is that I have seen users often create AMO filters with multiple lines and when they string, say, 2 ANDs and an OR together, they don't realise that what they are getting back is not what they wanted.

The graphical nature of the filter in EG makes this much more obvious.

Are there any plans to update this in AMO?

Thanks.

Re: AMO Filter vs Enterprise Guide Filter

Bill_SAS — Mon, 03 Apr 2006 13:28:59 GMT

I understand your concern. We've had some confusion surrounding the AND and OR operator precedence here as well. There are currently no plans to address this issue.

Re: AMO Filter vs Enterprise Guide Filter

deleted_user — Wed, 05 Apr 2006 20:10:47 GMT

That's a pity - it is a very real problem.

Re: AMO Filter vs Enterprise Guide Filter

deleted_user — Fri, 11 Aug 2006 12:00:12 GMT

You could generate your filtering in EG with the graphic option.

Further on work on the generated code and adapt it to your needs (and / or's. That is what is so fantastic in EG. You mainly have a solution for any need.

Regards,
Pablo

Re: AMO Filter vs Enterprise Guide Filter

deleted_user — Fri, 18 Aug 2006 17:05:14 GMT

Yes, but users who use AMO in my experience do so because they are not users of EG. The AMO filter needs to be foolproof for these typically lesz expert users.

The EG3 graphical query builder (ie the 'Filter' tab) is excellent and is exactly what is needed in AMO.

I have seen major problems when people create a complicated filter (ie ANDs plus ORs) in AMO - the data they get is not what they think they are getting.

The EG4 query builder has some disadvantages compared to the EG3 query builder, and one is the loss of this graphical filter.

In fact, I was disappointed to see so much work put into the query builder in EG4. It is by far the best part of EG3 and should have been left alone IMO - there are plenty of other areas in more need of enhancement.