SAP Analysis for Microsoft Office

Analysis Office and BPC integration

                          AO and BPC/4 Work status Integration.   A work status that will be used in Analysis, has to be defined with SAP Business Planning and Consolidation (BPC), version for SAP NetWeaver embedded. The work status is configured in the BPC Web Admin Tool and is based on a BPC model. A model can include one or several Info Providers. All Info Providers in the model must contain the owner …

Read More »

#ASUG Webcast: What’s New in Analysis Office 2.6 Recap

Source: SAP This was an ASUG webcast today.  If you want more Analysis Office webcasts please take our survey today See our upcoming webcasts here Expect GA in 3 weeks Source: SAP Legal disclaimer applies Source: SAP Some nice features are coming You can schedule events based on dates Source: SAP SAP Analytics Cloud integration started in 2.5; making more use of the HANA engine such as exception aggregation   Source: …

Read More »

SAP Analysis Office – Talk to Me #SAPTechEd

In this Journal of Accountancy article, it shows how to add the speak buttons to Excel 2016.  I thought why not try it with Analysis Office?  What can I do to make ASUG webcast statistics more interesting? I decided to upload the Excel spreadsheet to SAP Analytics Cloud, then use Analysis Office to “slice” / “dice” the data: Of course this is better suited for financial data that you need …

Read More »

Local hierarchy in Analysis for Office – Grouping

Now Analysis for Office allows you to build custom hierarchies to display members listed under a node interactively. Besides using pre-defined hierarchies for certain dimensions, you can group members together as a hierarchical presentation if a dimension is displayed with its flat presentation. You can separate these members again by ungrouping them. You can ungroup a single node or the complete custom hierarchy. Pre-requisites: • You can group members of …

Read More »

Grouping and Linking Dimensions in Analysis for Office

A cool new feature that is offered by Analysis for Office versions 2.4 and above is the ‘Combine’ functionality. You use several data sources in a workbook and any action performed on a dimension affects the same dimension in other data sources in the same way. It allows you to stick/link two crosstabs together so that they look and behave as one single crosstab. On performing ‘Combine’, the crosstab from …

Read More »

Quick Snap: Analysis for Office 2.5 Connection to SAP Analytics Cloud

Analysis for Office 2.5 is GA and available in the service market place. Inspired by Tammy’s blog, I went about connecting AO2.5 SP01 to SAC. The connection setup window is straightforward, (perhaps too simple):   Had a million tries taking different bookmarked SAC URL…None worked. Stuck on this screen…I was expecting a login form: The AO admin guide was not helpful. Found SAP note 2460065: AO only works with a “Friendly” …

Read More »

Mixed mode deployment (Linux & Windows) for AO (Analysis for Office) scheduling on BI platform

Mixed mode deployment consists of a few services of the BIP platform running in the UNIX machines and a few services running in a windows machine. One of the use case for running a mixed mode deployment is as follows: For example in an installation of the SAP BI platform that is running live on Unix/Linux. If you want to perform a workflow for AO Report scheduling. As of BI …

Read More »

SAML SSO for Analysis Office 2.x with BI Platform and HANA

This article describes the mandatory configuration steps for the setup of SAML SSO between BI Platform and SAP HANA with Analysis Office. Step 1: Create OLAP Connection Open CMC and create a new OLAP connection of type “SAP HANA http” Enter the fully qualified HANA host name and HTTP port Select SSO as authentication Save the connection   Step 2: Create Certificate Open HANA XS Admin UI in the browser …

Read More »

News in Analysis Office 2.5 #ASUG Webcast Recap

SAP provided this webcast earlier in the month.  As always items covered are subject to change: Source: SAP Source: SAP This is the “big” slide of news for 2.5.  EAC means Early Adopter Care With Analysis Office 2.5, you can integrate with SAP Analytics Cloud: strengthen hybrid strategy; invest in cloud and integrate with on-premise tools SAP kept investing in table design; now support formulas that reference the key area …

Read More »

BusinessObjects Analysis for Office 2.5 – a First Look

Analysis Office 2.5 is in Early Adopter Care, formerly known as “ramp-up”. You can review the What’s New guide in the SAP Help too. SAP Analytics Cloud You can now consume native SAP Analytics Cloud models using Analysis Office 2.5, and set up system connections Here’s the SAP Analytics Cloud model “Best run demo” After setting up the connection to SAP Analytics Cloud, I can search for the “Best run” model …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration