This object is returned by the getAllMeasures() and getMeasures() methods. It can describe:
{
name: string,
uniqueName: string,
aggregation: string,
availableAggregations: string[],
availableAggregationsCaptions: string[],
caption: string,
format: string,
formula: string,
grandTotalCaption: string,
groupName: string,
type: string
}| Property/Type | Description |
|---|---|
| name String | The measure's name. |
| uniqueName String | The measure's unique name. |
| aggregation String | The name of the aggregation applied to the measure. If the measure is calculated, aggregation is set to "none". See the list of available aggregations. |
| availableAggregations String[] | Represents the list of aggregation functions that can be applied to the current measure. If the measure is calculated, availableAggregations is set to []. |
| availableAggregationsCaptions String[] | Represents the list of available aggregations’ captions. If the measure is calculated, availableAggregationsCaptions is set to []. |
| caption String | The measure's caption. |
| format String | The name of the number formatting that will be applied to the measure. |
| formula String | optional It represents the formula. For calculated measures. |
| grandTotalCaption String | The measure's grand total caption. |
| groupName String | optional The measure's group defined in SSAS. Only for the "microsoft analysis services" data source type. |
| type String | The measure's type. It is returned for "json", "csv", and "elasticsearch" data source types:
|
The example below shows an array of MeasureObjectReturned objects returned by the getMeasures() method:
flexmonster.getMeasures();
/* method returns an array of MeasureObjectReturned objects
[
{
aggregation: "sum",
availableAggregations: ["sum", "average", "percent"],
availableAggregationsCaptions: ["Sum", "Count", "Percent"],
caption: "Sum of Sales",
format: "currency",
grandTotalCaption: "Total Sum of Sales",
name: "Sales",
type: "number",
uniqueName: "Sales"
},
{
aggregation: "sum",
availableAggregations: ["sum", "count", "distinctcount", "average", "product", "min", "max", "percent", "percentofcolumn", "percentofrow", "index"],
availableAggregationsCaptions: ["Sum", "Count", "Distinct Count", "Average", "Product", "Min", "Max", "% of Grand Total", "% of Column", "% of Row", "Index"],
caption: "Sum of Orders",
format: "",
grandTotalCaption: "Total Sum of Orders",
name: "Orders",
type: "number",
uniqueName: "Orders"
}
]
*/