Post reply

Ascertaining size of a cube?

  • January 2, 2007 at 9:39 am

    #116746

    Hi,

    I've recently started to use Analysis Services Version: 8.00.194. with SQLServer 2000.

    I've noticed that when processing a cube -MOLAP- the storage size for the aggregations is roughly a factor of 10 larger than the size given in the meta data tab for the cube. Does anyone know which is the correct figure or if there is a way of ascertaining the size of a cube in some other way?

    Thanks

    K.

  • January 3, 2007 at 7:28 am

    #680957

    I think we used to use Windows Explorer to get the properties of the relevant cube folder in the data directory.  AS it's MOLAP all of the data and aggregations (and dimensions) should be stored in that one directory.

     

    Steve.

  • January 3, 2007 at 8:15 am

    #680967

    Hi,

    Doh! thanks that's exactly what I needed. The meta data report is correct - or more accurately it's the same value as appears in the folder where the cube is stored -  which makes me think I’m not understanding what AM is telling me when it's calculating the aggregations, oh well I shall look forward to finding out

    Cheers

    K

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply