Solution : https://service.sap.com/sap/support/notes/374464 (SAP Service marketplace login required)
Key words :
terms optimizer statistics runstats analyze z-table h-table reason, optimizer chooses bad access plans, z-tables solution apply bw 2, /3 profile parameter dbs/db6/bw_stats_on_tmp_tables =, statistics takes additional time, delete existing temporary objects, 46c basis support package 15, hierarchy result tables /bi0/02, 46d basis support package 5, z-tables /bi0/01
Related Notes :
| 456568 | SAPBWNews BW 2.1C Support Package 17 |
| 414728 | SAPBWNews BW 2.1C Support Package 12 |
| 374502 | DB6: DB2 UDB - BW Performance - Overview of notes |