Skip to Content
0
Former Member
Nov 15, 2012 at 12:45 PM

Request deletion issue in BW7.3

35 Views

The situation is as follows. BW system was upgraded from version BW3.5 to BW7.3. After a few months it was recognized that database size growth is much faster then expected. It occured that certain infocubes contain much more data then expected. After futher investigation it was found that there is a deletion process running for those infocubes which deletes overlapping requests. No errors were reported but looking at infocube content and size it looked like no data was phisically deleted. The issue is a follows:

- request deletion from the cube causes only deletion of the relative DIMID from the Dimension table - it doesn't matter, if it is deletion of the overlapping requests planned via process chains or in infopackage , or even if the request is deleted directly from the cube via Administration view. In all case request It disappears from the administration view but stays in the fact table. Reporting is OK because dimension tables are used first why quering.

- I executed FM: RSCDS_DEL_OLD_REQUESTS and the cube was cleared from the incorrect records for which no DIMIDs were found in the respective DIMENSION table but the cause of the problem was not found

- the database is Oracle 11.2.0.3.0

- the cube is not partitioned

- the upgrade was generally successful but no migration of the flows to the 7.x version was done yet