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

AMO and OLAP drill though

Reply
Occasional Contributor
Posts: 6

AMO and OLAP drill though

The main question is:
Did Add-In for Microsoft Office support drill though to detail in pivot table using OLAP-cube as source?
In OLAP-cube this function (drill though) is enabled.
SAS Super FREQ
Posts: 306

Re: AMO and OLAP drill though

Yes, the Add-In for Microsoft Office (starting with version 4.2) supports drill through to detail in PivotTables whose source is an OLAP cube. Excel 2007 also exposes this functionality, so the fact AMO exposes it is more important when using Excel versions prior to 2007.
Ask a Question
Discussion stats
  • 1 reply
  • 573 views
  • 0 likes
  • 2 in conversation