By Use Cases
By BI Tool
Subscribe to our newsletter>
Get the latest products updates, community events and other news.
For some time, IBM’s Cognos analytics solution has been a popular choice for enterprise analysts and data teams looking to uncover crucial business insights from their company’s growing datasets.
While Cognos has performed its role well, many data engineers and analysts are waking up to the fact that their Cognos solution isn’t keeping up with the datasets and queries their business is working with in today’s big data environment.
So, what happened?
If you’ve never heard of OLAP (OnLine Analytical Processing), you probably don’t remember the siloed and limited data analytics environment that preceded it. At the time, it was a big deal. OLAP broke down these limitations and helped data teams consolidate their datasets and quickly perform more scalable and complex analytics. Since then, business data has become ubiquitous, and OLAP analytics continues to help business analysts generate more sophisticated insights.
For IBM Cognos users, PowerPlay made this OLAP approach possible for organization’s everywhere with its introduction of PowerCubes. Combined with Cognos’ powerful visualization tools, IBM’s OLAP PowerCubes provided a powerful business intelligence environment for all but the most data-intensive analytics work.
Unfortunately, that data-intensive analytics work is now commonplace in organizations of all sizes across every industry. Insights from Big Data are now seen as a major strategic advantage, and businesses are sparing no expense hiring an army of data scientists, analysts, and engineers to collect all the data they can and mine insights faster than ever before.
This has put organizations that run on Cognos in a bind. Cognos is built into their analytics workflows and their analysts prefer its visualization and reporting features, but it’s just too much work to manage and too slow when they run it on their massive datasets. What’s going on here?
As it turns out, a few things. First, PowerCube size and dimension limitations have begun to matter. This wasn’t the case years ago. Now, with queries becoming more detailed and datasets scaling into the petabytes, PowerCube size constraints are a liability.
The response to this has been for organizations to build hundreds (or thousands) of PowerCubes, but this isn’t without its own drawbacks. Now, data engineering teams are tied up building new Cognos cubes and analysts are forced to wait for cubes to render.
This render time means analytics insights are always a day or two behind real-time, and Cognos’ limited self-service analytics beyond 10 dimensions means analysts either have to settle for surface-level insights or spend more time waiting for answers to their detailed queries.
Speaking of queries, query speeds can barely keep up in the terabyte range. With datasets often reaching into the petabytes these days, query speed limitations are all too common. And if you’re looking at historical data (e.g. Year on Year), latency becomes even worse. In short, organizations that adopted Cognos PowerCubes to stay ahead of the competition in the early days of Big Data are now finding themselves falling behind right as Big Data is taking off.
The good news for Cognos users is that there’s an easy way to protect much of their Cognos analytics investment while solving the underlying problems that plague it today. Kyligence’s augmented OLAP platform (based on Apache Kylin’s extreme OLAP technology) enables businesses running on Cognos to replace and consolidate their PowerCubes into a single massively multidimensional cube. This provides several major benefits:
All of this comes together to provide Cognos analytics users a faster path to new insights and less management overhead for their data engineering and IT teams.
For example, China’s UnionPay saw their TCO drop by nearly 90% when they transitioned their Cognos-based data warehouse over to one built on Kyligence. This was thanks to the considerable decrease in hardware and software costs, as well as the reduced manpower from eliminating the maintenance of thousands of OLAP cubes and data preparation scripts.
If you’re done playing catch up with your analytics insights and want to learn more about how Kyligence can bring your Cognos deployment into the 21st century, download our Cognos Solution Overview.
Curious about OLAP? We recommend checking out the recent presentation from Kyligence CEO, Luke Han.
And if you want even more information, this video offers a great overview of the Kyligence and Apache Kylin approach to augmented OLAP analytics:
Also, be sure to follow us on LinkedIn and Twitter for the latest Kyligence product updates and Augmented Analytics announcements.
Learn about the fundamentals of a data product and how we help build better data products with real customer success stories.
Kyligence introduces the deployment of OLAP on top of Azure, including data sources, features, benefits, and prerequisites. Learn more about Kyligence for Azure.
What's OLAP on big data? What're its benefits? Here's everything you need to know about OLAP.
Learn how one big fast-food brand leveraged Kyligence capabilities and implemented precision marketing to maximize profit opportunities.
Come to see the Next Generation of SQL Query Engine
Learn how to achieve alternatives to SSAS.
99 Almaden Boulevard Suite #663
San Jose, CA 95113
+1 (669) 256-3378
Ⓒ 2022 Kyligence, Inc. All rights reserved.
沪 ICP 备 16026036 号 -1
沪公网安备 31011502006713 号
Already have an account? Click here to login