Embed Size (px)
Citation preview
Mohamed Abdel Hadi
Senior Architekt für SAP BI und SAP HANA
Analysis for Office 1.4
10.09.2014
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 2
Agenda
1
2
3
Überblick Analysis for Office
Demo
Roadmap
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 3
Reporting Standardreports
Analyse und Self Service Unerwartetes Entdecken
Dashboards Kritische Werte aufzeigen
SAP Lumira
Analysis for Office Design Studio
Web Intelligence
Crystal Reports
Überblick Analysis for Office
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 4
Analysis for Microsoft Excel
Analysis for MS Excel ist ein MS Office Add-In mit dem man Ad hoc Analysen
auf Multidimensionalen OLAP Quellen durchführen kann.
Der Vorteil von Analysis for MS Excel ist, dass Ihnen zusätzlich zu den Analysis
Funktion auch die gewohnten Excel-Funktionalitäten zur Verfügungen stehen.
Wie viel Sätze können angezeigt werden?
Das richtet sich nach der Excel Version. Excel 2010 1.048.576 Sätze
Welche Integrationen gibt es zusätzlich zu der Excel-Integration?
Sie können aus Ihrer in Excel erstellten Analysesicht eine Präsentationfolie mit direktere
Datenanbindung zum Quellsystem erstellen (Vorteil keine Anpassung der Zahlen in der Folie)
Sie können aus Ihrer erstellten Analyse einen Web- oder Mobilereport generieren.
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 5
5
1. Fachbereichslogik: SAP Bex Query (Empfohlen)
2. SAP Bex Query Views (Navigationszustand)
3. Info Provider direkt
4. SAP HANA (Berechnungs- und Analysesichten)
5. SAP ERP (InfoSets mit transistentem InfoProvider) –FI/CO
Welche Daten können angebunden werden?
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 6
Was kann Analysis for Office im Detail?
Nutzung alle Excel Charts mit direktem Data-Binding
Zusätzlich Wasserfall-Diagramm
Pivot Sicht für Drag & Drop sowie Slice & Dice
Filtern auf Kennzahlen und Merkmalsausprägungen
Rückgängigmachen für alle Ribbon-Funktionen
Publishing (nur in Kombination mit BO Plattform)
Kommentarfunktion (SAP Consulting oder Möglichkeit in Analysis Office 2.0 mit „Table Design“)
Power Point Integration / Integration mit Design Studio und BW Workspaces
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 7
Moderne Oberfläche für den
Fachanwender. Drag & Drop von
Dimensionen und Kennzahlen
Speichern der Arbeitsmappen im
SAP BW auch ohne Plattform
Unterstützung von
Rückschreibefunktionen
Power Point Integration mit
automatischer Aktualisierung
Filtern & Drill Down gegen die
Datenbank direkt aus Excel
Analysis for Office (Excel and Power Point Add-In)
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 8
8
Angelehnt an Excel-Standard Pivot, intuitiv
Teil des Tools, nicht des Reports / Templates (immer identisch)
Der neue Navigationsblock
Bex Analyzer
Analysis for Excel
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 9
Verschiedene Planungsfunktionen Erstellen von PDF Dateien
Writeback Auf jedem Level planbar
Analysis for Office mit Planungsmöglichkeiten
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 10
Formula Mode zur Umsetzung eigener Logiken
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 11
Export von Excel
Live Refresh
Analysis for Power Point
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 12
Analysis for Office
Deployment Optionen
Browser client
Deployment
Platforms
Data sources
SAP NetWeaver
BW
BI Platform
BW HANA
Consumer Designer Consumer Designer
SAP BW SAP Business Objects Plattform
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 13
Analysis for Office
Transaktionen im SAP BW
Workbooks starten:
RAAOE: open Analysis Office Excel Add-in
RAAOP: open Analysis Office Power Point Add-In
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 14
Berichts-Berichts-Schnittstelle
1. Filter Kontexte (Parameterübergabe)
2. Transaktionen
3. ABAP Report
4. SAP BI Plattform Berichte
5. Web-Links
6. …und viele mehr ..
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 15
Öffnen einer Arbeitsmappe
Über das normale Office Startmenü
15
Über Suche, Favoriten oder Menürollen
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 16
Formatvorlagen flexibel nutzen
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 17
Beispiel – Tabelle nach Hichert in Analysis for Office
Spaltenüberschriften und
Schraffierungen
Databars Formatierung der
Hierarchieebenen
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 18
Agenda
1
2
3
Überblick Analysis for Office
Demo
Roadmap
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 19
Analysis for Office
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 20
Scheduling in Analysis for Office 1.4 Feature Pack
Scenario and Features
Schedule reports for oneself or others (requires admin
authorizations)
Send email or to inbox
Filtering via authorization or exit variables
Requirements
BI Platform 4.1 (at least one node on Microsoft
Windows)
Analysis Office 1.4 Feature Pack – Add-On Installer on
BI Platform 4.1
Analysis,
edition for Microsoft Office
BI Platform
Central Management Console
Precalculation Server
(on Windows node)
Schedule
Send to email
or inbox
GA since Nov 2013
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 21
Zusammenspiel der Tools
Analysis for Office, Design Studio, Mobile
Beispiel
Start mit Analysis for Office Query
Erstellen einer Design Studio
Applikation
Speichern auf SAP BI Mobile
Analyst
Endanwender
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 22
Migration der Bex zu Analysis for Excel
Link
Mass Converting Tool
from Consulting Standard
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 23
Agenda
1
2
3
Überblick Analysis for Office
Demo
Roadmap
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 24
SAP Product Road Map for Analysis, edition for MS Office Key themes, capabilities, and planned innovations
Highly interactive multidimensional analysis on
SAP sources (BW & HANA)
MS PowerPoint Publishing
Excel-based application design via powerful API
Analysis Excel write-back on BW-IP (integrated
planning)
Combine local and corporate data (via BW
Workspaces)
Conversion support
Transformation into web and mobile apps (via
Design Studio)
Scheduling on BIP
Native HANA
Table Design
Fully interactive mode
Insert empty rows/columns
Format Cells
Planning on BPC embedded
model
Usability
Multi-Select in extended side panel
Gradual Convergence with EPM
Excel Client
HANA Platform
Configuration of workbooks
Continuous Improvements
Comments
Enhanced PowerPoint support
This is the current state of planning and may be changed by SAP at any time. Planned Release: Q4 2014
Today Planned Innovation Future Direction
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 25
© 2014 SAP AG or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG or an SAP affiliate company.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG (or an SAP affiliate
company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
National product specifications may vary.
These materials are provided by SAP AG or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP AG or its
affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP AG or SAP affiliate company products and services
are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an
additional warranty.
In particular, SAP AG or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or
release any functionality mentioned therein. This document, or any related presentation, and SAP AG’s or its affiliated companies’ strategy and possible future
developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP AG or its affiliated companies at any time for
any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-
looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place
undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 26
Vielen Dank für Ihre Aufmerksamkeit!
Mohamed Abdel Hadi
Senior BI & HANA Presales Architect
SAP Switzerland
Althardtstr. 80
8105 Regensdorf
mailto:[email protected]
