MeasureDataFromView data object

Returns extended calculated index data for a set of measure and location pairs in the specified view. The result only includes data for the comparison series and periods defined in the view. Table 9‑19 lists and describes the parameters for MeasureDataFromView.

Table 9‑19 Parameters for MeasureDataFromView
Parameter	Description
viewName	View name. Mandatory.
filterName	The filter used to pull measures and locations from the view. If undefined, only the view's top measure and location are used to calculate index data.
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‑20 Columns in MeasureDataFromView
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