bia - sap product overview
TRANSCRIPT
SAP NetWeaver BI AcceleratorOverview
Alexander PeterProduct Management SAP NetWeaver BI
June 2008
© SAP 2007 / Page 2
Agenda
1. Overview2. BIA Appliance3. BIA Configuration & Administration4. SAP NetWeaver BI Accelerator in Detail5. Service Level Agreements6. Roadmap
© SAP 2008 / Page 3
Opportunities not HarvestedTraditional methods too inflexible, unreliable or not economical
THE TRENDSIncreased adoption of analytics
Data explosion, growing 50% p.a.
Frequent need for change
More users / usage of analytics
Users create queries despite having noknowledge of BI technology
THE CHALLENGESTraditional BI platforms are bottlenecks
Unpredictable response times
Inability to meet demand for change
€ (tuning or boutique hardware)
© SAP 2007 / Page 4
SAP NetWeaver BI AcceleratorValue Proposition
IT
Business
Cost of Operation
Save time to build and maintainaggregates
Save disk space
Take load off BI hardware
Consolidate BI landscape
Performance / Scalability
Ready for high data volumes(retail, utilities, banking etc.)
Challenging response time SLA
Ad-Hoc reporting / stable responsetimes
Scalable blade server platform
Time for Development
Less focus on performanceaspects (aggregates, cachingstrategies, DB tuning etc.)Faster development of new modelsand queries
Data Latency
Extremely shortened roll-up andchange run times
Opportunity for more frequent dataalignments
Compression not always needed
New Business Scenarios
Get more detailed insight into yourbusiness
© SAP 2007 / Page 5
SAP NetWeaver BI Accelerator
SAP NetWeaver BI Accelerator for high performance BI at lowest operation costsA new transparent approach to boost BI query performance
Performance speedup factor between 10 and 100 - also for BusinessObjects clientsWithout changing the BI user experience (transparent to users)Ensures low cost of operationsPrerequisite: BI in SAP NetWeaver 7.0
SAP NetWeaver BI
BusinessWarehouse
CalculationDBMS BIA
Compressed and Column-basedOptimized for Analysis
Agile
Low TCO
Fast to Upload
Bypassedfor queries
Calculation on the fly
Fast as Lightning
Predictable query performance
Any query
© SAP 2007 / Page 6
Terminology
TREX and SAP NetWeaver BI AcceleratorTREX : Search and classification engine, mainly for unstructured dataBI Accelerator is built using TREX technology (indexing, retrieving, compression ...) tohandle structured dataNote: BI Accelerator and TREX are two different installations
The BI Accelerator cannot be used for standard KMC functionalityA TREX installation cannot be used as a BI accelerator
SAP NetWeaver BIAccelerator
TREX for BIA
TREXstandalone
SAP NetWeaver BI
Document /Meta Data
Search
QueryAcceleration
XXXX
© SAP 2007 / Page 7
Terminology – BI Accelerator Index
IndexBI Accelerator index: Structure containing replicated data and indexes (one index pertable) that represents the BI star schema for the BI AcceleratorIndexing: Transfer of InfoCube data to the SAP NetWeaver BI Accelerator server andprocessing and compressing it into the BI Accelerator index
SAP NetWeaver BI SAP NetWeaver BI Accelerator
InfoCubes BI Accelerator IndexDEF
55555
ABC44444
GHI66666
JKL77777
MNO88888
PQR99999
STU1010101010
~ ~ ~ ~ ~ ~ ~Indexing
© SAP 2007 / Page 8
SAP NetWeaver BI Accelerator Architecture
SAP NetWeaver BI
InfoCubes
Data Acquisiton
Analytic Engine
BusinessObjects
BusinessExplorer
Any ClientTool
AnySource
SAP NetWeaverBI Accelerator
Indexing
In-Memory Processing
© SAP 2007 / Page 9
Query Execution
1
2
3
4
SAP NetWeaver BI checks the listed repositories (in the order shown) to obtain the query result.
Query ExecutionWithout BI Accelerator
Query ExecutionWith BI Accelerator
Information Broadcasting /Precalculation
Query Cache
Aggregates
InfoProvider
Information Broadcasting /Precalculation
Query Cache
SAP NetWeaver BI Accelerator
© SAP 2007 / Page 10
BI Performance Techniques:Speed vs. Re-usability
Canned Reports
Query Cache
Summary Tables
Database
SAP NetWeaverBI Accelerator
Perf
orm
ance
Less
fast
Fast
est
Re-usabilityLowest Highest
High re-usability Veryfew specific objects (orsets) can be used toaccelerate many differentqueries
The BI Accelerator offers high re-usability together with fastperformance in a manner not possible with other techniques!
© SAP 2007 / Page 11
Agenda
1. Overview2. BIA Appliance3. BIA Configuration & Administration4. SAP NetWeaver BI Accelerator in Detail5. Service Level Agreements6. Roadmap
© SAP 2007 / Page 12
Appliance Shipment – 1 –
SAP NetWeaver BI Accelerator will only be available as an appliance (“in a box”)Complete SAP NetWeaver BI Accelerator preinstalledOnly little configuration effort by the customer, e.g. indexing relevant InfoCubesAdvantages
Rapid DeploymentPerformance-optimizedMinimized Maintenance
Premium Hardware Partners (as of Q2 2008)Hewlett-PackardIBMFujitsu-SiemensSUN
© SAP 2007 / Page 13
Appliance Shipment – 2 –
Components of the ApplianceStandalone or fit into an existingcustomer rackBlade servers with 64-bit Intel Xeon CPUsLinux SLES, 64-bitOptimized storage includedHigh-Speed Network Switch
Dedicated network betweenBI and BIA
High Availability optionsBuilt-in redundant componentsSynchronized backupSwitchover
Tailored support offers by the hardware partners
Note: SAP NetWeaver BI installation continues to be supported on the platformsdescribed in the PAM (product availability matrix)
SAP NetWeaver BI AcceleratorAppliance
BIASoftware
OperatingSystem
HighAvailability
Blades Storage NetworkSwitch
Tailored Support
© SAP 2007 / Page 14
Benefits of Appliance Shipment
Rapid Deployment
Instantaneous operation
Pre-Installed byhardware vendor
Minimal pre-definedconfigurationrequirements for the BIAsoftware
Simple purchase
Limited variations basedon standard components
Quick Time-to-market
Reduced Costs ofOperation
Minimized maintenance
Centralized monitoringthrough CCMS
Easy scalability throughblade server architecture
Affordable commodityhardware
Reduced license costs for3rd party components
Minimized upgrade risk
Optimized HW/SWsupport offers
Performance &Integration
Optimized hardware/softwareefficiency
Combination of hardwarecomponents and configurationoptimized for high-endperformance and high availability
Assured quality of functionality
Reduced integration effort withhardware and software
Appliance
© SAP 2007 / Page 15
SAP NetWeaver BI Accelerator AppliancePhotos
BIA appliance by IBM BIA appliance by HP
BIA appliance by Fujitsu Siemens
CPUs by Intel
BIA appliance by SUN
© SAP 2007 / Page 16
Purchase and Implementation Process
Pre-requisites1. Upgrade to SAP NetWeaver 7.02. Perform Sizing via QuickSizer (recommendation: use
services provided by SAP AGS “SAP Quality Check”)
PurchasingProcess
1. Contact SAP Account Executive for BIA license2. Contact hardware partner’s AE for ordering
BIA hardware
Installation byHardware Vendor
1. Hardware Partner ships and installs BIA appliance2. Some on-site configuration might be necessary
Post-installationSet-up
1. Identify InfoCubes and index them2. Recommendation: Configuration Check for BIA (as
part of SAP Quality Check for BIA)
For further services provided by SAP AGS or consulting, please see SDN!
© SAP 2007 / Page 17
QuickSizer
BIA Sizing integrated in SAP QuickSizerQuickSizer access: http://service.sap.com/quicksizerCreate Project and select SAP NetWeaver BI
Create a new QuickSizer project, otherwise the BIA options will notappear.Most of the data captured is the same as for SAP NetWeaver BIsizing. If you have already performed a BI sizing, you can Copy &Paste the values for the BIA sizing.
If you already have a BI system (loaded with data), then the programand method described in SAP note 917803 is recommended
Report computes memory requirements and disk space (also runson SAP BW 3.x)
Using the BIA will take load off of the SAP NetWeaver BI system. Asthis load reduction depends on several detailed factors (such as shareof query time spent in analytic engine, size of result set, number ofusers etc.), this reduction has not been captured in the SAPNetWeaver BI sizing.Refer to Thread on SDN posted by Marc Bernard for some additionalinfo
https://forums.sdn.sap.com/thread.jspa?threadID=776332&tstart=0
© SAP 2007 / Page 18
Hardware Sizing
SizingHardware sizing
Hardware partner translates the resultsof SAP QuickSizer into optimalconfiguration of hardwareHigh availability setup:Extra blade(s) required as backup forautomatic failover
Valid for production and test systemPossibly less rigid performancerequirements for test systemsoptional sharing of resources (see ‘BIAin non-production environments’)
Important note: sizing has to be adjusted once new InfoCubes are indexed by BIA thathaven’t been taken into account for the original sizing
© SAP 2007 / Page 19
BIA Sizing now in SAP QuickSizer
SAP QuickSizer can now capture sizing information for BIAhttp://service.sap.com/quicksizer > Create Project and select SAP
NetWeaver BI
Most of the data captured is the same as for BI sizing. If you havealready performed a BI sizing, you can Copy & Paste the values for theBIA sizing.
You must create a new QuickSizer project, otherwise the BIA optionswill not appear.
If you already have a BI system (loaded with data), then the programand method described in SAP note 917803 is recommended
Refer to Thread on SDN posted by Marc Bernard for some additionalinfo
https://forums.sdn.sap.com/thread.jspa?threadID=776332&tstart=0
© SAP 2007 / Page 20
High-End Scalability withSAP NetWeaver BI Accelerator
Jupiter – Executive SummarySAP NetWeaver BI Accelerator ready for rapidly growing data volumeNo scalability limits identified (tested up to 140 blades)Proven manageability of large-scale SAP NetWeaver BI installationsImpressive throughput – for both writing and reading BIA indexesHigh reliability
Jupiter Facts25 TB InfoCube data (corresponds to overall 50-70 TB data warehouse)
Total of 78 InfoCubes, 30 billion rows135 IBM HS21 blades (2 dual-core CPUs, 16GB)
17 TB storagePlus 5 backup blades not needed, as there were no hardware outages
Further InformationWinterCorp whitepaper: https://www.sdn.sap.com/irj/sdn/bia
© SAP 2007 / Page 21
Appliance FAQMemory
Which memory setup is supported for BIA blades?See matrix for release status of blade generation and memory.32 GB Harpertown (quad-core) blades are currently in certification process. See SAP note 1161765 forrelease status per hardware partner.For mid-size customers, the HW partners offer one XS configuration consisting of 8GB blades. Thisoffering provides best value at reasonable hardware and license costs.Any combination of blade generations can be used in the same BIA system. See SAP note 1163149 formore details.
Irwingdale(single-core)
Woodcrest(dual-core)
Clovertown(quad-core)
Harpertown(quad-core)
8 GB(for mid-size
offering)(for mid-size
offering)(for mid-size
offering)
16 GB
32 GBSee SAP note
1161765 for details
© SAP 2007 / Page 22
Appliance FAQStorage
Why is the storage part of the BIA appliance?The storage as part of the appliance has some significant advantages:
Rapid and instantaneous deployment (preinstalled hardware and minimal configurationeffort)Optimal performance configuration through highly integrated hardware and softwaresetupReduced cost of operation (minimized and centralized maintenance)Support only involves SAP and the HW partner, not a third party – support can behighly specialized and tailored on the complete offeringHigh Availability (switch-over) may depend on the storage and cannot be offered out-of-the-box using other storage systems
© SAP 2007 / Page 23
Appliance FAQOptimizing the Appliance Investment
I have done some investments into the blade infrastructure. How can I optimizethis infrastructure?
An existing rack including the power source can be used for all SAP NetWeaver BIAccelerator and SAP NetWeaver Enterprise Search appliances.
Appliances are available in several sizes. Be sure to choose the right size under thefollowing aspects
Do not undersize the system in order to be prepared for the futureDo not oversize the system to avoid investments into ‘empty’ and unused hardware.
Performance, supportability, high availability, security etc. can only be guaranteed by bothSAP and hardware partners, if you strictly stick to the appliance set-upNote: any changes to the standard appliance set-up require additional effort and aseparate project; a pre-installed delivery from factory cannot be guaranteed. Performance,supportability, high availability etc. have to be ensured by the customer and/or theimplementation partner.
Rack BladeCenter /Enclosure
Bladeholds several holds several
© SAP 2007 / Page 24
Appliance FAQBI-BIA Connection
Do I need 1:1 relationship between BI and BIA?The only supported configuration for productive systems is a 1:1 connection between theBI instance and the BI accelerator to ensure uncompromised performance of BIA.In order to maximize the value of the investment, you can install several BIA instances inone rack – utilizing the existing infrastructure. For production systems, it is required tohave dedicated storage (disk controller) and network connection (switch) to ensure thathigh load on one BIA instance is not impacting performance of the other instance.Several BIA instances can be installed in one BladeCenter/enclosure on project basis.
Rack
BIA Instance
BIA Instance
SAP NetWeaver BI
SAP NetWeaver BI
© SAP 2007 / Page 25
Appliance FAQSharing the Blade Infrastructure
What further options do I have for test environments?Ideally, the components of the infrastructure are exactly sized to the system needs, so that there is noneed to deviate from the appliance definition.Note again: any changes to the standard appliance set-up require additional effort/costs and a separateproject; a pre-installed delivery from factory cannot be guaranteed.As non-productive systems typically have less requirements towards high performance and disastertolerance, following components may be shared on project basis:
Storage and network connection (in addition to rack and BladeCenter/enclosure)Blades, only if you do not need several test BIA systems in parallel (but sequentially)– Note that only one active BIA installation per blade is supported at a time (is connected to exactly
one BI instance)– You can install several (inactive) BIA systems on one blade– Activate the BIA system that you need for a given period of time and rebuild the BIA index on it
(for more information, please refer to SAP note 979609)
Note that reorganization or restart of one BIA instance may affect all connected BI systems.
BIA
SAP NetWeaver BITest System 1
Connection week 1
Connection week 2SAP NetWeaver BI
Test System 2
© SAP 2007 / Page 26
Appliance FAQMaintenance and Support
Who maintains and supports hardware, software and OS of the BIA?BIA software support is included in the SAP service feeAdditional support contracts are highly recommended:
Hardware partner offers contracts for hardware maintenance; ask for tailored BIA support offersNovell offers enhanced support for SUSE Linux in collaboration with SAP Linux Lab ('SUSE PrioritySupport for SAP'). This offer facilitates communication and ensures seamless support at highquality particularly for BIA customers. Please check www.novell.com/sapsupport for moreinformation.
The maintenance and support process is organized in the same manner as other SAP productsSoftware issues are handled by SAP, and the link to hardware partners is via Linux Lab.The customer is responsible for applying patches and support packages or for contracting this workto third parties.Note that OS patches need to be released by the HW partner!
SAPHardwarePartner *
Novell *
SAPLinuxLab
BIA Issue
CustomerMessage
If issue notin BIA software
If issue caused by OS
If issue caused byhardware or network* : An additional support contract is necessary; this is not included
in the SAP support fee.
© SAP 2007 / Page 27
Agenda
1. Overview2. BIA Appliance3. BIA Configuration & Administration4. SAP NetWeaver BI Accelerator in Detail5. Service Level Agreements6. Roadmap
© SAP 2007 / Page 28
BI Accelerator Index Maintenance – 1 –
Accessing BI Accelerator Index MaintenanceSimilar to aggregatemaintenance viacontext menu for aparticular InfoCubeOr direct access viatransaction RSDDV
© SAP 2007 / Page 29
BI Accelerator Index Maintenance – 2 –
Index WizardCreation, filling, deletion of BI accelerator indexes via easy-to-use wizard
© SAP 2007 / Page 30
SAP NetWeaver BI Accelerator – Roll-up
Roll-upUpdate of newly loaded data to BIAccelerator indexSimilar to roll-up process for aggregatesOnly one BI Accelerator index, highlyparallel very fast processSame process for BI Accelerator andaggregates: no need to change of processchains
SAP NetWeaver BI Accelerator
BIA Index
Delta
Delta Load
© SAP 2007 / Page 31
SAP NetWeaver BI Accelerator – Change Run
Change RunUpdate BI Accelerator index after masterdata/hierarchy changesBI Accelerator index has same granularity asthe InfoCube
No changes needed fortransactional data
Update of master data tables as part of BIAccelerator index minimal runtimeNo update needed for changed key date oftime-dependent attributesSame process for BI Accelerator andaggregates: no need to change of processchains
SAP NetWeaver BI Accelerator
BIA Index
Old Master Data New Master Data
© SAP 2007 / Page 32
BI Accelerator Administration Tool – 1 –
SAP NetWeaver BI Accelerator Goal: Minimal AdministrationRSDDBIAMON
Central monitoring and administration toolIndex SettingsPossible actions– Restart BIA server: restarts all the BI accelerator servers and services. This
includes the name server and index server– Restart BIA index server: restarts the index server. (The name servers are not
restarted.)– Reorganize BIA landscape: If the BI accelerator server landscape is unevenly
distributed, this action redistributes the loaded indexes on the BI acceleratorservers
– Rebuild BIA indexes: If a check discovers inconsistencies in the indexes, you canuse this action to delete and rebuild all the BI accelerator indexes.
Checks– Connection Check– Index Check– Etc.
© SAP 2007 / Page 33
BI Accelerator Administration Tool – 2 –
© SAP 2007 / Page 34
BI Accelerator Administration Tool – 3 –
RFC Destination for the BI systemIf not maintained, BI accelerator monitor asks for configuration details (otherwise: checktransaction RSCUSTA for the correct setting)
© SAP 2007 / Page 35
BI Accelerator Data Consistency Check Center
Start Check Center from BIA monitor> Go to > Consistency Checks
Start Check Center from BIA monitor> Go to > Consistency Checks
Five different types of checks are available and can be scheduled.Click on the info button for more details.
Five different types of checks are available and can be scheduled.Click on the info button for more details.
© SAP 2007 / Page 36
BI Accelerator RSRV Checks
Consistency Checks
PerformanceChecks
IndexRepair
Compounded Test
System Information
© SAP 2007 / Page 37
Useful SAP Notes
Useful SAP NotesCompatibility of NW BI SPS and BIA revision
SAP Note 1148111Database Fallback for BIA
SAP Note 940635Estimation of memory consumption
SAP Note 917803
© SAP 2007 / Page 38
Agenda
1. Overview2. BIA Appliance3. BIA Configuration & Administration4. SAP NetWeaver BI Accelerator in Detail5. Service Level Agreements6. Roadmap
© SAP 2007 / Page 39
BI Accelerator Index Build Time
SAP NetWeaver BI
InfoCubes
Data Acquisiton
Analytic Engine
BusinessObjects
BusinessExplorer
Any ClientTool
AnySource
SAP NetWeaverBI Accelerator
Indexing
In-Memory Processing
Parallel indexingof InfoCube
data viastandard BIprocesses
Column-based storage& compression tominimize memory
footprint of BIAccelerator indexes
© SAP 2007 / Page 40
BI Accelerator Initial Load Into Main Memory
SAP NetWeaver BI
InfoCubes
Data Acquisiton
Analytic Engine
BusinessObjects
BusinessExplorer
Any ClientTool
AnySource
SAP NetWeaverBI Accelerator
Indexing
In-Memory Processing
Initial load ofindexes into
memory for entirein-memoryprocesing
© SAP 2007 / Page 41
BI Accelerator Query Run Time
SAP NetWeaver BI
InfoCubes
Data Acquisiton
Analytic Engine
BusinessObjects
BusinessExplorer
Any ClientTool
AnySource
SAP NetWeaverBI Accelerator
Indexing
In-Memory ProcessingOn-the-fly aggregation
Merging and resultspreparation for BI queries
© SAP 2007 / Page 42
BI Accelerator for Planning
SAP NetWeaver BI
PlanBuffer/Caches
(Memory)
Data Acquisiton
Analytic Engine
BusinessObjects
BusinessExplorer
Any ClientTool
AnySource
SAP NetWeaverBI Accelerator
Indexing
In-Memory Processing
Real-TimeInfoCubes
(openrequest)
Real-TimeInfoCubes
(closedrequest)
StandardInfoCubes
© SAP 2007 / Page 43
BI Acceleratorstores tables by column
To find all instances of an attribute value:Go to the attribute columnRead its row values
BI Accelerator Architecture:Vertical Decomposition
Classical DBstores tables by row
To find all instances of an attribute value:Go to the first rowCheck the attribute valueGo to the next rowCheck the attribute valueRepeat for each row in the table
If you don’t havea predefined indexready you can waita long time …
Tuple1
Tuple2 Att1 Att2 Att3 Att5Att4
© SAP 2007 / Page 44
BI Accelerator Architecture:Horizontal Partitioning
Scenario: Adding a new node BI Accelerator Monitor enables easyre-distribution
IndexMetadata
IndexMetadata
IndexMetadata
IndexMetadata
. . . .
Index
Part. 01
Part. 02…
Part. N
Part. 01
Part. 02…
Part. N
Metadata
Fact Table
LargeTables
Storage
PhysicalIndexServer
PhysicalIndexServer
PhysicalIndexServer
Automatic assignmentto nodes
LogicalIndexServer
TREX Services
© SAP 2007 / Page 45
BI Accelerator Architecture:Smart Compression
CompressionDictionary-based compression
Size of table keys significantly reducedAverage compression as rule of thumb: 10 (Lab result)SAP NetWeaver BI Accelerator can handle huge data volumes in main memory (withoutneed for costly disk accesses)Note: only BIA index parts necessary for the query need to be loaded into main memory(Hybrid dynamic index)
© SAP 2007 / Page 46
BI Accelerator Architecture:Summary
BI Accelerator QueriesAutomatically join required indexes asspecified in the BI Accelerator indexAggregate large amounts of data inparallelRestrict aggregated rows with booleanquery expressionsProcess more than one booleanexpression at once
Very fast aggregation algorithmExploits integer coding formax speed and min I/ODesigned to run on latest blade serversand grid landscapesOptimizes usage of memory and cacheresourcesOptimized for BI
Compressed memory indexMany million documents can fit in1 GB memoryStores by column (not by row)Can split indexes horizontally for parallelprocessing
Hybrid dynamic indexEnables indexing of huge volumesof structured dataKeeps only required columns in memory
© SAP 2007 / Page 47
Agenda
1. Overview2. BIA Appliance3. BIA Configuration & Administration4. SAP NetWeaver BI Accelerator in Detail5. Service Level Agreements6. Roadmap
© SAP 2007 / Page 48
Ensuring Service Level Agreements – 1 –
ScenariosScheduled maintenance work
Hardware maintenance: blade, storage system, networkSoftware maintenance: OS or BIA patchingLandscape changes: removing or adding blades
Unplanned downtime of hardware componentsOne or more bladesStorageSwitches, controller etc.
Backup and RecoverySoftware errors: corrupt files, destroyed index
Disaster RecoverySevere hardware failuresNatural hazards (fire, earthquake, ...) or terrorism
© SAP 2007 / Page 49
Ensuring Service Level Agreements – 2 –
SAP NetWeaver BI Accelerator FeaturesHigh Availability
Redundant hardware components: power supply, switches, controller etc.RAID-5 to ensure operation after failure of one disk (in the disk array)Optional spare blade(s)– Automatic activation of backup blade and automatic re-distribution of index after failure
(during BIA downtime, queries go directly to the database)Standard fallback to database if BIA is unavailable
Email alertSAP Notes 940635, 1097529 and 1094309
Backup and RecoverySynchronous BIA backup/recovery
Disaster ToleranceSwitch-over
Further informationSAP Developer Network– SAP NetWeaver Business Intelligence BI Accelerator
BI Accelerator (BIA) High Availability (PDF, 1.3 MB)SAP Note 984034
© SAP 2007 / Page 50
Backup / Recovery
Backup / RecoveryScenarios
Severe hardware issues with the BI acceleratorLogical errorsPoint-in-time recovery of the BI database (e.g. database corrupt, load of wrong data,unintentional deletion etc.)Also usable when switching to new BIA hardware use recovery instead of re-indexing
ConceptBackup of BIA files using synch points that are also kept in BI to ensure consistentrecoveryIndependent from HW providerNote: BIA recovery is not a point-in-time recovery, but automatically recovers to the latestavailable point-in-time in the BI database
StatusIn Pilot phasePlanned release in Q3 / 2008
© SAP 2007 / Page 51
Backup / RecoveryDetails – Backup
BackupExport all committed data in the BIA server at a given time
New data in the BIA is copied to backup files at defined snapshot timesExpected export runtime depends on the export frequency and the amount of data writtenbetween two exports - ~ 1 minuteData loads to BIA are automatically on hold during exports
Unique ID for exported data setID and a timestamp are determined and stored in BI
Exported data can be saved on any storage
© SAP 2007 / Page 52
Backup / RecoveryDetails – Recovery
RestoreScenarios:
1. Problem with the BIA fix problem or move to another BIA hardware2. Problem with the BI point-in-time recovery of BI database
ProcedureImport a saved export to a BI accelerator– Must be older than the BI database restore in case of a point-in-time recovery
RecoveryTrigger recovery process for BI accelerator in the NetWeaver BI system from the BIA monitor
Data loads to the BIA are automatically on hold during importsBI checks ID of the export data set and the related timestamp– Unchanged indexes in the BIA remain untouched,– Deltas are derived whenever possible (e.g. new requests in fact indexes),– Changed masterdata indexes must be rebuilt
Re-indexing is reduced to the absolute minimumRuntime of the recovery process depends on the backup frequency and the data changes between twobackups
BI accelerator is available again and in-sync with BI database
© SAP 2007 / Page 53
Backup / RecoveryExample 1
BI
BI Accelerator
Backup
Backup
Rollup
Data Load
Backup
Data Load
Rollup
Time
Backup
Example 1: BIA Crash
BIA crashesFix hardware problem
Restore BIAAutomatic recovery to the current BI status
BIACrash
Restore Delta
© SAP 2007 / Page 54
Backup / RecoveryExample 2
BI
BI Accelerator
Backup
Backup
Rollup
Data Load
Backup
Data Load
Rollup
Time
Backup
Example 2: BI Crash
BI crashesFix hardware problemApply point-in-time recovery of BI database
Restore BIAAutomatic recovery to the current BI statusManual recovery of BI and BIA status
BICrash
Point-in-timerecovery
Restore Manual Recovery
Manual Recovery
© SAP 2007 / Page 55
Disaster ToleranceSwitch-over
Hardware-Based Switch-Over ConceptScenarios
One data center fails (due to fire, power outage, earthquake, terrorist attack etc.)Concept
Redundant data center (including redundant BIA appliance)Synchronous mirroringDifferent concepts per hardware vendor– HP: integration into cluster manager, reconfiguration via script after switch-over– IBM: GPFS-based switch-over using BIA master-/backup-server concept
StatusOffering by hardware partnerCurrently in pilot phasePlanned for Q3 2008 (after successful pilots per HW vendor)
© SAP 2007 / Page 56
Disaster ToleranceSwitch-over HP Concept
HP Concept2 independent landscapesSwitch is triggered by a script
Mounts standby landscape and changes index configuration (e.g. hostnames)
Data Center 1 Data Center 2
SAP NetWeaver BIA Appliance SAP NetWeaver BIA Appliance
SAP NetWeaver BI SAP NetWeaver BI
Database Database
Storage System
Blade
Blade
Blade
Blade
M-Blade
M-Blade
M-Blade
Storage System
M-Blade
Switchover
Mirroring ConvertIndex
Configuration(* dependingHW partner)
Mirroring
B-Blade
B-Blade
B-Blade
B-BladePROXY
*
© SAP 2007 / Page 57
Disaster ToleranceSwitch-over IBM Concept
IBM ConceptMaster in Data Center 1, Slave in Data Center 2Strong network connectionOne mount point GPFS via SAN no real switch
Data Center 1 Data Center 2
SAP NetWeaver BIA Appliance SAP NetWeaver BIA Appliance
SAP NetWeaver BI SAP NetWeaver BI
Database Database
Storage System
B-Blade
B-Blade
B-Blade
B-Blade
M-Blade
M-Blade
M-Blade
Storage System
M-Blade
Failure
Mirroring e.g. GPFSvia SAN
Mirroring /Cluster
One landscape /network
© SAP 2007 / Page 58
Agenda
1. Overview2. BIA Appliance3. BIA Configuration & Administration4. SAP NetWeaver BI Accelerator in Detail5. Service Level Agreements6. Roadmap
The outlook presented here is a preliminary version and notsubject to your license agreement or any other agreement withSAP. This document contains only intended strategies,developments, and functionalities of the SAP® product and is notintended to be binding upon SAP to any particular course ofbusiness, product strategy, and/or development. Please note thatthis document is subject to change and may be changed by SAPat any time without notice. SAP assumes no responsibility forerrors or omissions in this document.”
© SAP 2007 / Page 59
Key PointsTurn-key solution for BI performanceBreaking down the barrier between structural flexibility and performanceCommodity hardware based appliance
SAP NetWeaver BI –Roadmap for BI Accelerator
2009/20102008
SAP NetWeaverBI Accelerator
Existing Solution
Analytic Capabilities (e.g. top n)DataStore Object AccelerationSeamless integration with SAP’snext generation advanced analysisclient (code-named Pioneer)Standalone BIA for source-independent acceleration viaBusiness ObjectsAgile BI: Local and source-independent innovation space fordepartments
Accelerator for InfoCubeRead TimesLow Cost of OperationsHigh Availability /Backup & Recovery
Optimized BusinessObjectsWebl integration on top ofSAP NetWeaver BI/BIABusinessObjects Polestarintegration: Self-Service BIbased on search paradigm
High Performance BI
PREM
IUM
© SAP 2007 / Page 60
SAP NetWeaver BI Accelerator Roadmap – 1 –BusinessObjects Polestar
BusinessObjects Polestar and SAP NetWeaver BI Accelerator – a perfect matchEasy, intuitive information exploration and analysis for business usersBring self-service BI for business and casual usersGet fast facts and answer investigative questionsExplore and understand new data sources and unexamined parts of the businessNo need to understand the data,where it's located, or how it's structuredRely on proven performance and scalabilityof SAP NetWeaver BI Accelerator
© SAP 2007 / Page 61
SAP NetWeaver BI Accelerator Roadmap – 2 –DataStore Object Index
data latency
OLTP-basedAnalytics
BI-basedAnalytics
Traditionalbehavior
Typical SynchronizationFrequency: 24 Hours
SAP NetWeaver Business Intelligence
OLTP
TransactionalDelta
InfoCubew/ BI Accelerator
HybridProvider
Real-Time Query
99%1% Real-Time Data
Real-TimeUpdate
HybridProviderEnsures real-time informationCombines latest OLTP delta with strategic data kept in a BIA storeOptionally bypassing InfoCube database persistencyBIA index on (standard) DataStore Objects
Avg.response
time
OLTP-based
Analytics
BI-based Analytics
<1 min latency
© SAP 2007 / Page 62
SAP NetWeaver BI Accelerator Roadmap – 3 –From BIA to BI Server Appliance / Newton (*)
BI Server Appliance / Newton (*)Stand-alone Analytic EngineSource-agnostic
Deployable on any source(data warehouse, ERP source)‘Universe Accelerator’
Light-weight modelingAnalytic Capabilities
Top N/Bottom NCount distinctMultiProvider aggregationEtc.
Planning CapabilitiesEnhanced Lifecycle Management
Live Update
(*) preliminaryCodename
SAP NetWeaverBI Accelerator / Newton (*)
Calculation Engine
Aggregation EngineIndex
SAP NetWeaver BI
Business Warehouse
BusinessObjects BI Platform
Pioneer (*) WebIntelligence …Polestar
BO Enterprise
(Inbound)Universe
DataIntegrator
© SAP 2007 / Page 63
BI Appliance
Explorenew models
ChangeModel
SAP NetWeaver BI Accelerator Roadmap – 4 –From BIA to BI Server Appliance / Newton (*)
Agile Business IntelligenceSource-agnosticAccess data models from productionSimple modeling environment for changing andextending modelsCentral maintenance and governanceLocal innovation spaces for departmentsSafe, reliable & scalable environment for rapidbusiness insight and innovationPropagate new proven models backinto production
Production
Innovation
ERP2005 data
BusinessWarehouse
ProductionReporting
New model
Model
© SAP 2007 / Page 64
SAP NetWeaverBI Accelerator / Newton (*)
Calculation Engine
Aggregation EngineIndex
Pioneer (*)
SAP NetWeaver BI Accelerator Roadmap – 5 –Newton (*) & BusinessObjects Pioneer (*)
BO Enterprise VersionNetWeaver Version
BI Consumer Service(*) preliminary
Codename
State-of-the art analytic engine andSAP’s next-generation advancedanalysis client
Combines intuitive data analysis withpowerful in-memory analytic engineTight integration of analytic engine andClient
Currency conversionConstant selectionTime dependant hierarchies…
High Speed Analysis on any data sourcePioneer for web and for Microsoft Excel
SAP NetWeaver BI
Business Warehouse
BO Enterprise
(Inbound) Universe
Data Integrator
Newton (*)
© SAP 2007 / Page 65
SAP NetWeaver BI Accelerator &Business Objects
SAP NetWeaver BI Accelerator for high performance BI at lowest operation costsWithout changing the BI user experience (transparent to users)
SAP NetWeaver BI
BusinessWarehouse
Data Marts
BIA
Calculation
DataStoreObjects
SAP Business Suite
InfoSets
BusinessObjects Enterprise
WebI
XCelsius
Crystal
BusinessObjects Enterprise
PoleStar Calculation
BO Enterprise
(Inbound) Universe
Data Integrator
BIA
© SAP 2007 / Page 66
Thank you!
© SAP 2007 / Page 67
SAP NetWeaver BI AcceleratorOther Resources
SDNhttps://www.sdn.sap.com/irj/sdn/bia
Standard PresentationFAQForumOperations ManualHigh Availability Roadmap
SMARThttp://smartdirectory.sap.corp:3080/Assets/Asset.epx?Id=34617d39-112d-45f0-be0e-a8170194b385
Service Marketplacehttp://service.sap.com/bi
© SAP 2007 / Page 68
Secondary colors100%
Primary colors100%
RGB 158/48/57
Tertiary color
Definition and halftone values of colors
RGB 68/105/125
RGB 96/127/143
RGB 125/150/164
RGB 152/173/183
RGB 180/195/203
RGB 4/53/123 RGB 240/171/0 RGB 102/102/102RGB 153/153/153RGB 204/204/204
RGB 21/101/112
RGB 98/146/147
RGB 127/166/167
RGB 154/185/185
RGB 181/204/204
RGB 85/118/48
RGB 110/138/79
RGB 136/160/111
RGB 162/180/141
RGB 187/200/172
RGB 119/74/57
RGB 140/101/87
RGB 161/129/118
RGB 181/156/147
RGB 201/183/176
RGB 100/68/89
RGB 123/96/114
RGB 147/125/139
RGB 170/152/164
RGB 193/180/189
RGB 73/108/96
RGB 101/129/120
RGB 129/152/144
RGB 156/174/168
RGB 183/196/191
RGB 129/110/44
RGB 148/132/75
RGB 167/154/108
RGB 186/176/139
RGB 205/197/171
RGB 132/76/84
RGB 150/103/110
RGB 169/130/136
RGB 188/157/162
RGB 206/183/187
85%
70%
55%
40%
RGB 158/48/57
85%
70%
55%
40%
100%
© SAP 2007 / Page 69
Copyright 2008 SAP AGAll 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. The information contained herein may be changedwithout prior notice.Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, Duet, Business ByDesign, ByDesign, PartnerEdge and other SAP products and services mentioned herein as well as theirrespective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned andassociated logos displayed are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.
The information in this document is proprietary to SAP. This document is a preliminary version and not subject to your license agreement or any other agreement with SAP. This documentcontains only intended strategies, developments, and functionalities of the SAP® product and is not intended to be binding upon SAP to any particular course of business, product strategy,and/or development. SAP assumes no responsibility for errors or omissions in this document. SAP does not warrant the accuracy or completeness of the information, text, graphics, links, orother items contained within this material. This document is provided without a warranty of any kind, either express or implied, including but not limited to the implied warranties ofmerchantability, fitness for a particular purpose, or non-infringement.
SAP shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of these materials. This limitationshall not apply in cases of intent or gross negligence.The statutory liability for personal injury and defective products is not affected. SAP has no control over the information that you may access through the use of hot links contained in thesematerials and does not endorse your use of third-party Web pages nor provide any warranty whatsoever relating to third-party Web pages
Weitergabe und Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu welchem Zweck und in welcher Form auch immer, ohne die ausdrückliche schriftliche Genehmigung durchSAP AG nicht gestattet. In dieser Publikation enthaltene Informationen können ohne vorherige Ankündigung geändert werden.Einige von der SAP AG und deren Vertriebspartnern vertriebene Softwareprodukte können Softwarekomponenten umfassen, die Eigentum anderer Softwarehersteller sind.SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, Duet, Business ByDesign, ByDesign, PartnerEdge und andere in diesem Dokument erwähnte SAP-Produkte und Servicessowie die dazugehörigen Logos sind Marken oder eingetragene Marken der SAP AG in Deutschland und in mehreren anderen Ländern weltweit. Alle anderen in diesem Dokument erwähntenNamen von Produkten und Services sowie die damit verbundenen Firmenlogos sind Marken der jeweiligen Unternehmen. Die Angaben im Text sind unverbindlich und dienen lediglich zuInformationszwecken. Produkte können länderspezifische Unterschiede aufweisen.
Die in diesem Dokument enthaltenen Informationen sind Eigentum von SAP. Dieses Dokument ist eine Vorabversion und unterliegt nicht Ihrer Lizenzvereinbarung oder einer anderenVereinbarung mit SAP. Dieses Dokument enthält nur vorgesehene Strategien, Entwicklungen und Funktionen des SAP®-Produkts und ist für SAP nicht bindend, einen bestimmtenGeschäftsweg, eine Produktstrategie bzw. -entwicklung einzuschlagen. SAP übernimmt keine Verantwortung für Fehler oder Auslassungen in diesen Materialien. SAP garantiert nicht dieRichtigkeit oder Vollständigkeit der Informationen, Texte, Grafiken, Links oder anderer in diesen Materialien enthaltenen Elemente. Diese Publikation wird ohne jegliche Gewähr, wederausdrücklich noch stillschweigend, bereitgestellt. Dies gilt u. a., aber nicht ausschließlich, hinsichtlich der Gewährleistung der Marktgängigkeit und der Eignung für einen bestimmten Zwecksowie für die Gewährleistung der Nichtverletzung geltenden Rechts.
SAP übernimmt keine Haftung für Schäden jeglicher Art, einschließlich und ohne Einschränkung für direkte, spezielle, indirekte oder Folgeschäden im Zusammenhang mit der Verwendungdieser Unterlagen. Diese Einschränkung gilt nicht bei Vorsatz oder grober Fahrlässigkeit.Die gesetzliche Haftung bei Personenschäden oder die Produkthaftung bleibt unberührt. Die Informationen, auf die Sie möglicherweise über die in diesem Material enthaltenen Hotlinkszugreifen, unterliegen nicht dem Einfluss von SAP, und SAP unterstützt nicht die Nutzung von Internetseiten Dritter durch Sie und gibt keinerlei Gewährleistungen oder Zusagen überInternetseiten Dritter ab.
Alle Rechte vorbehalten.