ComponentOne ASP.NET MVC Controls
PivotEngine Class Members
Properties  Methods 

C1.Web.Mvc.Olap Namespace : PivotEngine Class

The following tables list the members exposed by PivotEngine.

Public Constructors
 NameDescription
Public ConstructorCreates one PivotEngine instance.  
Top
Public Properties
 NameDescription
Public PropertyGets or sets a value that determines whether users should be allowed to edit the properties of the Fields.  
Public PropertyGets or sets a value that determines whether view updates should be generated asynchronously.  
Public PropertyGets the list of PivotField objects that define the fields shown as columns in the output table.  
Public PropertyGets the child components. (Inherited from C1.Web.Mvc.Component)
Public PropertyGets the options for OLAP cube provided by SSAS server.  
Public PropertyGets or sets the default filter type (by value or by condition). When binding the service, only FilterType.Condition and FilterType.None are supported. When FilterType.Both is set, it works as FilterType.Condition. When FilterType.Value is set, it works as FilterType.None.  
Public PropertyGets or sets a value that determines whether the filter should include only values selected by the @see:wijmo.grid.filter.ValueFilter.filterText property.  
Public PropertyGets the list of the PivotField objects which can be used in the view.  
Public PropertyGets the list of PivotField objects that define the fields used as filters.  
Public PropertyGets or sets the component id. (Inherited from C1.Web.Mvc.Component)
Public PropertyGets ItemsSource settings.  
Public PropertyGets or sets the ItemsSourceId specify which CollectionViewService will be used for this control.  
Public PropertyOccurs when there is an error getting data from the server.  
Public PropertyOccurs after the items source changes.  
Public PropertyOccurs after the engine has finished updating the output pivot view list.  
Public PropertyOccurs when the engine starts updating the output pivot view list.  
Public PropertyOccurs after the view definition changes.  
Public PropertyGets the list of PivotField objects that define the fields shown as rows in the output table.  
Public PropertyGets or sets the maximum number of records when getting the detail data from the server. The default value for this property is 1000, which provides a reasonable amount of detail in many scenarios. If you want to allow more detail records to be retrieved, increase the value of this property.  
Public PropertyGets or sets the amount of time, in milliseconds, which the engine should wait before polling the server for progress status while retrieving results. The default value for this property is 500, which causes the engine to poll the server for a status update every half second.  
Public PropertyGets or sets the maximum amount of time, in milliseconds, which the engine should wait for the results to come back from the server. The default value for this property is 60000, equivalent to sixty seconds. If you expect server operations to take longer than that to complete, set the property to a higher value.  
Public PropertyGets or sets the service url.  
Public PropertyGets or sets a value that determines whether the output data should include columns containing subtotals or grand totals.  
Public PropertyGets or sets a value that determines whether the output data should include rows containing subtotals or grand totals.  
Public PropertyGets or sets a value that determines whether the Olap output table should use zeros to indicate the missing values.  
Public PropertyGets or sets a value that determines whether the engine should sort groups when sorting the value fields (measures) or whether it should keep the group order and the data only within each group.  
Public PropertyGets or sets a value that indicates whether the summary data received from the server is already sorted.  
Public PropertyGets or sets a value that determines whether row and column totals should be displayed before or after regular data rows and columns.  
Public PropertyGets the list of PivotField objects that define the fields summarized in the output table.  
Public PropertyGets or sets the current pivot view definition as a JSON string.  
Top
Public Methods
 NameDescription
Public MethodReturns an HTML-encoded string. (Inherited from C1.Web.Mvc.Component)
Top
Extension Methods
 NameDescription
Public Extension MethodRender the html string in template mode.
Top
See Also

Reference

PivotEngine Class
C1.Web.Mvc.Olap Namespace