Cube Design Best Practice :: Tip o' The Day

Do not put too many parent-child dimensions in a cube.

This tip is magnified when the dimension contains custom rollups or unary operators.  Yes, some of you might say, “but they are so powerful!”  Well with power comes responsibility!  In this case the responsibility is to safe guard against poorly performing queries.  So keep in mind that these parent child dimensions should only be used when absolutely necessary.