Solution : https://service.sap.com/sap/support/notes/514907 (SAP Service marketplace login required)
Key words :
SQL, star transformation, database optimizer, Oracle, MSSQL, DB2 UDB, Informix, SAP DB, /BI0/0P
Related Notes :
| 1139396 | Temporary database objects in BW 7.X |
| 1103409 | DB2-z/OS:BI: Queries split from query splitter are very slow |
| 1075225 | Performance Improvement during Infocube Extraction in Batch |
| 1013912 | FAQ: Oracle BW performance |
| 903627 | SQL error when you execute queries in parallel |
| 852849 | SAPSQL_INVALID_FIELDNAME DT~TC001 on infocube read |
| 811354 | Use of complex Queries slows down database system |
| 799465 | Datamart on partitioned Infocube returns SQL Syntax Error |
| 567995 | Incorrect time/date in a query or Datamart |
| 567747 | Composite note BW 3.x performance: Extraction & loading |
| 565086 | Composite SAP note: Wrong or no data in DataMart or Query |
| 551464 | Short dump UNCAUGHT EXCEPTION CX_RSR_X_MESSAGE |
| 544006 | SAPSQL_INVALID_FIELDNAME DT~CALMONTH error |
| 536223 | Activating master data with navigation attributes |
| 520821 | WRITE_DDIC_INFO-6-/SAPSQL_INVALID_FIELDNAME error |
| 458722 | SAPBWNews BW 3.0B Support Package 01 |
| 456566 | SAPBWNews BW 2.1C Support Package 16 |
| 456551 | SAPBWNews BW 2.0B Support Package 24 |
| 452632 | SAPBWNews BW 3.0A Support Package 08 |
| 449891 | Temporary database objects in BW 3.x |
| 390016 | DB2/390: BW: Database settings and performance |