Transcription
Week 4: SAP AnalyticsUnit 1: Analytics Solutions and Their Areas ofApplication
Analytics Solutions and Their Areas of ApplicationAgenda Introduction SAP Analytics portfolio Thinking about the conversion Analytics with SAP S/4HANA – high-level architecture Conclusion 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC2
Analytics Solutions and Their Areas of ApplicationIntroductionThe Intelligent Enterprise features3 key components:Manufacturing& Supply Network & SpendManagementIntelligent SuiteIntelligentSuiteIntelligent TechnologiesIntelligent TechnologiesDigital Platform 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICIt’s all about realtime insights,intelligentreporting, selfservice analyticsAI/ML / IoT / m3
Analytics Solutions and Their Areas of ApplicationSAP Analytics portfolioThe Intelligent Enterprise is supported by a diverseportfolio of reporting and analytics: SAP Fiori SAP S/4HANA embedded analytics SAP Analytics Cloud SAP BW & SAP BW/4HANA SAP Data Warehouse Cloud SAP Cloud Platform SAP Lumira SAP BusinessObjects Business Intelligence suite SAP Roambi SAP Data Hub, SAP Vora, SAP Leonardo, SAP PredictiveAnalytics, Qualtrics 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC4
Analytics Solutions and Their Areas of ApplicationSAP Analytics portfolioKey messages: Cloud focus and cloud first Options for all organizations Addressing the diversity within our customer base Need for planning, awareness, and strategy Opportunities to embrace innovation, technology, and cloud Opportunities for simplification 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC5
Analytics Solutions and Their Areas of ApplicationThinking about the conversionI’m feeling overwhelmed: I can’t see the forest for the trees; where to start? What are my analytics options? What does a conversion to SAP S/4HANA mean for me? What to do where? 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC6
Analytics Solutions and Their Areas of ApplicationThinking about the conversionI can’t see the forest for the trees; where to start? Despite the diversity of the supporting portfolio, let’s goback to the scope of this openSAP training Refresh your strategy and roadmap in line with yourconversion and SAP portfolio Focus on a conversion to SAP S/4HANA What is the scope of your conversion? Contain yourimmediate actions to that scope What will be impacted by the conversion, what needsaddressing, what can you take advantage of? This and following units will focus specifically on theimpacts of a migration Above all be pragmatic: Rome was not built in a day 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC7
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat are my analytics options? Low Impact:–––––Bare minimum to keep the lights onRemediation to downstream reporting solutionsRetain all existing reporting solutionsSelected out-of-the-box SAP Fiori apps to add some UX valuePlan for future innovation cycles once conversion bedded down Higher Impact (the above plus):–––––––Additional SAP Fiori apps, see SAP Fiori lighthouseAdditional SAP Fiori apps after a requirements reviewConversion of real-time reporting from SAP BW into embedded analyticsIntroduction of new user types in line with embedded analyticsIntroduction of embedded analytics tools setExtensions to CDS views to address additional real-time operational analyticsAlignment to SAP Analytics roadmap tools, e.g. introduce SAP AnalyticsCloud 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC8
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat does a conversion to SAP S/4HANA mean for me? There will definitely be downstream reporting remediation, plan,discover, execute Remediation will involve possible changes to business process /organizational structures There will be impacts on SAP BW (next unit) User Experience in the form of SAP Fiori will be introduced. This willimpact reporting options People will ask about embedded analytics and why still SAP BW – beprepared (see next slides) Your strategy will need to be updated and aligned to SAP S/4HANA,including embedded analytics and possible impact on SAP BW usageSummary: there will be impacts; don’t under estimate them. Don’t leavethem to the last minute. Don’t assume embedded analytics will solve allneeds. Plan. 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC9
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:With the focus on embedded analytics, where should Ideliver reporting from? Is SAP BW still relevant? Is a data warehouse or Big Data platform still relevant? To what extent can I enhance SAP S/4HANA ABAP CDS views? Does the SAP license impact what I can do and where? Can I virtualize everything and leave data at source?Summary: So many questions, no single answer, butlet’s try to address them Blog: What to do where 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC10
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:With the focus on embedded analytics, where should Ideliver reporting from? Operational / real-time reporting should leverage sourcedata directly wherever possible and that makes sense Reporting tools offer various connection options for “live”reporting The location of plan data will influence Plan vs Actualreporting 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC11
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:Is SAP BW still relevant? The use case for SAP BW is changing, but still relevant If you already have an SAP BW investment, then you shouldcontinue to leverage it The SAP BW focus will change and the reporting requirement willshift. Develop a strategy for this shifting perspective SAP BW addresses complex requirements beyond the capabilitiesor intent of embedded analytics:–––––Data horizonModeling complexityData harmonization requirementsHistorical truth / snap-shotting data / transient attributesPotential performance impacts / no free lunch SAP BW also offers real-time connections and reporting options 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC12
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:Is a data warehouse or Big Data platform still relevant? Yes Actually more so, with the explosion of IoT, blockchain,unstructured data, a central repository beyond transactionaldata is even more relevant The data warehouse need not be SAP BW, but a datawarehouse harmonizing large, disparate, long historical datahorizons, offering deep analytical capabilities without OLTPdisruption is still relevant. However, the architecture andsolution make-up has changed (i.e. cloud, hyper-scalers,Intelligent Enterprise, ) A data warehouse delivering real-time transactionalrequirements can certainly be reviewed with a shift to deliverfrom source (SAP S/4HANA) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC13
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:To what extent can I enhance CDS views? See previous units discussing extensibility Consider your license Consider the comments regarding a data warehouserequirement Be mindful of best practices, released models, model types,performance, Can a visualization tool deliver the capability? 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC14
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:Does the SAP license impact what I can do and where? You should always confirm capabilities and constraints toyour current licensing model SAP S/4HANA is delivered with embedded analytics andextension tools (Week 3, Unit 6) Developing SAP HANA database models withinSAP S/4HANA will be constrained by license considerations The ability to execute virtual calls to external systems mayneed to consider license 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC15
Analytics Solutions and Their Areas of ApplicationThinking about the conversionWhat to do where:Can I virtualize everything and leave data at source? Virtualization in this context refers to developing models in asystem (e.g. SAP S/4HANA or SAP BW) and using thosemodels to retrieve data at runtime from external systems Before virtualization is designed, address the following:–––––––license of all systemslicense of connectionsconnection securityavailability of data in source systemdata volumedata alignment and harmonization Virtualization could be an option, however there areconsiderations before heading down this path. Research well. 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC16
Analytics Solutions and Their Areas of ApplicationAnalytics with SAP S/4HANA – High-level architectureYou have alreadyseen someembedded analytics.Let’s look at thearchitecture now.SAP S/4HANAembeddedanalyticsSAP S/4HANA embedded analytics in the context of SAP ERP SAP HANA Intelligent Technologies 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC17
Analytics Solutions and Their Areas of ApplicationAnalytics with SAP S/4HANA – High-level architectureBUSINESS USERSSAPFRONT SMARTEND d ofContractQUERYBROWSERIncomingSales OrderPOWER USERSANALYTICALFIORI APPSPO Avg.Delivery TimeQUERYDESIGNERSAP FIORIKPIMODELERNon-ManagedPurchasing SpendDEVELOPERSABAPFOR ECLIPSE .SAP S/4HANAVirtual Data Models SAP S/4HANA introduces new user roles How will reports be launched? e.g. SAP Fiori How will these roles align to existing user patterns? Complementary tools can leverage OData andcan extend the visualization offerings,e.g. SAP Analytics Cloud Which embedded analytics tools are in scope? How do these complement other visualization tools? 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC18
Analytics Solutions and Their Areas of ApplicationAnalytics with SAP S/4HANA – High-level architectureSAP S/4HANA(scope of standard delivery)What about:SAP Analytics CloudVisualizationAccessModelingPersistencySAP Fiori UIanalytical apps, reports, KPIs, delivered as part ofSAP S/4HANA, extensible by the customerOData servicesTransient analyticalqueriesSAP Analytics Cloudcan access SAP S/4HANA data directly viathe available Transient analytical queriesSAPAnalyticsCloudAgentSAP Data WarehouseCloudSAP HANACloudConnectorABAP-CDS-Models(for analytical and transactional purposes)Database tables on SAP HANA SAP S/4HANA analytics architecture key components: What is the role of embedded SAP BW? SAP ABAP CDS views Which SAP Fiori reporting tools are in scope? OData services What layers are available for enhancement? Transient analytical query How does this impact where I deliver insights? 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC19
Analytics Solutions and Their Areas of ApplicationConclusionReporting and analytics is not one-size-fits-all; you need to be aware of impactsPlan early, understand scope, technology, approachReporting options are now more diverse, yet a more consistent architecture offersgreater consistency 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC20
Thank you.Contact information:[email protected]
Follow all of SAPwww.sap.com/contactsap 2019 SAP SE 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 ofSAP SE or an SAP affiliate company.The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and itsdistributors contain proprietary software components of other software vendors. National product specifications may vary.These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation orwarranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warrantystatements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty.In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document orany related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation,and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platforms, directions, andfunctionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reasonwithout notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, orfunctionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differmaterially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and theyshould not be relied upon in making purchasing decisions.SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registeredtrademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service namesmentioned are the trademarks of their respective companies.See www.sap.com/copyright for additional trademark information and notices.
Week 4: SAP AnalyticsUnit 2: The Impact on Analytics of a SystemConversion to SAP S/4HANA
The Impact on Analytics of a System Conversion to SAP S/4HANAAgenda The Intelligent Enterprise Planning the high level journey Planning the detailed roadmap Readiness check results Planning and assessing the impact on BW Other areas for consideration What is your reporting and analytics strategy and outlook? What is embedded analytics? Conclusion 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC2
The Impact on Analytics of a System Conversion to SAP S/4HANAThe Intelligent EnterpriseThe Intelligent Enterprisefeatures 3 key components:Manufacturing& Supply Network & SpendManagementIntelligentSuiteIntelligent SuiteIntelligent TechnologiesIntelligent TechnologiesAI/ML / IoT / AnalyticsDigital PlatformDigitalPlatform 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICDataManagementCloudPlatform3
The Impact on Analytics of a System Conversion to SAP S/4HANAPlanning the high level journeyCheckSAP BWstatus quoCheckstatus quoBI /AnalyticsWhat to dowhere?Check SAPS/4HANARebuildandextend 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC4
The Impact on Analytics of a System Conversion to SAP S/4HANAPlanning the detailed roadmap Check extractors What is still working? Usage of BEx? Housekeeping What next? Establish the status quo ofBI/Analytics Data sources changed? Role of Big Data? Housekeeping What next? Separate operational BI/Analyticslayer and EDW Target architecture SAP S/4HANA,SAP BW, and SAP AnalyticsBI/PA/Planning Operational analytical requirements Check content, capabilities inembedded analytics Out-of-the-box? Check content in SAP Analytics New user patterns Plan detailed steps to implement allremaining analytical requirements(e.g. by extending SAP S/4HANA) Influencing factors: individualpreferences, strategy, effort,available functionality 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC5
The Impact on Analytics of a System Conversion to SAP S/4HANAReadiness check resultsReadiness DashboardBW Extractors OverviewBW Extractors DetailsDemo Readiness Check Dashboard 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC6
The Impact on Analytics of a System Conversion to SAP S/4HANAPlanning and assessing the impact on SAP BW Not all SAP ERP data sources are supported inSAP S/4HANA (SAP Note 2500202). Which onesimpact you? How will change in a business process (based onSAP S/4HANA adoption) impact SAP BW design? Willthere be a requirement to retrofit SAP BWtransformation to a new business process? Downstream processes extracting from SAP BW mightbe impacted due to change in unsupported extractors,business process, transformation, numbering(e.g. new chart of accounts) Need to have a plan to deal with unsupportedextractors 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC7
The Impact on Analytics of a System Conversion to SAP S/4HANAPlanning and assessing the impact on SAP BW12341 How-To PPT2 Readiness check XLS3 List of all extractors and status4 Template for your system diagnosis 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC8
The Impact on Analytics of a System Conversion to SAP S/4HANAPlanning and assessing the impact on SAP BW How much effort (and business value) to spenddecommissioning SAP BW reports? Which SAP BW reports can easily be taken over bystandard embedded analytics? Which extractions are replaced with embedded analytics? Simple example question: How/where will financialstatements be produced with a change in SAP S/4HANAand impact on SAP BW? Real-time operational style reports may not be requiredin SAP BW 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC9
The Impact on Analytics of a System Conversion to SAP S/4HANAOther areas for considerationReporting and Analytics in Finance: Classic drilldown (FGI1) works as before, no new views Traditional drilldown (KE30 and KE24) will continue to work Reports in Controlling use “compatibility” views, mostly the same New reports require SAP Fiori Apps activation Existing extractors work, but consider 0FI ACDOCA 10 for complete universal journal extraction There are some great notes to help further: 2349297 – Reporting / Analytics in Controlling 2579584 – Recommendations for Usage of Reports in Financial Reporting in S/4 HANA Drilldown Reports Report Writer / Painter SAP List Viewer (ALV) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC10
The Impact on Analytics of a System Conversion to SAP S/4HANAOther areas for considerationAdditional Considerations: SAP BPC may impact embedded SAP BW setup; consider SAP BPC app usage Where will users execute / launch reports from (Fiori / ) Sizing for embedded analytics (no free lunch) Running SAP HANA Live? See SAP Note: 2270382 – S4TWL – SAP HANA Live Reporting Is BW Unicode compliant, there may be some restrictions and considerations Interoperability consideration, see SAP Note: 2251604 – Version Interoperability SAP S/4HANA On Premise & SAP NetWeaverSystems CDS View as an extractor could resolve unsupported extractors Interoperability consideration, see SAP Note: 2251604 – Version Interoperability between SAP S/4HANA On Premise Edition andSAP NetWeaver Systems 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC11
The Impact on Analytics of a System Conversion to SAP S/4HANAWhat is your reporting and analytics strategy and outlook? Do you have a strategy with regard to SAP S/4HANA,embedded analytics, cloud, UX, reporting tools ? Without an updated strategy in place, even at highlevel, there will be challenges and risk to the journey A strategy will help sketch the future Where are your thoughts:– Phased– Big bang– Steady-as-she-goes– Opportunistic– Hungry for innovation– Low risk, conservative– Culture shift to latest 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC12
The Impact on Analytics of a System Conversion to SAP S/4HANAWhat is embedded analytics?SAP S/4HANA embedded analytics in the context of SAP ERP SAP HANA Intelligent Technologies 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC13
The Impact on Analytics of a System Conversion to SAP S/4HANAWhat is embedded analytics?ModernArchitecture forInstant InsightIntuitive UserExperienceIntelligent ERP NextGenerations BusinessProcessesEasy modeling on simple datamodelsEnablement of fact-driven processhandlingIntegrate intelligent technologiesin process Real-time data availability Combined screens with transactionaland analytical information Integration of predictive and MLdata inside analytical data models Proper prioritization in transactionalprocess steps Embedded decision support Easy drilldown Performant Custom data model extensions(in SAP Fiori) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC Decision support where it is needed(inside the transactional screen) Allow process automation whereneeded14
The Impact on Analytics of a System Conversion to SAP S/4HANAWhat is embedded analytics?BPC for SAP S/4HANAEmbedded AnalyticsBusiness User: SAP Fiori Content/Tools for nsionReportAnalysisOfficeAnalyticalSAP FioriAppsSmartBusiness KPI(generic/APF)OverviewPageAnalytical ListPageList ReportKey User: SAP Fiori Tools for AnalyticsView BrowserCustom CDSViewsCustomAnalyticalQueriesKPI DesignModeler AppsEmbedded BWABAP CDS ViewBWInfoProviderVDMAPFConfigurationModelerReport DesignModeler Apps(CDS View) SAP S/4HANA embedded analytics provides real-time analytics on live transactional data. Embedded analytic reports are provided through standard SAP Fiori applications for multiple user types. BPC for SAP S/4HANA is a planning application in SAP S/4HANA that uses the embedded BW function. It is notincluded in the definition of embedded analytics, but a reporting function is included in this solution. 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC15
The Impact on Analytics of a System Conversion to SAP S/4HANAWhat is embedded analytics?I am the end userTools available to me Multidimensional reports Smart Business KPIs Analysis Path Framework (APF) Query Browser Analytical SAP Fiori applicationsI am the analytics specialist (key user)Tools available to me Manage KPIs and Reports Query Browser View Browser Custom Analytical Queries APF Configuration Modeler applicationAnalytics Specialist SAP Fiori Tiles 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC16
The Impact on Analytics of a System Conversion to SAP S/4HANAConclusion Start planning, it’s never too early Insights can be gained now Don’t under estimate impact and opportunities Embrace the opportunity for a paradigm shift inreporting and analytics “A journey of a thousand miles begins with one step”* what will yours be?* Lao Tzu 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC17
Thank you.Contact information:[email protected]
Follow all of SAPwww.sap.com/contactsap 2019 SAP SE 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 ofSAP SE or an SAP affiliate company.The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and itsdistributors contain proprietary software components of other software vendors. National product specifications may vary.These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation orwarranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warrantystatements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty.In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document orany related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation,and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platforms, directions, andfunctionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reasonwithout notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, orfunctionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differmaterially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and theyshould not be relied upon in making purchasing decisions.SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registeredtrademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service namesmentioned are the trademarks of their respective companies.See www.sap.com/copyright for additional trademark information and notices.
Week 4: SAP AnalyticsUnit 3: Creating a Query
Creating a QueryContent SAP Fiori content for SAP S/4HANA embeddedanalytics overview Custom Analytical Queries app overview Create a new query Select fields Configure fields Add calculated measures Add filters Preview Create an SAP Fiori report tile Demo 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC2
Creating a QuerySAP Fiori content for SAP S/4HANA embedded analyticsSAP Fiori delivers various content offerings to support SAP S/4HANA embedded analyticsSmart Business KPISmart Business APFMultidimensional reportingCreate Query 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICAnalytical ListReport3
Creating a QueryCustom Analytical Queries app overviewEnables business experts tocreate and edit queries requiredfor reporting and analysisPrerequisites:User role required:SAP BR ANALYTICS SPECIALISTPlease refer to SAP Fiori apps reference library:http://www.sap.com/fiori-apps-library 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC4
Creating a QueryCreate a new queryCreating a new query: Define query technicalname Select ABAP CDS Viewas data source Define label name Optional: Copy from anexisting viewAll existing queriesincluding SAP predelivered andcustomized ones 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC5
Creating a QuerySelect fieldsSelecting fields: Fields used in the query to be selected from the data source Define label name aligned to business context Options to remove selected fields 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC6
Creating a QueryConfigure fieldsConfiguring fields: Several options governing field behavior Axis, Dimension Format (Key and/or Text), Override Label, Display option, Hierarchy (ID), etc. Sequence of the rows and columns 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC7
Creating a QueryAdd calculated measuresAdding calculated measure: Label, Decimals, Scaling, Axis and etc. Expression can be maintained tocalculate the measureFunction examples: NODIM, ABS, SUMGT,SUMCT, Case Expression 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC8
Creating a QueryAdd filtersAdding filters: Options for fixed value filters Options for user input valuefilters: Selection Type,Multiple Selection, etc. Selection Type: Single,Interval, Hierarchy Node 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC9
Creating a QueryPreviewPreview: Prompts to be filled Multi-dimensional reports to display the query result 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC10
Creating a QueryCreate an SAP Fiori report tileCreate a tile: Add text elements Nominate group 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC11
Creating a QueryDemo 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC12
Thank you.Contact information:[email protected]
Follow all of SAPwww.sap.com/contactsap 2019 SAP SE 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 ofSAP SE or an SAP affiliate company.The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and itsdistributors contain proprietary software components of other software vendors. National product specifications may vary.These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation orwarranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warrantystatements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty.In particular, SAP SE or its affiliated companies have no obligation t
–Conversion of real-time reporting from SAP BW into embedded analytics –Introduction of new user types in line with embedded analytics –Introduction of embedded analytics tools set –Extensions to CDS views to address additional real-time operational analytics –Alignment to SAP Analytics roadmap t
