Semantic Layer! Major features missing: dynamic parameters, enforced parameters upon field selection, dynamic SQL generation (using params)

All in the title. A semantic layer such as SAP Business Objects universes is the BASIS for self-service BI. Exists for over 30 years now, and MS does not even have dynamically populated prompts. Frus...