Execution
Define what the backend computes and how the result is shaped: dimensions, sorting, totals, derived measures, and data sampling.
Describe a computation for the Analytical Backend and read its result. Start with the execution model, then set dimensions and sorting, add totals or derived measures, and trade accuracy for speed with data sampling.
Execution model
Create, inspect, and modify execution attributes, filters, measures, and sort items with SDK model factories, builders, and accessors.
Run a custom execution
Build custom executions with attributes, measures, filters, sorting, and dimensions via the Analytical Backend fluent API.
Result structure
Define execution dimensions, totals, and sorting, then read computed data through execution results, data views, and DataViewFacade.
Add totals to a table
Add grand totals and subtotals to Pivot Tables with newTotal, covering sum, avg, min, max, median, and rollup aggregations.
Compare to a previous period
Create same-period-last-year and previous-period derived measures with newPopMeasure and newPreviousPeriodMeasure.
Sample data
Speed up visualizations by processing a percentage of dataset rows using the execConfig dataSamplingPercentage option.