Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  maximum size of cube

    Posted 04/22/22 02:21 PM
    what is maximum size of dynamic cube in cognos

    ------------------------------
    Priyanka Joshi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: maximum size of cube

    Posted 04/25/22 01:59 AM
    HI, 
    Only the cubes metadata is loaded in memory as default, so all the transactions is in the database, and can be in various summery tables, so the Dynamic Cubes rely on at good database set up, for best performance, and have no maximum size.

    Br
    René

    ------------------------------
    René Kent Nielsen
    Brand manager
    CogniTech A/S
    Herning
    ------------------------------



  • 3.  RE: maximum size of cube

    Posted 04/25/22 02:25 AM
    Hi Priyanka,

    If you have a dynamic cube with 30,000,000 members, it is called "very complex cube" (based on the IBM Cognos Analytics 11.2 Dynamic Cubes hardware sizing document).

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------