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

Excel Reporting Comparison to Views and Reports

  • Dark
    Light
  • 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?