BWA - Business Warehouse Accelerator (BW-BEX-OT-BIA)

Introduction

The BW Accelerator enhances SAP NetWeaver BW performance based on SAP's search and classification engine TREX, and on preconfigured hardware delivered by SAP hardware partners. It is packaged as an appliance for use with SAP NetWeaver Business Warehouse (BW) and provides enhanced performance for online analytical processing in an Enterprise Data Warehousing IT scenario. Please have a look at "BWA - Concept and Overview" which provides an overview-description on the BWA.

BWA is based on a client/server architecture. The client component is integrated into the BW-application that uses the TREX-functions and allows communication with the BWA servers. This page will focus on the BWA-topics which concern this client component in the BW-system f.e. connection between BW and BWA, creation of indexing-jobs sending indexing-requests to the BWA-server, etc. Please follow this link for BWA-topics which concern the BWA-server only (f.e. maintaining the TREX-parameters, checking the load-situation in the BWA-server, etc. > component: BC-TRX-BIA).

CSS component: BW-BEX-OT-BIA

SAP Online Documentation

BWA Search

SAP Support Troubleshooting Guideline

SAP Support Guideline: BW-BEX-OT-BIA

BWA Topics

Types of Infoproviders using BWA	Wiki-Page: BWA-only Cubes Analytic Index
Indexing / Indexing Performance	Consulting Notes / KBAs: 1789310 How to run report RSDDTREX_SINGLE_TABLE_INDEX (KBA) 2022826 How to check BWA indexes inconsistency 1871808 BWA indexing statistics data in table RSDDSTATTREX and RSDDSTATTREXSERV 1871790 BWA Troubleshooting: Analyzing Indexing Performance 1161395 Parallelization of data indexing in the BIA 2030254 How to set NUMPROC and BATCHPARA Wiki-Page: Activating and Filling a BWA index Checking BWA Indices BWA Index Design BWA master table index which used to be split is found as one physical index Uneven part of F-Table existed in BWA server Global Parameters for BWA indexing Improving Efficiency for BWA Delta Index Rolling Up Data into BWA Index Statistics for Maintenance Process for BWA BWA - How to check partitioning
High Memory	Consulting Notes / KBAs: 1796356 How to address unloads and memory problems in Business Warehouse Accelerator 1767424 How to verify if your BWA is overloaded?
BWA connection to BW	Consulting notes/KBA 1757655 RFC failure - Cannot register TREX/BIA Registered Server Program with Gateway 1916242 How to simple address RFC issues in BWA 2030187 ICM_HTTP_TIMEOUT error Wiki-Page: 'Kernel error:ICM_HTTP_CONNECTION_FAILED (400)' Communication methods in BWA
BW-Query execution with BWA	Consulting Notes / KBAs: 1168412 Temporary Indexes on BIA with BI 7.X 1060387 Analysis with incorrect results in BIA queries 1018798 Reading large data volumes from BI Accelerator 1161525 Do not use BIA for queries: Setting the NOHPA indicator 1495735 check of changed records between DB and BIA after changerun 2056505 How to proceed in case of "wrong/no data with BWA"-problems 1789331 Analyse and correct wrong data returned by query when BWA is used 2204696 How to identify inconsistent BWA-indexes in the BW query-result [VIDEO] 2196028 How to check the content of a MD-table indexed in the BWA [VIDEO] 1871604 BWA Troubleshooting: Analyse Poor Query performance 1871275 Runtime spent for Query 1858333 Query Execution Mode "2/3" reads more data than "0" Wiki-Page: Partitioning a fact index BWA Query failed with error "overflow in numberic calculation"
Troubleshooting Guidlines	TREXIndexServer crash - BWA Troubleshooting Analyze High CPU Usage - BWA Troubleshooting High Memory Consumption - BWA Troubleshooting Analyze Poor Query performance - BWA Troubleshooting

Page tree