Post reply

SSAS___ dimensions

  • November 30, 2011 at 8:40 am

    #390995

    HI friends, here am posting some of my doubts,

    what would be the range of dimensions for a cube?

    what is the size of dimension and cube? (it means, in gb or tb)

    what is processing time for the dimension, cube n partition?

    what is the real time cube, differences between cube n real time cube?

    Which one is better from performance point of view...NON Empty keyword or NONEMPTY function

    thank you in advance

    priya

  • November 30, 2011 at 1:17 pm

    #1414903

    I think the questions you ask would mostly get an "it depends" from me, as it simply depends on your design, performance targets, optimizations,etc., and environment. There simply is not a one-size-fits-all answer.

    I work for a small company and each cube has a target of under 1 hr load time for however many dimensions and fact rows that may encompass.

    We do not limit ourselves in storage nor columns, we simply build what we need.

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

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