MENU
    Excel Reporting Comparison to Views and Reports
    • 1 Minute to read
    • Dark
    • PDF

    Excel Reporting Comparison to Views and Reports

    • Dark
    • PDF

    Article summary

    The table below highlights the similarities and differences between views, reports, and Excel Reports.

    View

    Report

    Excel Report

    Interactive query and analysis

    Formatted report with restrictions on page, row, and column axes placement

    Formatted report with no restrictions

    Excel and web interface

    Excel and web interface

    Excel interface

    No formatting

    Support for most commonly used formats

    Support for a wide variety of Excel formats

    Reference data from one model

    Reference data from multiple models

    Reference data from multiple models

     

    Support for substitution variables

    Support for substitution variables

    Save data to a single model

    Save data to multiple models

    No saving of data

    Runs calculation process

    Runs calculation process

    No running of calculations

    Drill Through data is supported

    Drill Through data is supported

    Drill Through data is not supported

    Model and dimension security are supported

    Model and dimension security are supported

    Model and dimension security are supported

     

     

    Publishing to the cloud is supported


    Was this article helpful?