WIXLIB

EA208 - SAP BusinessObjects BI4 Tips andTricks for Optimized SAP HANA ReportingHarjeet Judge,Debraj Roy/Customer Experience GroupPublic

Legal DisclaimerThe information in this presentation is confidential and proprietary to SAP and may not be disclosed without thepermission of SAP. This presentation is not subject to your license agreement or any other service or subscriptionagreement with SAP. SAP has no obligation to pursue any course of business outlined in this document or any relatedpresentation, or to develop or release any functionality mentioned therein. This document, or any related presentationand SAP's strategy and possible future developments, products and or platforms directions and functionality are allsubject to change and may be changed by SAP at any time for any reason without notice. The information in thisdocument is not a commitment, promise or legal obligation to deliver any material, code or functionality. Thisdocument is provided without a warranty of any kind, either express or implied, including but not limited to, the impliedwarranties of merchantability, fitness for a particular purpose, or non-infringement. This document is for informationalpurposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in thisdocument, except if such damages were caused by SAP s willful misconduct or gross negligence.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,which speak only as of their dates, and they should not be relied upon in making purchasing decisions. 2014 SAP SE or an SAP affiliate company. All rights reserved.Public2

Agenda What is SAP HANA SAP HANA Access Methods Semantic Layer on HANA SAP BI Clients Demo Wrap-up 2014 SAP SE or an SAP affiliate company. All rights reserved.Public3

What Is SAP HANA?

Today's WorldDataWarehouse nto TransactionalSystemAggregationBatch transfer toData WarehouseLimited flexibility due topre-defined data structuresLong query run-timesLoss of detailReportingChallengesLong Wait times for reportsLarge VolumesHigh Impact 2014 SAP SE or an SAP affiliate company. All rights reserved.Public5

What if this would all happen real-time?SAP HANAIN-MEMORYNo Aggregation / No Data Staging / No Data Marts'Real Life'BusinessTransactionAnalysis and InsightActionReal-timeLoading intoSAP HANA 2014 SAP SE or an SAP affiliate company. All rights reserved.High PerformanceLarge VolumeData ProcessingFast, flexible and detailanalytics over largevolumesPublic6

SAP HANA Access Methods

SAP BusinessObjects BI access to HANADirect accessAnalysis Office,Analysis OLAPSAP HANADatabaseExplorerLumira,Predictive AnalysisDirect accessDesign StudioInformationModelsCrystal ReportsEnterpriseTablesNote: Direct access background technologies mightvary (SQL via JDBC, via ODBC, BICS, MDX, etc.) thecommon criteria is that the access methodology istransparent to the final user of the tool 2014 SAP SE or an SAP affiliate company. All rights reserved.Public8

SAP BusinessObjects BI access to HANAFree-hand SQLSAP HANADatabaseExtended SQLCrystal Reports2011/2013InformationModelsCrystal ReportsEnterpriseSQLTablesNote: Free-hand SQL access is available via ODBC and JDBCmiddlewares 2014 SAP SE or an SAP affiliate company. All rights reserved.Public9

SAP BusinessObjects BI access to HANAUniverse basedSAP HANADatabaseDashboardsCrystal ReportsEnterpriseUniverseWeb IntelligenceExtended SQLInformationModelsSQLTablesNote: Universe access is available via ODBC and JDBCmiddlewares 2014 SAP SE or an SAP affiliate company. All rights reserved.Public10

Semantic Layer on HANAAccess to SAP HANA – BI 4.1BI 4.1 DSL clients can access SAP HANA through relational universes andmultidimensional direct access Single source and multisourceCR for EnterpriseDashboard DesignSAP HANAMDXInformation ModelsExplorer *SQLSQLUNIVERSEWeb IntelligenceSEMANTIC LAYERCR for EnterpriseDIRECTACCEESS Full support of HANA information models (analytic views and calculation views)HANA STUDIOVisual Intelligence *Predictive Analysis ** Can also access universesSQLTables 2014 SAP SE or an SAP affiliate company. All rights reserved.Public11

Semantic Layer on HANA

Semantic Layer on HANATwo questions Should I build my universe on information modelsor on tables? How to make sure my universe on HANA has agood performance? 2014 SAP SE or an SAP affiliate company. All rights reserved.Public13

Semantic Layer on HANAHANA Engines For best performance, SAP recommendsleveraging the OLAP engine foraggregating large volumes of data. Depending on which database object youquery against, the engine that runs atquery execution time varies The engine selection does not depend onwhich query language you use 2014 SAP SE or an SAP affiliate company. All rights reserved.Public14

Semantic Layer on HANABuilding a universe on Information ModelsProsCons The work done in HANA studio is reusedThe same models can be used in Analysis or ExplorerThe appropriate HANA engines optimize the query executionProgrammatic calculation views allow more complex levels of data manipulation thanuniverses (e.g. L or R language) Some SQL constraints apply to information models which impact the ad-hoc queryexperience Programmatic calculation views are fully executed even if not all metadata isrequested 2014 SAP SE or an SAP affiliate company. All rights reserved.Public15

Semantic Layer on HANABenefitsRelational universes Automatic business layer generation: limited administration, no need to modify the business layer Universe customizations: reorganization, renaming, calculations, metadata security, etc. Multiple views in a single universe: one single access pointMultidimensional access No need to create a universe, no added administration Full support of SAP HANA multidimensional capabilitiesGenerate merged multi-views universe Use a universe wizard to generate a data foundation and business layer on top of multiple SAP HANA views Any dimensions and attributes that are common to different views are created as a single business layer object,and special aggregate-aware objects are generated to make queries on multiple views possible Powerful query generation while preserving SAP HANA performance 2014 SAP SE or an SAP affiliate company. All rights reserved.Public16

Semantic Layer on HANAUniverse Performance Tuning “Array fetch size” value:o Default is 10 but it can be raisedhigher (max 1000) for betterperformanceo Higher values run faster queries butneed more memory Ensure query synchronization isperformed in HANA and not in the clienttoolo Set Join by SQL Yes in DataFoundation. 2014 SAP SE or an SAP affiliate company. All rights reserved.Public17

Semantic Layer on HANAUniverse Performance Tuning Enable Query Stripping in Universeo Performance improvement forWebI reports on relationaluniverseso Optimally reduced queries onHANA views and agnostic RDBMSo New setting in relational universeintroduced in BI 4.1 beenintroduced 2014 SAP SE or an SAP affiliate company. All rights reserved.Public18

SAP BI Clients

SAP Web IntelligenceWeb Intelligence is an interactive reporting tool that can access relational as well asmultidimensional data sources via the concept of Universes. The reports can be viewed onlineor offline thanks to the microcube, an embedded local in-memory cache engine (microcube). Incase of Hana, WebI will access it through relational access using SQL Enables off-line (microcube) as well as interactive analysis (e.g,HANA)Access to heterogeneous data sourcesBasic dashboarding capabilities (Drill, CVOM charts, dynamic filters)Advanced Reporting capabilities (Desktop Rich Client, DHTML, Mobile) 2014 SAP SE or an SAP affiliate company. All rights reserved.Public20

SAP Web Intelligence with SAP HANABenefits With traditional databases, when huge volume of data needs to be queried, aggregate tables might need to becreated to overcome performance degradations, not with SAP HANA Another inconvenience is that you might wait for the next ETL load to have up-to-date data Thanks to SAP HANA in-memory engine and replication capabilities, the data is aggregated on-the-fly in realtime and the user gets “live” data every time he/she accesses or drills into the report 2014 SAP SE or an SAP affiliate company. All rights reserved.Public21

SAP Crystal Reports EnterpriseSAP HANA access and benefits Direct access to SAP HANA using amultidimensional access. Hierarchies support Member selector Full support of SAP HANA in SQL mode usingrelational universes 2014 SAP SE or an SAP affiliate company. All rights reserved.Public22

SAP LumiraSAP HANA access and benefitsOnline access using relational connection Time and geography hierarchiesOffline access using relational connection:data cached in SAP Sybase IQ Semantic enrichment, calculations, time andgeography hierarchies Data manipulation Datasets merge 2014 SAP SE or an SAP affiliate company. All rights reserved.Public23

Demos

Demo ContentDemo 1: Universe HANA Multiview Access multiple HANA views and synchronize the datasets locallyDemo 2: Web Intelligence optimization for HANA: Query Stripping Make sure your report is SAP HANA optimized by “stripping” your query. Push calculations down to SAP HANA and retrieve only the results.Demo 3: Web Intelligence optimization for HANA: Query Drill Enable drill workflows to make the most of SAP HANA performanceDemo 4: Crystal Enterprise on HANA Create an OLAP connection on SAP HANA Create a multidimensional document with Crystal Reports for EnterpriseDemo 5: SAP Lumira on HANA Perform data discovery directly on HANA and implement different visualizations 2014 SAP SE or an SAP affiliate company. All rights reserved.Public25

Wrap-Up

Further InformationSAP Public Webscn.sap.comwww.sap.comFrequently Asked Question: WebIntelligence on HANABest Practices: WebIntelligence on HANACreating Relational Universes: Best PracticesBest Practices: Creating a universe on SAP HANASAP Education and Certification Opportunitieswww.sap.com/educationWatch SAP TechEd Onlinewww.sapteched.com/online 2014 SAP SE or an SAP affiliate company. All rights reserved.Public27

Thank youContact information:Debraj Roymail to: debraj.roy@sap.comHarjeet JudgeHarjeet.Judge@sap.comCEG – Customer Experience Group 2014 SAP SE or an SAP affiliate company. All rights reserved.

SAP d-code Virtual Hands-on Workshops and SAP d-code OnlineContinue your SAP d-code education after the event!SAP d-code Virtual Hands-on WorkshopsSAP d-code Online Access hands-on workshops post-event Starting January 2015 Complementary with your SAP d-code registration Access replays of keynotes, Demo Jam, SAP d-codelive interviews, select lecture sessions, and more! Hands-on replayshttp://sapdcodehandson.sap.com 2014 SAP SE or an SAP affiliate company. All rights reserved.http://sapdcode.com/onlinePublic29

FeedbackPlease complete your session evaluation forEA208.Thanks for attending this d-code session. Public3030