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.

Why page 28 of the underground manuals still matters in the era of BW/4HANA

Why? Because the HANA calculation engine would try to union the Active table and the Change Log table for every single query. Over time, your "virtual" provider becomes slower than a standard InfoCube. You might be thinking, "BW 7.4 is out of mainstream maintenance. Why does this matter?"

The fix? Rebuild your CompositeProvider as a HANA Calculation View directly in the HANA Studio (or XSA). Then consume it in BW via an External View.