MeasureDataFromSection data object

Returns extended calculated index data for the measure and location pairs defined in the specified section. The result only includes data for the comparison series and periods defined in the view on which the section is based. Table 9‑17 lists and describes the parameters for MeasureDataFromSection.

Table 9‑17 Parameters for MeasureDataFromSection
Parameter	Description
sectionName	Section name. Mandatory.
periodOnly	Whether to calculate data with consolidation by periods. By default, the value is false.
latestAvailable	Whether to calculate the result using the latest available data. By default, the value is true.
includeWorstColors	Whether to display the worst submeasure and sublocation colors and range identifiers with measure data.

Table 9‑18 Columns in MeasureDataFromSection
Column name	Description
MeasureName	Measure name
LocationName	Location series 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