Hi all, At the beginning of 2022, Kylin community discussed the positioning of multidimensional databases and the idea of building a business semantic layer based on Kylin. After a period of development and testing, we are pleased to announce that Kylin community has released a technical preview version of "MDX for Kylin", an MDX query engine which supports Apache Kylin 4.X as Data Source. MDX for Kylin allows Kylin users to use Excel to analyze big data. "MDX for Kylin" is developed based on Mondrian[Link3], and it is contributed by Kyligence. The user experience of "MDX for Kylin" is close to Microsoft SSAS, and it can integrate a variety of data analysis tools, including Microsoft Excel, Tableau, etc. "MDX for Kylin" provides a more extreme experience for big data analysis scenarios. Please refer to the link to learn and try: https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html.
Further reading 1. https://lists.apache.org/thread/4fkhyw1fyf0jg5cb18v7vxyqbn6vm3zv 2. 如何使用 Excel 查询 Kylin?MDX for Kylin! 3. https://mondrian.pentaho.com/documentation/mdx.php 4. https://docs.microsoft.com/en-us/sql/mdx/mdx-syntax-elements-mdx 5. https://dba.stackexchange.com/questions/138311/good-example-of-mdx-vs-sql-for-analytical-queries 6. https://kyligence.io/blog/opportunities-for-ssas-in-the-cloud/ 7. https://kyligence.io/blog/semantic-layer-the-bi-trend-you-dont-want-to-miss-in-2020/ 8. https://docs.kyligence.io/books/mdx/v1.3/en/index.html 9. https://medium.com/airbnb-engineering/how-airbnb-achieved-metric-consistency-at-scale-f23cc53dea70 | | Mukvin | | boyboys...@163.com |