11-23-2012 03:35 AM
When filtering columns in an IMAP in SAS AMO there is no possibility to have a preview of the data which is stored in the column. The User has to know exactly which values he needs to type into the filter dialog. For example: 'Country' contains 'Germany', 'Austria' and 'Spain'. As a User i need to know exactly that these expressions are the values of the column. In Enterprise Guide 5.1 for example i can list the content of the column and pick the values i would like to filter.
This is quite unconvenient for users who are not that familiary with the data - which is more the rule than the exception.
Are there any plans to fix this?
11-23-2012 10:35 AM
Exactly how do you do your "filtering"?
Using a predefined filter in the IMAP?
Excel, using "autofilter" ?
How do you open the IMAP and into what program?
I can open a IMAP in excel and do autofilter and select which items I want to use.
The same when I use then filter dialog when opening the IMAP, I can chose from a list of items....
11-23-2012 10:49 AM
the point is: I do not define a filter within the IMAP because the User wants to have the flexibility to filter across all columns if he wants to. Or with other words: The User can pick any column he wants for filtering.
Therefore he opens the IMAP in the Excel Add In and uses the filter dialog:
As you can see - there is no option to have a preview on the data (Excel Add In Version 5.1).
11-23-2012 10:58 AM
Ok, I understand your problem!
Is there a lot of rows in the data?
If so I would try to create filters for the different variables, that will enable selection.
If not maybe opening the IMAP into a pivot would help the users? Oops, just saw that you might already do this......:-)
11-23-2012 11:13 AM
you are right - the intention is to open the Data in a Pivot table which gives the User a lot of flexibility.
Thinking about your proposal i like the idea of (pre-)preparing some filters in the IMAP. I need to talk to the customers and define the most important variables to use for filtering. That should solve at least 80% of all filtering requests ... (the great Pareto principle).
Thanks for commenting!
12-03-2012 03:56 AM
I tried to implement what you proposed and guess what happened? It does not work as intended.
The point is that i would like to have a dynamic list of values from which the user can pick the ones he needs. It just doesn't work within the Excel Add In. I can choose values opening the IMAP in eGuide and/or the WRS but not in AMO. Opening the dynamic list in AMO shows an empty drop down list. It works when i collect the values from the base tabel but not using the current IMAP (see screenshot).
I initiated a sas track at the SAS hotline and am still waiting for a solution.
12-04-2012 04:49 AM
Really strange, for me it's working great.....
Just a question, in your last picture it seemes that you are using a stored process, why?
12-04-2012 05:19 AM
SAS told me that there is a known defect
so it would surprise me if it would work perfectly in your environment, using dynamic list, the IMAP as the data source (for the dynamic list) and
To answer your question: Yes i am using a Stored Process to ask the user for 2 dates which i need to calculate a column in the IMAP. The STP is not the reason for my problem since i already tested a version without the STP. I am also sure it would not work with any given IMAP.
It also does not work in the Enterprise Guide but there are no problems using the WebReport Studio.
12-04-2012 06:44 AM
I have created an imap with a filter using a dynamic list from the current imap.
My prompt is not shared! (the SAS note mentioned shared prompts....)
I open the imap from excel and can choose from the list.
Am I missing something...:-)
12-04-2012 11:48 AM
Hm, what exactly does 'my prompt is not shared' mean? I also struggled a bit with the meaning of 'unshare the prompt' mentioned in the SAS Note.
Maybe you can add the 2 Screenshots from the filter definition in your IMAP.
12-11-2012 09:18 AM
many thanks for the comprehensive screenshots. This is exactly how it should be but on our site it's not working.
SAS points out that this issue (empty filter list when using dynamic prompts) has been fixed in AMO 4.3 but does not work (again) in AMO 5.1.
Could it be that you are using AMO 4.3?
P.S. I was struggling with your native language since the description of the menu buttons etc. are not really familiar to me but i was able to 'translate' this into our version since the look and feel is the same.
12-11-2012 10:08 AM
Hehe, Yes we are using 4.3...
Ich hatte die gleiche "probleme" mit Ihrem "screen shots", aber meine kleine "schule-deutch" (? :-)) hat mir ein bisschent geholfen....