Status:
Needs Votes
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...
Totally agree. This was the key competitive advantage that BO had for many years before SAP got their hands on it and side-tracked on to integrating BO and SAP BW. If MS introduced a semantic layer like BO universes that could be used with Power BI, SSRS and Report Builder, it would blow BO out of the water in the SME field - my recent experience of SAP customer support suggests that you need a seven-figure budget to get anything prioritized. MS started SQL Server buy getting hold of a copy of the Sybase codebase - buying their old XI3.1 universe designer codebase wouldn't be a bad place to start.
