Apply to MSS
Join Our Talent Community
Gartner, the information technology research and advisory firm, confirms that analytics now dominates the ranking of technologies CIOs have selected as their top priorities for the coming year. Mobile technology and cloud computing follow with a rank of two and three, respectively. Our clients are also reporting increased interest in business intelligence as a driver for enterprise profitability.
IBM continues to show leadership in analytics through Cognos 10. Dynamic Cubes is a technology within the Cognos family that provides exceptionally fast performance.
Dynamic Cubes is a good solution for near real-time data warehousing. They are best used on large volume star schemas. PowerCubes or TM1 are better technologies for lower volume databases. Use cases, your system architecture, and the total number of members in the largest dimensions will determine whether it’s best to deploy Dynamic Cubes.
Dynamic Cubes is an extension of IBM’s Cognos Dynamic Query. It allows systems to achieve high performance over terabytes of data using the Aggregate Advisor. The Advisor helps performance by evaluating a cube and suggesting either in-database aggregate tables or in-memory aggregates.
Cognos BI version 10.2 Dynamic Cubes supports IBM DB2, IBM Netezza, Microsoft SQL Server, Oracle, and Teradata databases.
MSS can provide further understanding on the role of Dynamic Cubes in your enterprise. We can help develop a roadmap that will align Cognos 10 analytics to your strategic goals and integrate it into your IT systems and processes.
This blog was contributed by Philip Wik, MSS Consultant.
For questions about Business Intelligence, Dashboards or Performance Management contact us at firstname.lastname@example.org
Cite this blog post:
MLA: Wik, Philip. “Improving Business Intelligence Performance with Dynamic Cubes.” MSS. MSS. Blog. 08 April 2015.
APA: P Wik. (2012, Dec 20). Improving Business Intelligence Performance with Dynamic Cubes.