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

MS Office Add-in with OLAP source?

Reply
Regular Contributor
Posts: 163

MS Office Add-in with OLAP source?

Hi:
Just wandering on the Microsoft Office SAS Add-in if it works ( or how it works) with a SAS OLAP source. We have some cubes that are surfaced via Excel.
jp
Frequent Contributor
Posts: 80

Re: MS Office Add-in with OLAP source?

Yes it does,

As always there are things that only work with relational data vs OLAP data and vice versa.

Also functionality has improved between 9.1 and 9.2

Lastly you can access OLAP cubes from within Excel without gong through the SAS AMO addin.
Regular Contributor
Posts: 163

Re: MS Office Add-in with OLAP source?

Shane,
I meant to say Outlook.... can we surface OLAP cubes using Outlook?
Thanks again,
jp
SAS Employee
Posts: 9

Re: MS Office Add-in with OLAP source?

The MS Outlook integration feature of the Microsoft Office SAS Add-in 5.1 (scheduled to ship later this year) will allow for OLAP data exploration of cubes with time dimensions. Does this meet your requirements?
Regular Contributor
Posts: 163

Re: MS Office Add-in with OLAP source?

Thanks Mike.
Ask a Question
Discussion stats
  • 4 replies
  • 338 views
  • 0 likes
  • 3 in conversation