《HANA水晶报表培训.pptx》由会员分享,可在线阅读,更多相关《HANA水晶报表培训.pptx(20页珍藏版)》请在三一文库上搜索。
1、BW on HANA,Thomas ZurekVP for R&D SAP Business WarehouseFebruary 2011,SAP-internal &confidential,Disclaimer,This presentation outlines our general product direction and should not be relied on in making a purchase decision. This presentation is not subject to your license agreement or any other agre
2、ement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release any functionality mentioned in this presentation. This presentation and SAPs strategy and possible future developments are subject to change and may be changed by SAP at any
3、time for any reason without notice. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibility for errors or omissio
4、ns in this document, except if such damages were caused by SAP intentionally or grossly negligent.,Agenda,HANA ScenariosWhat HANA means for BWORANGE Scope HighlightsExamples for X Y Q & A,HANA Scenarios Overview,ERP,BW,side-by-side,operational data marts,agile data marts,on-top,EDW + architected dat
5、a marts,OLTP + operational analytics,X DB,BW,BWA,BOBJ / Excel,BW today, :install HANArebuild all BWA indexes (= schedule one program in BW) :standard DB migration,new,This color indicates that a new version (upgrade or SP) is mandatory to support this scenario.,Agenda,HANA ScenariosWhat HANA means f
6、or BWORANGE Scope HighlightsExamples for X Y Q & A,RDBMS Data Warehousing In-MemoryThe EDW Equations,Today:EDW = RDBMS + X e.g. with X = BWNow:RDBMS HANAHANA SQL, MDX, in-memoryThus:EDW = HANA + Y with Y = new BWThis means: HANA replaces RDBMS, not BW HANA complements & renovates BWfor more details
7、see SDN blog: http:/,BW on HANA Overview,Agenda,HANA ScenariosWhat HANA means for BWORANGE Scope HighlightsExamples for X Y Q & A,Evolving In-Memory Footprint in SAP BWOverview,Planning Engine,Data Manager,InfoCubes,DataStore Objects,Analytic Engine,Data Persistency and Runtime,Data Modeling,Enterpr
8、ise Data Warehouse and Data Mart Modeling with SAP NetWeaver BW,BWA instead of aggregates,filter + aggregation,BWA-only InfoCubes,BWA reportingfor DSOs,reporting + activation for DSOs in-memory,in-memory planning engine,first calculation scenarios in BWA,additionalcalculations in-memory,MultiProvide
9、r handling and flexible joins,BW 7.0DB + BWA 7.0,BW 7.3DB + BWA 7.2,BW 7.3 on HANA(and beyond),EDW Processes,first EDW processingin-memory,ORANGE Scope Highlights,new (flat) infocube BWA-based functionality remains available DB migration in-memory based DSO in-memory based BW-IP (incl. TPM-related r
10、equirements) integrate free-style artifacts (e.g. created via HANA studio) BW workspaces HANA-specific properties in BW meta data (e.g. hot cold data),Corp.Memory,ODS,Data Mart,Data Warehouse,Business transform,End-user access / Presentation,Provide data,Data Acquisition,Harmonization,Data Propagati
11、on,Reporting,Main Service: Spot for apps/Delta to app/App recoveryTransform: Enriched | General Business logicContent: Data source | Business domain specific History: Determined by rebuild requirements of appsStore: DSO(can be logical partitioned),Main Service: Decouple, Fast load and distribute Tra
12、nsform: 1:1Content: 1 data source, All fields History: 4 weeksStore: PSA, DSO-WO.,Main Service: Integrated, harmonized Transform: Harmonize quality assure (in flow| lookup)Content: Defined fieldsHistory: Short or not at all | Long termStore: Info source | IO/DSO/Z-table,Main Service: Make data avail
13、able for reporting tools Transform: Application specific/(dis-)aggregate/lookupContent: Application specific History: Application specific Store: IC,DSO, Info Set, Virtual Provider, Multi Provider.,Layered Scalable Architecture Real World Example,Source 1,Source 2,Source 3,Source 4,Source 5,Project
14、Governance,ETR Governance,Agenda,HANA ScenariosWhat HANA means for BWORANGE Scope HighlightsExamples for X Y Q & A,DB + BWA ICE,BW on (DB + BWA)2 DB servers2 DB licensesmove data to BWA to achieve fast reportingsome redundancy DB + BWAphysical data movementspro: data layers decoupled via servers, e.
15、g. no conflict data load queryACID propertiesonly in DBnot in BWA planning / write-back,BW on HANA1 DB server1 DB licenseno special effort to guarantee fast reporting on any DB object(s)no redundancyopportunity to use logical data mappings instead of physical data movements full ACID support in ICE,
16、In-Memory PlanningSimple Disaggregation Example,Traditional ApproachDetermine the delta +50Disaggregate (in appl. server)per week (52)per branch (500) 26000 combinations / valuesSend 26000 values to DB to save,HANA-Based ApproachDetermine the delta +50Send 1 value to DB + instruction to disaggregate
17、 and howDisaggregate (in DB engine)per week (52)per branch (500) create + save 26000 values,In-Memory PlanningSimple Disaggregation Example,Traditional ApproachDetermine the delta +50Disaggregate (in appl. server)per week (52)per branch (500) 26000 combinations / valuesSend 26000 values to DB to sav
18、e,HANA-Based ApproachDetermine the delta +50Send 1 value to DB + instruction to disaggregate and howDisaggregate (in DB engine)per week (52)per branch (500) create + save 26000 values,Todays Data Store Object (DSO),Data Store Objects (DSOs) are fundamental building blocks for a DW architecture.There
19、 are 4 operations on a DSO:upload (of new data)activate (future image current image)querying (the current image)delta upload (for delta feeds)In todays RDBMS-based implementation, the activate and querying operations are extremely performance-critical.These can be highly optimized in ICE.,CurrentIma
20、ge,DeltaImage,upload,activate,DSO,querying,delta upload,FutureImage,On an RDBMS, each image corresponds to a table.,In-Memory Based DSO,The DSO in HANA is a closed objects with the options toindex-read (a snapshot of the data)delta-read (delta btw 2 snapshots)uploadactivateThe 4 DSO operations are m
21、apped:upload activate querying = index-read (current snapshot)delta upload = delta-read (snapshot1, snapshot2)Fundamental advantages:excellent querying performancehighly optimized activation,MainIndex,HistoryIndex,DeltaIndex,upload,index-read (snapshot),move,move,mappinglog,delta-read (snapshot1, snapshot2),Insert-OnlyIndex,activate,New DSO,Agenda,HANA ScenariosWhat HANA means for BWORANGE Scope HighlightsExamples for X Y Q & A,Thank You!,