PivotGridExtension.CreateOLAPDrillDownDataSource(PivotGridSettings, String, Int32, Int32, Int32, List<String>) Method
In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns, and limit the number of records to be returned.
Namespace: DevExpress.Web.Mvc
Assembly: DevExpress.Web.Mvc5.v24.2.dll
NuGet Package: DevExpress.Web.Mvc5
#Declaration
public static PivotDrillDownDataSource CreateOLAPDrillDownDataSource(
PivotGridSettings pivotGridSettings,
string connectionString,
int columnIndex,
int rowIndex,
int maxRowCount,
List<string> customColumns
)
#Parameters
Name | Type | Description |
---|---|---|
pivot |
Pivot |
A Pivot |
connection |
String | A String that specifies the connection string to an OLAP cube. |
column |
Int32 | A zero-based integer which identifies the visible index of the column. |
row |
Int32 | A zero-based integer which identifies the visible index of the row. |
max |
Int32 | An integer value that specifies the maximum number of data rows to be returned. -1 to retrieve all rows. |
custom |
List<String> | A list of columns in a datasource, to be returned. |
#Returns
Type | Description |
---|---|
Pivot |
A Pivot |
#Remarks
To obtain the name of a column in a datasource to which a pivot field corresponds, use the field’s OLAPDrillDownColumnName property.
Note
For MS SQL Server Analysis Services 2000, the custom
Note
A note for MS SQL Server Analysis Services 2005 and 2008. If the custom
Note
If a filter is applied to a field, then that filter is taken into account if the corresponding drill-down column was returned from the server by the Create
Note
The Create
Note
If multiple filter items are selected in a Filter Field, the drill-down data source cannot be created due to an MS SQL Server Analysis Services limitation. In this instance, the Create