2533361 - Empties partitions remain after selective deletion - SAP BW on ASE

• Selective deletion was run for an infocube, however when you check the partitions using ABAP report RSSYBPARTMON the partitions are there, with 0 rows, ie:

DB table = /BIC/E<table>
Partition type = RANGE
Number of partitions = 122
Estimate number of rows = 345477536
Data change = 4 %
Partition key(s) = SID_0CALMONTH

Partition Name Est. # of rows Condition Data change %
/BIC/E<table>_0000200612 0 VALUES <= (200612) 0  
/BIC/E<table>_0000200701 0 VALUES <= (200701) 0
/BIC/E<table>_0000200702 0 VALUES <= (200702) 0
/BIC/E<table>_0000200703 0 VALUES <= (200703) 0
/BIC/E<table>_0000200704 0 VALUES <= (200704) 0
/BIC/E<table>_0000200705 0 VALUES <= (200705) 0
/BIC/E<table>_0000200706 0 VALUES <= (200706) 0
/BIC/E<table>_0000200707 0 VALUES <= (200707) 0
/BIC/E<table>_0000200708 0 VALUES <= (200708) 0
/BIC/E<table>_0000200709 0 VALUES <= (200709) 0
/BIC/E<table>_0000200710 0 VALUES <= (200710) 0
/BIC/E<table>_0000200711 0 VALUES <= (200711) 0
/BIC/E<table>_0000200712 0 VALUES <= (200712) 0
/BIC/E<table>_0000200801 2774125 VALUES <= (200801) 0      <<<< all partitions with data older than 200801 are empties

• You would like to know how to completely surpress unnecessary empties partitions from E table.

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Business Warehouse - All versions 

merge, deletion, archived, partitions , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem