Updating infosource in sap bw

Once you run into this issue (because you did not run update statistics in a BW process chain), you can .

If you load further data into the cube, the number of rows in the dimension table can increase.

As a result, it looks the same for ORACLE, DB2, Sybase and SQL Server.

The SAP BW Info Source is a concept which used to be mandatory in a 3.x dataflow.

It is a view that had to be created between the Data Source and Info Provider, to map the SAP fields to Info Objects.

For a typical ERP system this is not an issue, because for small tables the execution plan does not matter anyway.

However, in SAP BW we typically join small tables (which potentially have less than 500 rows) with very large fact tables (having hundreds of million rows).

Search for updating infosource in sap bw:

updating infosource in sap bw-21updating infosource in sap bw-66updating infosource in sap bw-87updating infosource in sap bw-61

However, in many cases an additional update statistics is not necessary any more, since the histogram is good enough (it already contains several valid values for DIMID besides 0).

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating infosource in sap bw”