BookmarkSubscribeRSS Feed
tbatliner
Calcite | Level 5
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
5 REPLIES 5
CaseySmith
SAS Employee
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

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

tbatliner
Calcite | Level 5
Thanks Casey for the fast reply!
ShaneGibson_OptimalBI
Fluorite | Level 6
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.
tbatliner
Calcite | Level 5
Thanks Shane!
Almost there... 🙂

br Thomas

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 5 replies
  • 2272 views
  • 0 likes
  • 3 in conversation