SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

AMO 4.3 Docu / Questions

Reply
Contributor
Posts: 30

AMO 4.3 Docu / Questions

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
SAS Super FREQ
Posts: 245

Re: AMO 4.3 Docu / Questions

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
Contributor
Posts: 30

Re: AMO 4.3 Docu / Questions

Thanks Casey for the fast reply!
Frequent Contributor
Posts: 80

Re: AMO 4.3 Docu / Questions

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.
Frequent Contributor
Posts: 80

Re: AMO 4.3 Docu / Questions

Contributor
Posts: 30

Re: AMO 4.3 Docu / Questions

Thanks Shane!
Almost there... :-)

br Thomas
Post a Question
Discussion Stats
  • 5 replies
  • 264 views
  • 0 likes
  • 3 in conversation