Page 28 would have scolded you: "Index maintenance is not a monthly job. It is a post-load job." The practical guide’s 28th page probably had a flowchart. On one side: Advanced DSO . On the other: CompositeProvider . In the middle: Open ODS Views .
For years, a quiet, dog-eared document circulated among senior BW consultants: a PDF simply titled "SAP BW 7.4 Practical Guide." And within that guide, was the threshold. sap bw 7.4 practical guide pdf 28
Run transaction ST04 (DBACOCKPIT). Look for "High Wait Time on Locks." Then, run RSRT with the technical name of your slowest query. Turn on "HANA Execution Details." Page 28 would have scolded you: "Index maintenance
In older BW releases, the system was brilliant at navigating via SID tables. In 7.4 on HANA, the game changed. The guide would warn you: "Stop forcing HANA to behave like an OLAP processor." On the other: CompositeProvider
Have your own page 28 story from BW 7.4? Share your worst "HANA hangover" tale in the comments below.
If you have administered or developed on SAP BW 7.4 (the last great "classic" BW release before the HANA-only revolution), you know the truth: It was a hybrid beast.