Skip to Content

SAP Analysis for Microsoft Office

For Excel die-hards doing multi-dimensional analysis on OLAP sources and planning on BW IP and BPC. Find helpful resources, hear the latest news, and join the community.

Featured Content


Working with SAP Analysis for Microsoft Office

Find helpful resources for learning Analysis Office, enhance your user experience, and share your ideas to improve our product.

Product Documentation

Video Tutorials

Customer Influence

news icon

Product News

Stay up-to-date with the latest product news, check out the SAP Analysis for Microsoft Office Road Map to get the latest information about the delivered and planned innovations, and more…

Analysis Office News and Road Map

Expert Blogs (Recommendations)

SAP BEx Maintenance-Support Policy

Recent Questions
Problem with Analysis for Office 2.7 - not open Query Designer

Launch Query Designer does not start - it is visible but after running to edit variables it does not open - Query designer automatically closed in processes and not start

Contains Pattern issue

Hello, I am trying to enable the Contains Pattern option but it doesn't seem to fully work for me. I successfully enabled CP and !CP in Ao_user_roaming.config by setting . When I connect to a HANA dat...

data refresh working with windows 7 but not in windows 10 using Analysis for office

data refresh working with windows 7 but not in windows 10 using Analysis for office

June 5th, 2019
Currency conversions with variable time reference in Analysis for Office

Hi, I have a currency conversion type based on a variable time reference on info object 0PSTNG_DATE, which I want to use to convert currencies within Analysis for Office. However, in AfO this conversi...

Analysis for Office 2.x Show Number Format Toggle

Dear all, In Analysis for Office 1.4 there was a possibility to set the number format and analysis styles independtly. To make this selection available you have to make a special registry entry (ShowA...

fail to start sap business one excel report and interactive analysis

Hi members, when i try to open excel report an interactive anlysis designer fromsap business one in Tools--> fail to start sap business one excel report and interactive analysis i get and error and Ex...

Recent Blogs
SAP Road Maps and SAP Transformation Navigator at SAPPHIRE NOW + ASUG Annual Conference 2019

SAP's road map experts will be at SAPPHIRE NOW + ASUG Annual Conference 2019 to help plan and implement a customer's digital journey. Customers and partners will have the opportunity to attend road ma...

April 30th, 2019
Embrace the @SAPMentors Magic: Add these #ASUG2019 sessions to your #SAPPHIRENOW Agenda

It is that time of year to highlight SAP Mentor sessions at ASUG Annual Conference. See below for sessions given by SAP Mentors, SAP Technology Ambassadors and SAP Mentor Alumni: Session ID SAP Mentor...

April 15th, 2019
SAP new technologies and the impacts in the life of consultants

I recently received an invitation to prepare and run a presentation to the IT Brazilian community in Sydney, subject free and with the main purpose of sharing experiences which may help other consulta...

Take advantage of the opportunity to influence SAP solutions live at Sapphire

There are multiple opportunities to influence SAP at SAPPHIRE NOW® and ASUG Annual Conference 2019, May 7–9, in Orlando, Florida. Sessions include a broad range of items in the SAP portfolio in the ar...

April 9th, 2019
#askSAP community call: SAP Analytics 2019 Strategy and Road Map Recap

Source: SAP Last week, SAP kicked off the first #askSAP call with the Analytics Strategy and Road map for 2019. The replay is here: #askSAP Call: SAP Analytics 2019 Strategy and Roadmap Slides are her...

March 4th, 2019
SAP Analytics Cloud Roadmap #ASUG Webcast Recap with Q&A

Source: SAP SAP’s Ty Miller presented as an ASUG webcast from last week. ***promotion*** Please register for more upcoming February webcasts below: February 13 BI: What’s New: Data Wrangling and Model...

February 7th, 2019

Back to top