ExecCube Method

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

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function ExecCube( _
   ByVal connection As System.String, _
   ByVal cubeName As System.String, _
   ByVal view As System.Collections.Generic.Dictionary(Of String,Object), _
   ByVal cancelToken As System.Threading.CancellationToken, _
   ByVal progress As ProgressDelegate _
) As System.Threading.Tasks.Task(Of Dictionary(Of Object(),Object()))

public static System.Threading.Tasks.Task<Dictionary<object[],object[]>> ExecCube( 
   System.string connection,
   System.string cubeName,
   System.Collections.Generic.Dictionary<string,object> view,
   System.Threading.CancellationToken cancelToken,
   ProgressDelegate progress
)

Parameters

connection: SSAS connection string.
cubeName: Cube name.
view: View definition used for retrieving data from the cube.
cancelToken: Enables task cancellation.
progress: Callback function to report progress updates.

Return Value

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.FlexPivot.C1FlexPivotEngine.Exec(string, string, System.Collections.Generic.Dictionary<string,object>, System.Threading.CancellationToken)%

Reference

C1FlexPivotEngine Class
C1FlexPivotEngine Members