Flexmonster Software License Agreement (“Agreement”) has been significantly revised and is effective as of September 30, 2024.
The following modifications were made:
The modified version of Flexmonster Software License Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after September 30, 2024, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Flexmonster Software License Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license under License Model or Maintenance after the effective date of any modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
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 ResultMeasureObjects returned by the getMeasures() method:
flexmonster.getMeasures();
/* method returns an array of ResultMeasureObjects
[
{
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"
}
]
*/