topic Re: AMO 4.3 Docu / Questions in Microsoft Integration with SAS

AMO 4.3 Docu / Questions

tbatliner — Wed, 01 Sep 2010 09:35:48 GMT

Dear all,

is there a documentation (of the features) of AMO 4.3 available (online)? I couldn't find any...only a very short "what's new"...

I'd especially like to know if you can
- use the new prompting framework (cascading/dynamic prompts) within Excel
- change filters in 'SAS-Pivot-Tables' after the report has been created

Thanks in advance for your input,
regards,
Thomas

Re: AMO 4.3 Docu / Questions

CaseySmith — Wed, 01 Sep 2010 13:54:41 GMT

Hi Thomas,

I didn't find much documentation either, but I can answer your two questions:
-yes, AMO 4.2 and later supports dynamic, cascading prompts (in all the supported Office apps - Excel, Word, PowerPoint, and Outlook (in 4.3))
-yes, in AMO 4.2 and later, you can change filters in a PivotTable (whose source data is accessed via a workspace server -- ex. library data set, SAS Folders data set, Information Map) after it has been created

Note: You can't filter, subset, or sort the source data to PivotTables that use a local data set or OLAP cube as the source data, since these sources don't come from a workspace server from which we can do sql processing to subset, filter, and sort; the PivotTable retrieves the data from these sources directly.

Casey

Re: AMO 4.3 Docu / Questions

tbatliner — Wed, 01 Sep 2010 14:20:07 GMT

Thanks Casey for the fast reply!

Re: AMO 4.3 Docu / Questions

ShaneGibson_OptimalBI — Wed, 01 Sep 2010 21:01:56 GMT

Looks like the EG 4.3 whats new has been posted here:

http://support.sas.com/documentation/onlinedoc/guide/index.html

But the AMO 4.3 doco isnt here yet:

http://support.sas.com/documentation/onlinedoc/addin/index.html

So id keep an eye on it as it shouldnt be far away.

Re: AMO 4.3 Docu / Questions

ShaneGibson_OptimalBI — Wed, 15 Sep 2010 00:30:48 GMT

System Requirements for AMO 4.3 have appeared:

http://support.sas.com/documentation/installcenter/en/ikmsofficeintsr/63820/PDF/default/sreq.pdf

Re: AMO 4.3 Docu / Questions

tbatliner — Wed, 15 Sep 2010 13:45:45 GMT

Thanks Shane!
Almost there... 🙂

br Thomas