HierarchicalMeasureDataFromSection data object

Returns hierarchical calculated index data for a set of measure and location pairs in the specified section. The result only includes data for the comparison series defined for the view on which the section is based. Table 9‑1 lists and describes the parameters for HierarchicalMeasureDataFromSection.

Table 9‑1 Parameters for HierarchicalMeasureDataFromSection
Parameter	Description
sectionName	Section name. Mandatory.
periodName	Period from the view’s display range used to calculate data. If undefined, the value is the selected period in the view.
measureLevels	Number of submeasure levels to include for each measure and location pair (0-all). Mandatory.
locationLevels	Number of sublocation levels to include for each measure and location pair (0-all). Mandatory.
latestAvailable	Whether to display the latest available data. Mandatory.
includeWorstColors	Whether to display the worst submeasure and sublocation colors and range identifiers with measure data.

Table 9‑2 Columns in HierarchicalMeasureDataFromSection
Column name	Description
MeasureLevel	Measure level (integer number)
ParentMeasureName	Parent measure name
MeasureName	Measure name
LocationLevel	Location level (integer number)
ParentLocationName	Parent location name
LocationName	Location name
PeriodName	Period name
BaseName	Base series name
BaseData	Base series data (floating point number)
CompName	Comparison series name
CompData	Comparison series data (floating point number)
CompVar	Comparison data variance (floating point number)
CompVarPct	Comparison data variance percent (floating point number)
CompIdx	Comparison series index (floating point number)
CompIdxRangeId	Comparison series range identifier
CompIdxColor	Comparison index color (RGB hex number)
CompTxtColor	Comparison text color (RGB hex number)
WorstMsrIdxRangeId	Worst measure range identifier
WorstMsrIdxColor	Worst measure index color
WorstLocIdxRangeId	Worst location range identifier
WorstLocIdxColor	Worst location index color