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.
Microsoft's SSAS is one of the most widely used OLAP engines globally. SSAS has many excellent features that have made it ideal for many traditional business intelligence solutions. But it has faced increasing challenges in the era of big data, especially with BI applications. This article will introduce several alternative solutions to SSAS and their technical criteria that you may consider in the cloud-first era.
Business analysts use a variety of tools to analyze data. There are many traditional OLAP engines, among which Microsoft SQL Server Analysis Services (SSAS) is one of the most widely used in the world. In the family of Microsoft SQL Server, SSAS comes up as an excellent data mining and multidimensional online analytical processing (OLAP) tool, especially for BI applications. It facilitates users in designing, creating, and managing multidimensional structures/mining models with data collected from disparate data sources/relational databases and with the help of data mining algorithms. This offers an augmented level of decision-making for better business output. Many large enterprises are deep and longtime users of SSAS. But it has faced increasing challenges in the era of big data. These challenges have become particularly acute with the explosive growth of data volumes.
The longtime success of SSAS has resulted in creating a tremendous amount of value in terms of the creation and organization of structured data (cubes). But SSAS has experienced a bit of its success crisis. As companies relied more and more on SSAS, the explosive growth in data volumes stressed its single server architecture to the breaking point. At the same time, BI and analytics teams have raised expectations for processing massive datasets with the new era of cloud platforms and big data tools.
Poor handling of large data volumes and dimensions
The SSAS multidimensional mode has acceptable performance with small volumes of data, but performance suffers when querying or cubing large datasets, especially with many dimensions. Like most of the other MOLAP solutions, SSAS pre-calculates every intersection of the dimension combination by all measures, resulting in the curse of dimensionality. The cube can become so large that it cannot be calculated within a reasonable time frame.
Lack of Scalability: The Limitations of Single-Server Architecture
Existing SSAS processing capabilities have run into the natural limitations of single-server architecture. To improve performance, you have no choice but to scale up with larger, high-end, multi-core servers with more RAM, and faster, larger disks. But there is no escaping the architectural limits of a scale-up strategy for SSAS. Unfortunately, there is no notion of an SSAS cluster for scale-out.
An Inability to Handle Cloud-Era User Concurrency
Another limitation of a single server architecture is the ability to support large numbers of concurrent users. SSAS may struggle or fail when too many users query at the same time. Once again, a distributed architecture could provide improved concurrency. With the growth of the citizen data scientist phenomenon, the need to support more and more concurrent users will become a critical requirement of any future analytics architecture.
Today, with big data technology evolving, an ideal BI/OLAP analysis architecture should retain all SSAS analysis capabilities and leverage the scale-out capability of a big data approach. This could address all of the pain points that SSAS faces. In addition, such architecture should enable the following:
There are many alternative solutions to SSAS that you may consider in the big data era: Distributed OLAP Limitations of traditional OLAP led many to look to new, big data approaches to analytics that took advantage of distributed computing (e.g., compute clusters). Among these was eBay, which decided to tackle the problem of implementing a distributed OLAP technology that would feature the many benefits of traditional OLAP, like fast performance and support for multidimensional queries. The resulting technology eventually became the Apache Kylin project, the first and only open-source distributed OLAP platform. Kyligence was formed in order to create an enterprise-grade commercial product based on Apache Kylin. Data Virtualization Because OLAP is usually found in the data services layer of a data pipeline, it is helpful to understand other alternative technologies that live in this layer. For example, one of this layer's common analytics technologies is Data Virtualization (DV). Both distributed OLAP and DV are trying to address the same challenge: reducing time to value by making analytics easily accessible to a broader audience in a cloud or data lake environment. Cloud OLAP platforms like Kyligence use precomputation to improve performance, response times, and concurrency in the production environment. In addition, precomputation strategies tend to reduce pressure on the source systems. They are deployed when data quality and data governance are factors, and security needs to be de-coupled from the sources. Data Virtualization technology focuses on rapid deployment and eliminating some of the IT processes associated with loading data into a data warehouse or otherwise structuring the data. Instead, users can simply connect to various data sources such as files, RDBMS, and NoSQL DBs and build a 'virtual' view which is exposed to the front-end BI layer. There is no data warehouse to be designed, no ETL jobs to be scheduled, all queries happen on demand the moment a user clicks in the BI tools (and the SQL query is fired). Data virtualization solutions can struggle when too many concurrent queries are executed due to either growing user bases or growing data volumes. For analytical workloads, the cloud OLAP has a serious advantage in this area. Massively Parallel Processing Cloud warehouses like Snowflake and Azure Synapse use massively parallel processing (MPP) architectures to parallelize query processing. Snowflake has succeeded in disruption by delivering used-to-be-on-premise data warehouses on the cloud. The promise of MPP cloud data warehouses like Snowflake:
But there are some significant challenges with the MPP approach to analytics workloads. Parallelizing SQL execution plans in MPP systems First, customers running MPP cloud warehouses for big data analytics eventually run into performance issues that have plagued their traditional on-premise counterparts. This includes scale limitations when their data surpasses a specific size and restrictions on the number of concurrent users hitting the data. These limitations arise from performance issues typically associated with distributed MPP architecture: data skewness, network latency, and complexity. While the MPP approach to data warehousing can work to a particular scale in data volumes and concurrent users, as cluster resource consumption grows, performance suffers, and costs can rise to unsupportable levels.
There have been many advantages of the SSAS platform that have made it a popular OLAP platform. But many companies are looking for ways to bring the technology forward to a more modern, big data infrastructure. Limited scalability and limited data capacity make it difficult for SSAS to meet the requirements of the big data era. Kyligence's intelligent OLAP solutions can help customers bring all of the value that they created with SSAS forward into the future:
Kyligence not only offers many of the same excellent capabilities of SSAS, but it also overcomes the limitations of SSAS by providing customers with the following value:
Download our Upgrading SSAS to Big Data White Paper
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.
Unlock potentials of analytics query accelerators for swift data processing and insights from cloud data lakes. Explore advanced features of Kyligence Zen.
Unlock power of data storytelling in business. Learn how to convey insights using narrative and visual representations, examples, and benefits.
Explore these exceptional cloud analytics tools. Assess their pros, cons, and pricing to pinpoint the optimal one for your business.
Learn what natural language query is and how it transforms your data analytics. Explore examples of natural language queries in Kyligence Zen.
Discover how AI shapes banking, healthcare, and data analytics sectors. Get insights into the future of industry disruption to guide your decisions.
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.