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
|
|
[email protected]
|
