Reports and Input Schedules 
Reports
With Planning and Consolidation reporting, you can retrieve requested data from the database into an Excel interface. You can analyze your multidimensional data using the current view, which is available on the action pane. The system provides a variety of report templates to which you can add common formulas to design your own reports.
Input Schedules
Input schedules allow you to send data directly from your spreadsheet to the databases. Input schedules contain all of the same formatting and functionality as reports. The difference is that reports are used for analysis purposes, and input schedules are used for writing data to the database. Data can be written to base-level members to which you have write access.
In addition to the common features of reports and input schedules, here are some unique features of input schedules:
Modeling Options
You can use the provided modeling options (spread, trend, and weight). See Data Modeling.
Submitting Data
If you have the proper authority, you can send data to the database. There are several submission options available. See Data Submission.
Upon sending data to the database, if the work status or data submission validation is enabled by your administrator, the system checks to make sure there are no work status locks or validity issues, respectively, on the member intersections. A validity check includes making sure that the members are valid, the periodicity is correct, and the member type is correct (for example, the member is not a calculated member). A concurrency check is always performed by the system for data submissions. See Data Submission.
Changing the Work Status Code
After submitting data, you can change the work status code to enforce data locks on authorized data points. See Work Status.
Distribution and Collection
You can use the distribution feature to distribute a set of input schedules to users, then use the collection feature to get the input schedules back. See Distribute and Collect Offline Data.
Using Special Formatting
If you want to apply special formatting to read-only cells, cells that are ready for input, or changed cells, you can use the FormatRange option in EvDRE. For example, for calculated cells, you can set the USE formatting option to LOCK (then lock those cells through native Excel), to prevent the user from changing calculated cells. See Format Ranges.