Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
priyanka_sadana2
Explorer

What is Analysis for Office?


SAP Business Objects Analysis, edition for Microsoft Office, is a Microsoft Office Add-In that allows multidimensional analysis of OLAP sources. It connects to SAP NetWeaver BW and SAP HANA.
Analysis plug-in includes versions for Microsoft Excel where Analysis for Microsoft Excel is a reporting tool.

CDS View to be consumed by Analysis for Office


Here we will learn through top down approach i.e. understanding the consumption view first and then going down to the interface views consumed in consumption view. After consuming the view, we will learn ways to view the latest data and to change value of input parameters without launching analysis for Office again.

Consumption View


Below is your consumption view Z_C_SFLIGHT_SCARR which is using interface view Z_I_SCARRFLIGHT_DEMO


Interface View(s)


Z_I_SCARRFLIGHT Is Association of two Views Z_I_SCARRDEMO and Z_I_FLIGHTDEMO on carrier ID



Interface view Z_I_FLIGHTDEMO



Interface view Z_I_SCARRDEMO


Steps to consume CDS view in Analysis for Office


Insert a data source (in our case a CDS view) and display the results in Analysis for Office



Skip the Logon to SAP Business Objects BI Platform



Select the system



Search with SQL view name of CDS view




Annotation @Consumption.filter is used to apply filter on the fields of a view. Marking multiple selection as true allows multiple inputs on the field. Also a field can be marked as optional or mandatory using the same annotation.

Refer line number 16 in Fig. 1
Here, @consumption.filter is applied on CarrierId.


Use value help and select Airline AA



Press OK and you will be able to view the data in Analysis for Office






This excel sheet can be saved and provided as a template for the end user. End user can change the input parameter via prompts and view data accordingly.
Also, Refresh All button can be used to view the latest data.


Click on Prompts from Data Source




This simple example demonstrated how easy it is to create user friendly reports using CDS View and its annotations.

 
50 Comments