Page tree
Skip to end of metadata
Go to start of metadata

As you may be aware, SAP has taken a Cloud first strategy, which means SAP Analysis for office, as on-premise solution and mature product, will receive only limited investments from 2022 onwards. 

Our Road map for Excel environment is focused on SAP Analytics Cloud, add-in for Microsoft Office. You can retrieve our Roadmap here. You’re welcome to submit
or to vote on improvement requests for this new go-to strategic solution, under SAP Analytics Cloud Continuous Influence Session  for the category Microsoft Integration.


The following tutorials have been developed to help you get started using the Business Intelligence Suite products. 

Looking for eLearning for the rest of the Business Intelligence Suite? Go to sap.com/LearnBI.

Getting Started

  • 2.7 Layering of Rules (Rules Sequence)   (2:03)     video
  • 2.6 Mark Rules Based on Crosstab Selection   (0:50)     video
  • 2.6 Edit Formula Definition  (3:14)     video
  • 2.6 Show Formulas In Crosstab  (1:04)     video
  • 2.6 Copy All Rules To Clipboard   (3:43)     video
  • 2.6 Fill Handling (autocomplete functionality)   (1:33)     video
  • 2.6 Insert VLOOKUP with Table Design   (4:13)     video
  • 2.5 Integration of SAP Analytics Cloud models  (2:06)     video
  • 2.5 Table Design - Enhancements   (2:51)     video
  • 2.5 Grouping - Enhancements   (3:33)     video
  • 2.4  Workbook Protection  (3:41)     video
  • 2.4  Group Members / Custom Hierarchy  (2:51)     video
  • 2.4  Shared Axis  (5:11)     video 
  • 2.4  Linking Dimensions  (3:30)     video
  • 2.4  Table Design Rules Tab: Enhancements  (2:40)     video
  • 2.4  How to Customize User Interface Areas  (5:41)     video
  • 2.3  Upload Filter Values Via File (1:36)     video
  • 2.3  Renaming Dimensions Attributes Measures  (1:36)     video
  • 2.3  Explicit Selection  (1:48)     video
  • 2.3  Design Rules Tab  (5:21)     video 
  • 2.3  RRI Enhancements (RRI as target)  (3:13)     video
  • 2.3  How to Work with Activities?  (2:31)     video
  • 2.2  Search By Attribute (1:03)     video
  • 2.2  Insert Excel Formula With TD (Vlookup) (2:23)     video
  • 2.2  Extend Style Sets (4:01)     video
  • 2.2  Open Workbook From EPM Repository (0:55)     video
  • 2.2  Search Improvements For Data Sources (0:52)     video
  • 2.2  HANA: Search Improvements For Data Sources (1:12)     video 
  • 2.2  HANA: Filter By Measure (2:25)     video 
  • 2.0  What’s new in Analysis, edition for Microsoft Office 2.0 (1:02)     video
  • 2.0  Set properties with the Enhanced Display Panel (0:54)     video
  • 2.0  Apply formats to crosstabs with Table Design  (1:59)     video
  • 2.0  Insert lines into crosstabs with Table Design (1:00)     video
  • 2.0  Export a data source to Design Studio using Smart Copy (1:09)     video
  • 2.0  Export a data source to PowerPoint using Smart Copy (1:05)     video
  • 2.0  Connect to SAP HANA via HTTP (1:10)     video
     
  • 1.4 What’s new in Analysis, edition for Microsoft Office 1.4 (1:53)     video
  • 1.3 What’s new in Analysis, edition for Microsoft Office 1.3 (3:38)     video
  • Navigate the interface in Microsoft Excel 2007 (12:06)     video
  • Navigate the interface in Microsoft PowerPoint 2007 (5:31)     video
  • 1.2 Navigate the interface in Microsoft Excel 2010 (6:52)     video
  • 1.2 Navigate the interface in Microsoft PowerPoint 2010 (3:56)     video
  • Enable the Add-In (1:59)     video
  • Insert a data source directly from BW (3:01)     video
  • Insert a data source using an OLAP Connection (2:40)     video
  • 1.1 Insert a data source using a local connection to SAP HANA (3:08)     video


Creating Workbooks in Excel

  • Add data to a crosstab (2:07)     video
  • Set a value for a prompt (2:30)     video
  • Create a calculation (1:17)     video
  • Insert a dynamic calculation (1:16)     video
  • Insert a dynamic chart (1:58)     video
  • Insert a filter component (1:31)     video
  • Insert an information field (2:08)     video
  • Apply a style set (1:22)     video
  • Create a style set (1:43)     video
  • Export a style set (1:50)     video
  • Delete a style set (0:59)     video
  • Create a formula (1:44)     video
  • Convert a crosstab to formulas (2:22)     video


Planning in Excel

  • 1.1 Display the planning features (1:17)     video
  • 1.1 Set the planning system (3:36)     video
  • 1.1 Add empty rows for planning (1:22)     video
  • 1.1 Add new planning data manually (4:31)     video
  • 1.1 Add data using a planning function (3:12)     video


Analyzing Data in Excel

  • Sort data by measure (1:27)     video
  • Sort data by dimension (1:56)     video
  • Define a conditional format (3:02)     video
  • Edit a conditional format (1:38)     video
  • Create a background filter (1:22)     video
  • Filter data by measure (1:38)     video
  • Filter data by member (2:21)     video
  • Filter data by member in a hierarchy (2:06)     video


Sharing Content in Excel

  • Create a PowerPoint slide (1:33)     video
  • Save a workbook to the BI platform (1:51)     video
  • Open a workbook from the BI platform (2:36)     video
  • Insert a hyperlink to open a document in the BI platform (2:15)     video
  • 1.1 Save an Analysis View (1:57)     video
  • 1.1 Insert an Analysis View (2:53)     video


Working with SAP NetWeaver BW

  • 1.3 Upload local data to an SAP BW Workspace (4:18)     video
  • 1.3 Reload local data to an SAP BW Workspace (1:58)     video
  • 1.3 Enrich an existing query with local data from an SAP BW Workspace (1:59)     video
  • 1.3 Define your preferred platform (1:22)     video
  • 1.3 Store a document in the SAP BW NetWeaver repository (1:29)     video
  • 1.3 Store prompt values as a variant (1:32)     video
  • 1.3 Navigate to another query or transaction using the Report-to-Report Interface (1:17)     video



5 Comments

  1. Former Member

  2. We are very sorry, but there is a technical problem. We are currently working on this issue. 

  3. All videos are working again (smile)

    1. Thanks a lot Isabella. That will be really useful for everyone. Great work.