MENU
    Limitations
    • 1 Minute to read
    • Dark
    • PDF

    Limitations

    • Dark
    • PDF

    Article summary

    Reporting Cube Configuration Limitations

    Description
    Limitation
    Suggestions

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

    8

     

    Number of active scenarios in the reporting cube

    15

    Delete unused scenario partitions

    Number of dimensions with rollup operators applied

    1 (Account only)

    If roll up operators are applied for non-account dimensions, reports performance will be impacted

    Number of Alternative Hierarchies across all dimensions

    1 (Account only)

     

    Number of dimensions where Dimension Security is applied

    10

     

    Dynamic Report Limitations

    Description
    Limitation
    Suggestions

    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-based 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’.


    Was this article helpful?