Solution : https://service.sap.com/sap/support/notes/869407 (SAP Service marketplace login required)
Summary :
This SAP Note outlines support and implementation details for SQL Server and SAP releases concerning table partitioning, especially in relation to SAP Business Warehouse (BW). SQL Server has supported table partitioning since its 2005 version, but earlier limits restricted partitions to 1,000 per table, a constraint lifted in later versions, which now support up to 15,000 partitions. Partitioning within SAP BW enhances data load speed, query performance, and system administration efficiency. Key implementations include partitioning of F-Fact tables by P-Dimension, E-Fact tables by time characteristics, and PSA tables by the PARTNO column. The note also provides essential links to other SAP notes for error fixes and recommends system configurations for optimal partitioning implementation.
Key words :
terms partition create drop function scheme alter table merge switch split rsdd_mssql_cubeanalyzersdu_table_drop_partition_mssmss_drop_partition_from_tablemss_trunc_partition_from_tablersdu_fact_requid_deleteerror 11406 error 7719sap bw bi biw reason, sql 2012 ee / rtm 15000 ee = enterprise edition dc = datacenter edition sp = service pack rtm = release, number partitions sql 2005 ee / rtm 1000 sql 2008 ee / rtm 1000 sql 2008 ee / sp2 15000, dc / rtm 1000 sql 2008 r2 ee, sql server edition/minimum sp max, sap business warehouse minimum sp sap bw 3, resulting screen choose settings -> expert mode, solved withsql server 2005 sp3sql server 2008 sp1, bw service pack sapkw70013, sap strategic enterprise management
Related Notes :
| 1471910 | SQL Server Partitioning in System Copies and DB Migrations |
| 1444413 | BW tables not partitioned after SQL 2008 migration |
| 1427804 | RSDU_TABLE_TRUNC_PARTITION_MSS -ALTER TABLE SWITCH failed |
| 1422251 | Inconsistency after cube compression |
| 1392181 | Deadlocks when using SQL Server Partitioning |
| 1299865 | DB Shadow tables with '@k' name (e.g. /BIC/B0000201@k0) |
| 1080120 | SQL-ERROR when deleting requests or during compression |
| 1076022 | Release planning for Microsoft SQL Server 2008 (R2) |
| 991372 | Selective deletion from InfoCubes takes a long time |
| 991014 | (Vardecimal) Compression for SQL Server 2005 SP 2 |
| 960504 | Potential data loss after migrating BW 3.5 from ORA to MSSQL |
| 943088 | Repartitioning feature is not accessible from RSA1 |
| 888210 | NW 7.**: System copy (supplementary note) |