C1.PivotEngine.C1PivotEngine.ExecCube

ExecCube Method

ExecCube(string, string, Dictionary<string, object>, CancellationToken, ProgressDelegate)

Server request for data from a SQL Server Analysis Service (SSAS) cube. Returns aggregated results to the caller client.

Declaration

public static Task<Dictionary<object[], object[]>> ExecCube(string connection, string cubeName, Dictionary<string, object> view, CancellationToken cancelToken, ProgressDelegate progress)

Parameters

Type	Name	Description
string	connection	SSAS connection string.
string	cubeName	Cube name.
Dictionary<string, object>	view	View definition used for retrieving data from the cube.
CancellationToken	cancelToken	Enables task cancellation.
ProgressDelegate	progress	Callback function to report progress updates.

Returns

Type	Description
Task<Dictionary<object[], object[]>>	Aggregation results.

Remarks

This method supports multi-user thread-safe retrieval of aggregated data form a cube. Resulting data is intended for passing to a client for visualization on the web or elsewhere.

It can get data from multiple cubes, cube name (and connection) specified in each call. It maintains a pool of Workspace objects internally to enable that.

Aggregation result is a dictionary mapping keys to values. See a description of keys and values in C1.PivotEngine.C1PivotEngine.Exec(string, string, System.Collections.Generic.Dictionary<string,object>, System.Threading.CancellationToken)