Topic
  • 2 replies
  • Latest Post - ‏2009-08-26T07:16:10Z by SystemAdmin
SystemAdmin
SystemAdmin
280 Posts

Pinned topic How to improve Cube Performance

‏2009-01-07T21:13:46Z |
Aravindan T said:

Hi Friends,

I am facing cube performance issues while retrieving data from the cube my cube size is 1GB only(But cube size limit is 2GB).

How to improve cube performance? If any one known please share with me that would very helpful for me. I just tell you my cube detail here

My model having 16 dimension filters and 14 measures and also taking more time to build.

Thanks & Regards

Aravind.T

Updated on 2009-08-26T07:16:10Z at 2009-08-26T07:16:10Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    280 Posts

    Re: How to improve Cube Performance

    ‏2009-01-07T21:13:46Z  
    Sudhakar Malasani said:

    Hi,

    Do you have Transactional and structural Data Sources seperate?

    How big are these dimension tables ? (Max and Min number of records in Dim)

    How big is fact table?

    SM.

  • SystemAdmin
    SystemAdmin
    280 Posts

    Re: How to improve Cube Performance

    ‏2009-08-26T07:16:10Z  
    Sudhakar Malasani said:

    Hi,

    Do you have Transactional and structural Data Sources seperate?

    How big are these dimension tables ? (Max and Min number of records in Dim)

    How big is fact table?

    SM.

    There are 2 ways.
    1. Select the autopartesion tab in propety tab here we should selected the one Arrow towards right side.
    and put max limit is to 50000.
    Then cube performance is improved but the cube might to be take some for open.
    But cube was created veryfast in Powerplay model.