To optimize attribute query performance, consider the following design tips:

• Ensure that attribute dimensions are the only sparse Dynamic Calc dimensions in the outline.

• Position sparse dimensions after dense dimensions in the outline. Place the most-queried dimensions at the beginning of the sparse dimensions and attribute dimensions at the end of the outline. In most situations, base dimensions are queried most.

See also Attribute Calculation and Retrieval Performance.