Reporting Cube and Dynamic Report Limits and Best Practices

Number of Attributes & Attribute Hierarchies mapped to the reporting cube across all dimensions

25

Number of dimensions where Dimension Security is applied

10

Number of active scenarios in the reporting cube

15

Delete unused scenario partitions

Number of dimensions with rollup operators applied

1 (Account only)

IIf rollup operators are applied for non-account dimensions, report performance is impacted

Number of Alternative Hierarchies across all dimensions

1 (Account only)

-

Number of lines in a static report row set used in Dynamic Reports

600

Use single member mappings in Reference Account lines

Number of lines in a static report column set used in Dynamic Reports

24

Use substitution variables and Excel expressions for improved performance

Number of children under a single parent at any level for Drill Down

500

Number of lines in Drill Through

30000

Size of logo used in report header

64 (height) x 150 (width) pixels

Physical size of logo used in report header

50KB

Up to 2MB is allowed, but 50KB is recommended for best report output.

Formulas

SUMIF, SUMPRODUCT & COUNTIF are not supported in Dynamic Reports

Print Setup

PDF and Microsoft Excel output for Header and Footer

If you apply fit to 1 x 1 or 1 x 2 option in the Dynamic Reports Print Setup and the report has more than 9 columns, the header and footer section are likely to be improperly aligned in the PDF output. This also applies to Excel output when the Header & Footer configuration is set to ‘Header & Footer Section’.