Post reply

not enough free space on disk when I process dimension

  • August 27, 2009 at 3:21 am

    #209927

    Dimension Product in our dw has 7 levels and 150K members, it's present in 10 cubes.

    Processing this dimension temporary takes 4GB space on hard disk and sometimes if the free space less then 4 GB at the moment of processing dimension/cubes I have error.

  • August 27, 2009 at 7:20 am

    #1045511

    I've seen something similar when a client didn't have the attribute relationships set correctly (in that case, not set at all) - the processing and query times took a hit because the system is being told that everything is directly related to the primary key of the dim (for querying this means no aggregation candidates). The disk space was used heavily as all members needed to be pushed into a single file when processing whereas with attribute hierarchies set up, it appeared that multiple files were used with less volume per file.

    HTH,

    Steve.

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

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