Which features does SAP Analysis for Microsoft Office provide? (3)

Question

Options

• ADragging measures in and out of the report
• BIncluding more than one data source
• CCreating bookmarks for a navigation state
• DChanging context menu entries
• EDisplaying data simultaneously in a table and a chart

• A
  92% (24)
• C
  4% (1)
• D
  4% (1)

Explanation

SAP Analysis for Microsoft Office is a client-side BI tool embedded in Excel/PowerPoint, and options A, B, and E reflect its core strengths: users can interactively drag measures in and out of a crosstab (A), connect multiple data sources (e.g., several BEx queries or HANA views) within a single workbook (B), and display the same dataset as both a table and a chart simultaneously within the spreadsheet (E).

C is wrong because creating bookmarks for navigation states is a feature of Web Intelligence and SAP BusinessObjects tools, not Analysis for Office - while you can save workbook navigation, "bookmarks" as a named feature belongs elsewhere in the SAP BI portfolio.

D is wrong because customizing context menu entries is specific to SAP Lumira Designer (formerly Design Studio), which targets web-based dashboard authoring, not the Excel-integrated Analysis for Office environment.

Memory tip: Think of Analysis for Office as "Excel on steroids for BW data" - everything it does fits naturally inside a spreadsheet (drag columns, plug in multiple queries, see a chart next to your table). If a feature sounds more like web dashboard customization (menus, bookmarks), it belongs to a different SAP tool.

No community discussion yet for this question.