Introduction SAP AO and visualization with AO

Fill in your Maxis Email

Which tool is used to view BW reports in SAP Embedded Analysis?

• SAP Analysis for Microsoft Excel (AO)

• Excel Analytics Add-on

When Analysis for Office is installed but not displaying in the Excel Menu Tab, where can it be enabled?

• Files--> Options--> Add-ins--> Disabled Items

• Files--> Options--> Add-ins--> COM Add-ins

• Files--> Options--> Add-ins--> Excel Add-ins

What is the preferred platform configured as the default for setting the datasource in Analysis for Office when used in SAP Embedded Analysis?

• Business Intelligence Platform

• SAP Analytics Cloud

• Business Warehouse

Which option in SAP Analysis for Office Insert Data Source Features is used to open a query/report?

• Select Data Source for Analysis

• Select Data Source for Defining Formulas

Where can you find a report in SAP Analysis for Office after logging into the system?

• Search

• Role

• Both A and B

Which icon is used to identify the mandatory parameter?

• With '*' icon at the beginning of the parameter.

• Parameter name in bold.

• The mandatory ones are listed at the top of the parameter list.

How can you save a BW data source as a personal workbook in SAP Analysis for Office?

• File -->Save As-->Excel Workbook

• File -->Analysis -->Save Workbook

• File -->Analysis -->Convert BEx Workbook

How can you refresh data in only one selection data source when you have multiple data sources open in Excel with Analysis for Office? (Select Multiple)

• Select “Refresh All” in Analysis Tab

• Select “Refresh Data Source” in Analysis Tab

• Select “Reset Data Source” in Analysis Tab

• Close Excel and re-open data source in AO.

What is the correct way to add a refreshable new measure by adding 2 measures in SAP Analysis for Office?

• Use a formula in MS.Excel

• Add Calculation in the Analysis Tab

• Convert to formula in the Analysis Design Tab