Hi WACHS, we also use the Excel Add-In a lot. Users like it a lot becuae they are pretty familiar with Excel and do not have to dive into another SAS Application. Performance is always the main problem thinking about the AMO. But the performance issues appear because Excel imports all the data into it's memory (via Network). We already talked to SAS Germany about the issue but there is nothing they can do about it. We use the Add-In mainly for accessing Information Maps to be opend as PIVOT Table and found it helpful to advice the users only to select the columns they really need and to define filters to keep the amount of data which needs to be transferred vom SAS to Excel as minimal as possible. I do not think that the LASR Server or any other SAS Server (e.g. SPSS) is responsible for slow performance - it's the network transfer. Cheers, Thomas ... View more

Hi GVeers, i face the same problem now and then when i have to change the data source for an existing Excel Report. I'm not sure what 'wipes out all the formatting' means. Is this about the Formats like showing numbers with 2 digits or do you talk about the selected columns und the filters (which are definitely lost when changing the data source). Cheers, Thomas ... View more

Hi Fredrik, 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? Cheers, Thomas 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. ... View more

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. Cheers, Thomas ... View more

SAS told me that there is a known defect http://support.sas.com/kb/44/832.html. 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 AMO as the Application. 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. Cheers, Thomas ... View more

Hi, 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. Cheers, Thomas ... View more

Hi FrederikE, 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! Cheers, Thomas ... View more

Hi FrederikE, 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). Greetings, Thomas Hirsch ... View more