Apply to MSS

First Name

Last Name

Phone

Email

State

Education

Check all that apply

Experience with a major consulting firm

Check all that apply

Certifications

Check all that apply

Experience

Check all that apply

Functional Experience

Check all that apply

Attach Cover Letter

Attach Resume

Please leave this field empty.

Join Our Talent Community

First Name

Last Name

Phone

Email

State

Education

Check all that apply

Experience with a major consulting firm

Check all that apply

Certifications

Check all that apply

Experience

Check all that apply

Functional Experience

Check all that apply

Attach Resume

facebook gplus linkedin sharethis
  • Blog

    blog banner
  • Improving Business Intelligence Performance with Dynamic Cubes



    Categories
    Archives
    December 20th, 2012

     

    Cognos Dynamic Cube

    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  info@msstech.com

    Return to blog

    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.