Parameter | Description |
viewName | View name. Mandatory. |
filterName | Filter 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. |
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 |