what does the quick analysis button do in excel

This brings up a prompt where you would need to provide some inputs. Here we would point the MS Excel application to the source of our data, i.e the source SAP HANA view for this analysis. Now, click on the Insert button to configure and inset a new data source.Ĭlick on the “Select Data Source” button. but did you notice a new tab in here?Īs seen below, a new tab called “Analysis” now is available due to the Analysis for Excel add on. Let’s start with it by clicking on the “Analysis for Microsoft Excel”. The Excel add on is used occasionally in some projects but the PowerPoint one is quite rarely touched. All SAP Business Objects tools exist under the “SAP Business Intelligence” folder in the start menu.Īs you see below, there are two tools under SAP Business Objects Analysis: The Excel add on is used in some scenarios by end users occasionally but the PowerPoint plugin is rarely used Analysis for Office: Excel add on Key Pointsįrequency of use in real time projects: Low – MediumĮffort to develop: Low Analysis for Office: Excel Add on In this tutorial, we learn reporting with SAP Business Objects Analysis for Office on SAP HANA.Īnalysis for Office is nothing but an SAP Business Objects add on for MS Excel and MS PowerPoint. you managed to find the right key word combination to search for. Give yourself a pat on your back for making it this far and if you just landed on this page directly from a web search.

Welcome one and all to another reporting on HANA tutorial. Business Objects Analysis for Office on SAP HANA

What does the quick analysis button do in excel