Exploring SAP Analytics Cloud (SACE 11): Working with Microsoft Add-ins

🎯 Objective

After completing this lesson, you will be able to describe Microsoft Office integration options for SAP Analytics Cloud stories.

🧩 Integration Tools Overview

ToolFunctionKey Use Case
SAP Analytics Cloud, add-in for Microsoft ExcelBrings SAC data into Excel for advanced analysisAd hoc reporting, planning, Excel-based analysis
SAP Analysis for Microsoft OfficeOffice-based multidimensional analysis of SAP dataBI reporting, complex hierarchies, EPM
SAP Analytics Cloud, add-in for Microsoft PowerPointEmbeds live SAC story widgets into slidesData storytelling, dynamic presentations

📊 Excel Integration Options

🔹 SAP Analytics Cloud, Add-in for Microsoft Excel

  • View and manipulate SAC models directly in Excel

  • Add or remove dimensions, measures, totals

  • Work with hierarchies: expand/collapse nodes

  • Use formulas like:

    • SAP.GETDATA: Retrieves a value for specific members

    • Other formula functions for filtering, metadata, and cell-based reporting

  • Supports planning actions:

    • Write-back

    • Revert

    • Publish

    • Change tracking (highlighting edited cells)

  • Downloadable from the Microsoft Office Store

  • Ribbon integration adds an SAP Analytics Cloud tab to Excel

✅ Best for users who prefer Excel for analysis and want full access to SAC models for planning or reporting.

🔸 SAP Analysis for Microsoft Office

  • Legacy add-in with Analysis and EPM plug-ins

  • Connects to:

    • SAP Analytics Cloud

    • SAP BW

    • SAP HANA

  • Use pivot-style cross-tables in Excel

  • Supports advanced business scenarios and multidimensional data views

  • Planning capabilities supported, but no new SAC features will be added

⚠️ SAP is no longer investing in this tool for SAC. Use the Excel Add-in for future use cases.

🖼️ PowerPoint Integration Option

🟣 SAP Analytics Cloud, Add-in for Microsoft PowerPoint

  • Embed live SAC story widgets into slides

  • Refresh data directly from PowerPoint

  • Filter widget data as needed

  • Use PowerPoint on Windows, Mac, or Web

  • Access SAC stories and widgets via the integrated panel

  • Requires a valid SAP Analytics Cloud license

✅ Ideal for executives, analysts, and presenters needing real-time data storytelling without copying/pasting.

📌 Key Benefits of Microsoft Office Integration with SAC

  • Use familiar Office tools (Excel, PowerPoint) with SAP data

  • Perform live or offline analysis and planning

  • Maintain single-source-of-truth by connecting directly to SAC models

  • Save time by eliminating repetitive exports and formatting

  • Improve decision-making with up-to-date visualizations and data

Comments

Post a Comment

Popular posts from this blog

Designing Stories in SAP Analytics Cloud (SACS 21): Building a Story

  🎯 Objective After completing this lesson, you will be able to: Build a story in SAP Analytics Cloud using appropriate layout and data sources. 🧭 Getting Started with Story Design 🔹 Navigation Path Open the Navigation bar (left vertical menu). Select “Stories” . Choose: Create New Create from Template 🔹 Page Types Responsive Page : Adapts automatically to different screen sizes (e.g., desktops, tablets, phones). Best for mobile-friendly and flexible layouts. Canvas Page : Fixed layout. Better control for precise design and positioning. 🛠️ Design Mode Selection When starting a new story, you must choose between: Optimized Design Experience ✅ (Recommended by SAP) Classic Design Experience (Legacy, limited future support) Note: Optimized Design is the default going forward, with better performance and new features. 📊 Building a Story in SAP Analytics Cloud Basic Steps: Start a New Story (from Stories...
Read more

Designing Stories in SAP Analytics Cloud (SACS 21): Choosing Between Optimized and Classic Design Modes

🎯 Objective After this lesson, you will be able to: Explain the differences between Classic and Optimized Design Modes Know when and why to use Optimized Design Experience 🆚 Classic vs. Optimized Design Experience Optimized Design Experience (Recommended) SAP’s preferred design mode for new stories Prerequisite for: Digital Boardroom features Future enhancements Analytics Designer capabilities 🔧 Key Benefits : Ghost loading indicators Improved performance with large data sets & hierarchies Better tooltips and navigation Quarterly feature updates Advanced Mode available for scripting and customization 🔄 Advanced Mode Features When Advanced Mode is ON , you can: Add interactive widgets: Button, Slider, Dropdown, Checkbox, List Box, Tab Strip, etc. Use JavaScript scripting: Script variables, objects, APIs, CSS editor Customize global settings: Widget visibility, auto-refresh, loading indicators, mobile s...
Read more

Designing Stories in SAP Analytics Cloud (SACS 21): Introducing SAP Analytics Cloud Story Design

🎯 Objective After this lesson, you’ll be able to describe the basic concepts of story design in SAP Analytics Cloud (SAC). 📘 What is an SAP Analytics Cloud Story? An SAC story is a presentation-style document that: Combines charts, visualizations, text, images, and pictograms . Can act as a report (detailed data tables) or a dashboard (high-level visual summaries). Is created and edited in Edit Mode where you can add/remove pages and elements . 🧩 Key Concepts in Story Design Keep it Simple : Smaller, focused stories are easier to understand. Avoid overloading with too many pages or widgets. Follow or Establish Reporting Standards : Use your organization's existing reporting/dashboard guidelines. If none exist, use this as an opportunity to create consistent design standards . Enhance User Experience : Encourage users to maximize their browser and use full-screen mode for the story or individual widgets. This helps in viewin...
Read more