SAP Analysis for Office

Explains how to configure Analysis for Office options across user, advanced, platform, and conversion tabs, covering recent list size, member display, caching, and conversion of old workbooks.

Customize the Analysis for Office user interface by creating profiles, adding a Demo group with a Test Call button, and arranging the ribbon, context menu, and side panel for planning.

Learn to manage company and embedded profiles in Analysis for Office by distributing a unified ribbon menu, configuring the interface, and embedding profiles into workbooks.

Explore the analysis for office add-in, using the file menu and pivot area to open sources or workbooks, convert BEx workbooks, and create crosstabs with drag and drop and filters.

Explore the ribbon interface of Analysis for Office, with two tabs—Analysis and Analysis Design—regarding data sources, undo/redo, data analysis tools, formatting, and integrated planning options.

Insert your first crosstab by selecting insert data source in the analysis tab and choosing the Sales Query, then click okay.

Open and save the workbook in SAP Analysis for Office, insert a crosstab, save to SAP Business Warehouse, and reopen via file > analysis > open workbook.

Discover how SAP Analysis for Office uses crosstab context menus to filter by member or measure, apply BEx conditions, sort, format cells, and build dynamic calculations.

Learn to sort data in SAP Analysis for Office with ascending and descending orders, using more sort options to sort by measures, attributes, or break hierarchies in a crosstab.

Learn to filter data in Analysis for Office using filter by member and by range, search attributes like Sales Channel, and paste from clipboard or file to apply selections.

Learn to filter data within hierarchies in SAP Analysis for Office by using Filter by Member, managing leaves view, and applying range and transfer filter options across hierarchies.

Filter your data directly on the crosstab by including or excluding members, using filter by member, filter by range, or swap with filter other members, with control or shift.

Learn to filter data in SAP Analysis for Office using the background filter, swap and add dimensions, and apply prompt-driven calendar year and sales channel selections.

Activate and deactivate BEx conditions directly in Analysis for Office to filter data by the top three values of a sales channel, matching the behavior of the old BEx Analyzer.

Learn dynamic ranking to display top N results by a chosen measure, such as the top five business categories per calendar month.

Learn to use access mode for filtering in SAP Analysis for Office, switch between values in master data and current navigation state, and enable display options.

Learn to use prompts and variables in SAP Analysis for Office to filter data by workbook or data source, configure ranges and hierarchies, and manage display and technical names.

Learn which areas enrich an Analysis Office workbook, including infofields and Excel formulas, and which areas to avoid around the crosstab; place above or left to prevent overlaps.

Switch rows and columns quickly with the swap axes feature in SAP Analysis for Office, avoiding manual dimension moves; use SAPMoveDimension or undo to revert.

Bind your crosstab to a chart using analysis design tab and choose from column, waterfall, or pivot waterfall charts; adjust rows to update and color with RGBValueColumns, RGBValueNegative, and RGBValuePositive.

Learn to insert SAP infofields from the analysis design ribbon, view data source and filter details, insert variables, and drag and drop information to build dashboards without formulas.

Manage totals in a crosstab with SAP Analysis for Office. Toggle show or hide totals, adjust rows and columns, and use Calculate Total As for sum or average with hierarchies.

Display dimensions in SAP Analysis for Office using the display function to choose key, text, or both for your infoobject, with access mode to show master data when available.

Apply number format settings to measures in SAP Analysis for Office, including scaling factor, decimal places, header units, currency translation, negative value formatting, and zero display options.

Learn to design crosstabs in SAP Analysis for Office by inserting new columns and lines, adding key figures and dimensions, and applying advanced calculations.

Learn to create and apply custom styles in SAP Analysis for Office using Format Cells, formatting the result line and member header with fonts, fills, and borders.

Format the Crosstab in SAP Analysis for Office using the Analysis Design Format options. Apply default formats, adjust cell width/height, and repeat members; display symbols for parent members, then reset.

Learn to create, save, apply, and share custom style sets in SAP Analysis for Office, export and import them, and switch between SAP Blue and Blue Crystal.

Apply conditional formatting in analysis for office by creating new rules, selecting a measure such as amount, and choosing formats like color or indicators for data cells and headers.

Explore the hierarchy functionality in Analysis for Office, adding a dimension with a hierarchy to a crosstab and expanding or collapsing by level.

Explore SAP Excel formulas in Analysis for Office, including SAPGetData, SAPGetMember, and SAPSetFilterComponent, to build dashboards and display dynamic filters and data source information.

Use SAP Analysis for Office standard calculations to build new key figures on the fly with Add Calculation for add, subtract, divide, multiply, requiring two figures and matching Excel functionality.

Create advanced calculations in SAP Analysis for Office by adding a key figure, selecting the amount as base, and applying an exception aggregation like average over the calendar month.

Learn to create restricted key figures in SAP Analysis for Office by clustering countries into regions (Europe, North and South America, Asia) using f4 help, then reuse figures in reports.

Save a query view named Area Business Category in SAP Analysis for Office, describe it, save to BW system, and insert the saved view into workbooks via the analysis tab.

Use the filter function in the analysis design insert group to build interactive dashboards with SAP Excel formulas, enabling end users to filter data by business category.

Visualize data in PowerPoint using SAP Analysis for Office. Insert data sources, apply filters, and add charts or crosstabs across slides.

Add a new column in the crosstab and calculate VAT with Excel formulas, then let Analysis for Office auto adjust when you add dimensions and support vlookup with iferror handling.

Learn to use the report-report-interface in Analysis for Office to jump to another query, transaction, or report via the backend RSBBS by defining sender and receiver.

Explore prompts and variables in SAP Analysis for Office using the prompt dialog for data sources or workbooks, adjusting ranges, hierarchies, and filters to narrow analysis.

Learn to use the contains pattern function in SAP Analysis for Office by enabling OperatorContainsPattern, configuring characteristic restrictions, and applying a background filter to select business categories.

Explore the convert to formula function in the analysis design tab, turning a crosstab into SAP Excel formulas (SAPGetData, SAPGetMember, SAPGetDimensionInfo) to build flexible dashboards with SAPSetFilterComponent.

Discover how to create a web application in Analysis for Office using the Analysis Design tab and the Create Web Application tool, with Crosstab data in Design Studio.

Launch the query designer from the analysis design tab to edit queries with BW modeling tools, add dimensions, set a wholesale filter, and save and refresh in Analysis for Office.

Use smart copy and smart paste from the Analysis Design tab to copy a crosstab in Excel and paste it into PowerPoint as a table or chart.

Group crosstabs across info providers by using the combine feature, designate a master and slave, and link dimensions to filter both data sources in one crosstab for flexible analysis.

Build hierarchies on the fly in Analysis for Office by grouping Dealer Network, Dealer Accounts, and Dealer Fleets, then rename or ungroup to manage internal and general business groups.

Discover the formula-optimized mode in Analysis for Office 2.7 that generates a query from SAP Excel formulas for faster results and configure data sources with SAPSelectMember and SAPGetData.

Explore reporting with VBA and the Analysis for Office API, learn how to use API methods, and why refreshing data sources first ensures correct execution and faster performance.

Explore the SAP AddMessage and SAP GetCellInfo APIs in Analysis for Office using the Visual Basic Editor; create custom messages and inspect cell information to support planning applications.

Explore SAP API methods in VBA to filter, refresh, and move data in SAP Analysis for Office. See how SAPCallMemberSelector, SAPExecuteCommand, SAPLogOff, SAPMoveDimension, SAPOpenWorkbook, SAPSetFilter, and SAPSetVariable control data sources.