Rules for Dimension Design
Rules for Dimension Design[@more@]Do not include any characteristic into your cube if it is not used by any query. For possible future usage, it can be included into DSO.Between a navigational attribute VS. a characteristic, the first option is better for load performance and the second option is better for query performanceMinimize the size of dimension tableMinimize the number of dimensions, but it is more important to minimize the size of dimension tablesFor high cardinality characteristi