Universal Report static layout named ranges

Universal Report static layouts contains named ranges that are used to drive the report.

The following chart contains the named ranges in a Universal Report static layout:

Table 1. Universal Report static layout named range ID's
Named range IDs	Description
p	The p named range maps to the properties of the Universal Report static layout. The properties of a Universal Report static layout is an ordered array of values which can define how the Universal Report looks and behaves. Note: The optional values are not created by default, and are not generally applicable in a Universal Report static layout.
q	The q named range maps to the MDX query of the Universal Report static layout. You can modify the MDX of a Universal Report static layout to determine which members appear in the report.
d	The d named range maps to the data of the Universal Report static layout.
cm	The cm named range tracks the column header cells (2004, Q1-2004,…, etc.)
rm	The rm named range tracks the row header cells (Revenue, COS, …, etc.)
rg	The rg named range maps to the column gutters of the Universal Report static layout. A column gutter is the hidden column, which defines the far margin of the data. It is the first empty column on the right. For more information on row gutters, see Row and column gutters.
cg	The cg named range maps to the row gutters of the Universal Report. A row gutter is the hidden row, which defines the far margin of the data. It is the first empty row on the bottom. For more information on column gutters, see Row and column gutters.
hc	The hc named range tracks the hidden columns of the Universal Report’s hidden format areas. It integrates with the show/hide buttons in the ribbon.
hr	The hr named range tracks the hidden rows of the Universal Report’s hidden row areas. It integrates with the show/hide buttons in the ribbon.
slicer	The slicer named range maps to the hierarchies in the slicer cells of the Universal Report.
tracked	The tracked name range applies to the TM1SET formula cells in Universal Report. Gesture support for TM1SET cells, such as double-clicking the cell to open the set editor, is available only if the cell is tracked.

Note: If your report does not have slicer, rows, or columns, then the corresponding named ranges are not generated, since the axis does not exist. For instance, if you have a saved view with no row axis, then the rm and hr ranges are not included in the static layout report.

The following chart contains the hidden named ranges that are generated and used by the MakeQuery3 formula:

Table 2. Universal Report static layout hidden named range ID's
Hidden named range IDs	Description
ch	The ch tracks the column hierarchies.
rh	The rh tracks the row hierarchies.
sh	The sh tacks the slicer hierarchies. The value of the sh hidden range is defined by the MakeMunArray formula. For example, `=MakeMunArray(Sheet1!$D$8:$D$12,Sheet1!$E$8:$E$12)` builds an array list of the slicer values.

For more information on the MakeQuery3 formula, see MakeQuery3.