SAP Analytics Cloud Add-in for Microsoft Office

Install SAC add-in from the Microsoft Store to access and analyze data in Excel and PowerPoint. Retrieve and push SAC data to models from on premises, cloud, and data warehouses.

Explore the SAC add-in for Microsoft Excel to pull data from planning and analytical models, plan in Excel, and create and update SAC tables within Excel.

Use the SAC add-in for Microsoft PowerPoint to insert and update chart widgets with current expenses data, using the SAC tool to adjust filters and configurations for PowerPoint slides.

Install the SAP Analytics Cloud add-in for each Microsoft Office app from Microsoft Store via the developer or home tab, then sign in with your SAC tenant URL and credentials.

Add tables in Excel with the SAC add-in to modify columns and rows, drill into hierarchies, and create tables from SAC models or data sphere models into your sheet.

Modify the SAP Analytics Cloud add-in table by adding dimensions and measures to rows or columns, then drag to reorder the hierarchy and move items between rows and columns.

Explore drilling down hierarchies with table options, expanding and collapsing by arrows or the expand/contract button, and set levels to view quarters, years, and months across countries and companies.

Apply filters, sort, and ranking to refine intersections, using the right panel and filter icons to add or remove dimension members, or add new dimensions to filter intersections.

Sort and rank members in a table by dimension or node, using ascending, descending, or default order, then apply ranking to select top or bottom members across rows or columns.

Add an SAP Analytics Cloud table in Excel, configure company and date dimensions, expand hierarchies to years and quarters, and filter to North America and Asia.

Explore advanced dimension settings in the SAP Analytics Cloud add-in for Microsoft Office, including formatting, thresholds and conditional formatting, display and hierarchy options, unbooked data, and totals across hierarchies.

Format measure values using the number format tab, selecting item price, adjust scale for thousands, millions, or billions, set decimals, and choose sign and parentheses for percentages.

Use the threshold panel to apply conditional formatting to table values. Select the threshold section to define value ranges and highlight them with different colors.

Modify the date hierarchy to year, month, day and format in millions. Apply a threshold to color the background: above 5 million in green, 5 million and below in red.

Create ad hoc calculations in the SAP Analytics Cloud add-in for Microsoft Office by inserting a single or repeating column or row between columns using the add row columns tool.

Learn to add a formula to a column by selecting the first cell, typing equals, entering the formula, and naming the column in the header.

Insert a column between 2024 and 2025, compute variance as (2025-2024)/2025, name it variance, and format as percentage. Apply a date filter showing booked values for 2024–2027.

Explore SAP functions to add them to an Excel workbook using formulas to retrieve, modify, and add data from SAC models and tables, with best practices for data handling.

Learn to add data sources using SAP functions by selecting a data source model from sack tables or Data Sphere, alias as DS2, and view filters in the right-hand panel.

Configure data sources and dimension ids for SAP functions in the workbook. Leverage aliases via the name box and follow the required parameter order.

Explore functions and table functions, focusing on the get table name function to retrieve a table alias from a cell reference such as A1, returning the alias ID.

Explore the SAP.GETTABLESTATUS function, which uses a required table name (alias from get table name) and an optional display type with five options (0 to 4) for various name/status outputs.

learn how to use the Getdata function to retrieve data from the model via member intersections, with data sources like ds1 and optional dimension filters such as account and date.

Explore how to use get dimensions to fetch a model's dimensions and properties from a data source, with member display, orientation, and sort order; review display options and id-based sorting.

Use the Get Dimension filter to build sheet filters from a data source and dimension id, then retrieve the intersection with Getdata from the world sales model.

Use sap.getmemberproperty to retrieve property values from member IDs in the world sales model, apply left to get first six IDs, and output trading currencies with vertical or horizontal orientation.

Learn to use the sap.timeoffset function to create sequential dates from a reference date, choose a data source, display, orientation, and optional filters in a hierarchical date setup.

Overwrite a dimension filter in a table with a time set filter, swapping dates for new dates or cities, then refresh the table to apply changes.

Master the set data function to pass data from Excel into the SAP Analytics Cloud model for planning, using a data source, value, and dimension-member pairs.

Apply SAC functions in Excel to create an input sheet for six months, and a reference ID sheet listing tables, models, and dimensions with date, account, and version filters.

Create a six-month dynamic date sequence with time offset and apply overwrite dimension filters for date, account, and version to refresh the table.

Learn how SAC planning works, including the setdata function, planning models and versions, actuals, budgets, forecasts, and scenarios, with tools for distribution panel, data actions, and publishing changes.

Learn how SAP Analytics Cloud Add-in allocates input data via aggregation and disaggregation, where child values roll up to parent totals and weights split allocations downward and upward.

Explore data actions as a stepwise solution with multiple processes and scripts that modify, calculate, reassign data in bulk and copy data between versions and models.

Log into SAP Analytics Cloud, create a canvas story, and use version management to add a budget version to the version dimension, enabling planning for budget in the model.

Plan on an Excel table to enable planning in the SAP Analytics Cloud add-in for Microsoft Office, including processing, refreshing, and publishing data, with planning enabled and data access control.

Add data to a table, process the data, refresh to update status, then revert or publish data to create a new published point that others can see.

Input data into the SAC model without a table using the SAP set data function, enabling allocation calculations and what-if scenarios from Excel, then refresh to display in tables.

Examine how SAP Analytics Cloud security governs teams, roles, planning licenses, and data access, and contrast it with Excel add-in limitations like bypassed permissions and lack of data locks.

Allocate planning data into the budget version with set data, then process and refresh the table to update allocated and remaining amounts; adjust the next year date and fill down.

Explore data actions as automated planning steps that add data in bulk to models, including scripting and four-cell planning triggers with play, title, and instruction cells.

Configure a data action in the sack, adjust its label and description, define parameters from a fixed list or an Excel table, and run.

Explore the sac add-in for PowerPoint, showing how to insert widgets from stories into PowerPoint slides and keep them updated with the latest data, unlike the Excel add-in.

Learn to add and manipulate a widget in PowerPoint using sassy analytics cloud add-in, sign in to your sassy tenant, and use edit controls to set filters, hierarchy, and ranking.

Refresh the widget to update data or apply format changes by checking the widgets to refresh, then use the refresh data bar drop-down to select refresh data or refresh widget.

Restrict widgets to images, not live objects, so no real-time or pop-up data like in sacch story. Add charts as widgets, while geo maps and tables remain unsupported.

Demonstrate adding and configuring widgets in SAP Analytics Cloud stories, then insert and refresh them in PowerPoint with the SAP Analytics Cloud add-in.