Updating infosource in sap bw usacm liquidating

Posted by / 27-Feb-2020 13:04

When loading a few rows of master data (but less than 499 rows) into the dimension table, the histogram still wrongly contains only one value for the DIMID column (DIMID = 0).

This is the worst case when joining a dimension table with a fact table, because fact tables never contain rows with dimension ID 0.

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

SAP BW queries do not use parameterized SQL statements. However, besides BW queries there are also normal Open SQL queries running on an SAP BW system.

These queries are typically running against administration tables.

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).

Once a dimension table reaches the 500 rows limit, the automatic update statistics runs anyway. It is still a relic from SAP BW 3.5 and older releases: For you can create transfer and update rules, which allow direct staging from a 3.x Data Source into an Info Cube.

updating infosource in sap bw-17updating infosource in sap bw-2updating infosource in sap bw-1