Universal Report static layout properties

A Universal Report static layout has only a few properties in the p named range to allow for a simplified user experience.

The properties must be in the order shown in the following chart to work properly:

Table 1. Universal Report static layout properties in thep named range
Property named range IDs	Description
Datasource	The Datasource property is the URL of the first data source that you log into and is calculated by the TM1PRIMARYDATASOURCE() function. You can change the URL manually if the view you are using is from a different datasource.
Server	The Server property is the name of the first database that you are authenticated through and is calculated by the TM1PRIMARYDBNAME() function. You can change the database manually if the view you are using is from a different database.
Preserve User Formulas	The Preserve User Formulas property determines if formulas are saved when a refresh occurs. The property can be set to `TRUE` or `FALSE`. Note: In TM1® Web, the value for Preserve User Formulas defaults to `FALSE` if the property is not included in the p range of the report. In Planning Analytics for Microsoft Excel version 2.0.100 or newer, the value of the Preserve User Formulas property in existing and converted reports is determined by the current value of the application property Preserve User Formulas. For more information, see Preserve User Formulas.