What is bwa in sap

Here comes the BWA component for reducing the query time dramatically and increasing the performance. BWA creates the data as indexes in a compressed format. When we execute a query in first time the corresponding data will be stored in main memory and next time data will be retrieved from this main memory instead of doing the fetch operation in data source. This data will remain in memory until we delete that using special programs. If you want to use the search function as well as BW Accelerator, you need two separate installations.

This is because the master data tables stored in the BW Accelerator server can be used by multiple BW accelerator indexes. However, this does not work if the data is distributed across various BW Accelerator servers. If you want to run BW Accelerators with productive and test systems in a system landscape, we recommend using a separate BW Accelerator server for each BW system.

How easy is it to get queries to run faster? You might be wondering what happens if the BWA ever goes down. Well, the BW environment is smart enough to automatically check to see if the BWA index on a specific cube is active or not. If it is inactive, the user that is running the query will hit the database rather than read from the BWA index.

The data will still be accessible via traditional database queries, just not at BWA speeds! The BW system always takes precedence and is smart enough to know the BWA is more of a bolt on device. The BW 7. If the BWA is version 7. Well, not directly… A feature has been added to BW 7.