Excel Your KPIs with AI Copilot Start for free today
Your AI Copilot for Data
Definitive Guide to Decision Intelligence
Subscribe to our newsletter>
Get the latest products updates, community events and other news.
Have you ever tried analyzing 10 billion rows of data in Excel? Or ad-hoc analysis over 100 dimensions on top of that data volume?
I bet that would not be a happy experience as you would have to waste a lot of time just waiting for Excel to crunch the numbers and crash and recover from it. The same process goes over and over and over again. You will have to wait several minutes or even hours before getting the results.
Traditional OLAP engines, such as SQL Server Analysis Service(SSAS), provide multidimensional analysis capability and can connect with Excel. However, SSAS falls short of computing billions of rows of data.
All that can be ended today! Introducing Distributed MDX Engine, the Kyligence Cloud's enhanced semantic layer architecture, with which data analysis in Excel or any BI tools would be faster than ever, even with over hundreds of concurrent users.
Kyligence Cloud provides an enhanced semantic layer and MDX service that connects to BI tools with the model defined in Kyligence. Distributed MDX Engine is an advanced feature that can boost the performance of Kyligence MDX. It is shipped with a built-in Spark cluster, so the MDX service can execute queries in a distributed Spark cluster. That's where the name came from.
By providing Spark-based MDX services, Kyligence Cloud provides stable MDX services for high concurrency and compute-intensive scenarios. Distributed MDX Engine can handle data at petabyte scale, and by combining powerful abilities offered by Smart Tiered Storage, it effectively improves the performance of detailed analysis, Ad-hoc query, and other scenarios, in addition to aggregated analysis.
From here on, everything will be centered on the self-service analysis of big data.
What's more, If you haven't read our previous blog about Opportunities for SSAS in the Cloud, here is the quick recap of the benefits you can get from Kyligence's semantic layer on the Cloud:
Thanks to the high concurrency of the Distributed MDX Engine, the response time (from query trigger to report refresh) will be greatly shortened. What's more, because the computation is pushed down to the Spark cluster, memory in the MDX application node can be released, hence query stability is improved. While for SAAS or other OLAP products that rely on the memory engine, they are easy to hit the memory bottleneck.
This is the architecture diagram of Kyligence Cloud with Distributed MDX Engine enabled.
Each MDX application node corresponds to a Spark cluster, and it supports scaling. You can set multiple MDX application nodes according to business needs, or achieve high availability.
MDX queries from the BI side will be routed to the new engine according to certain rules. As the picture demonstrates, MDX queries will be answered by Distributed MDX Engine if the patterns and functions are matched and the Spark cluster is working.
Distributed MDX Engine can greatly improve efficiency in:
You can easily enable the Distributed MDX Engine in Kyligence Cloud with simple clicks.
As the picture shows below, you can turn on the MDX application node and Distributed MDX cluster options on the cluster setting page.
Distributed MDX Engine empowers your team to make better decisions based on vast amounts of data. Business users can continue to use Excel to analyze data, and they won't even be aware of the existence of such Distributed MDX Engine, while the performance in the Excel pivot table of the extra-large dataset can be better than ever.
With Kyligence's semantic layer powered by the distributed MDX engine, you can easily implement the capabilities of OLAP on the cloud while migrating off from your traditional OLAP such as SSAS or AAS, and then enjoy managed distributed scalable query performance.
Stay tuned for in-coming features!
You might be interested:
How to connect Excel to ClickHouse within Kyligence Tiered Storage
Why OLAP Persists in the Era of Big Data Analytics
SSAS Disadvantages: Opportunities for SSAS in the Cloud Era
Learn about the fundamentals of a data product and how we help build better data products with real customer success stories.
Unlock potentials of analytics query accelerators for swift data processing and insights from cloud data lakes. Explore advanced features of Kyligence Zen.
Optimize data analytics with AWS S3. Leverage large language models and accelerate decision-making.
Optimize data analytics with Snowflake's Data Copilot. Leverage large language models and accelerate decision-making.
Discover the 7 top AI analytics tools! Learn about their pros, cons, and pricing, and choose the best one to transform your business.
Discover operational and executive SaaS metrics that matter for customers success, importance, and why you should track them with Kyligence Zen.
Unlock the future of augmented analytics with this must-read blog. Discover the top 5 tools that are reshaping the analytics landscape.
What website metrics matter in business? Learn about categories, vital website metrics, how to measure them, and how Kyligence simplifies it.
99 Almaden Boulevard Suite #663
San Jose, CA 95113
+1 (669) 256-3378
Ⓒ 2023 Kyligence, Inc. All rights reserved.
Already have an account? Click here to login
A complete product experience
A guided demo of the whole process, from data import, modeling to analysis, by our data experts.
Q&A session with industry experts
Our data experts will answer your questions about customized solutions.
Please fill in your contact information.We'll get back to you in 1-2 business days.