TDataConnectionOlapProperties Class
This element contains all the properties needed for an OLAP data connection. OLAP connections contain both the TDataConnectionDbProperties and TDataConnectionOlapProperties child elements.
Syntax
Namespace: FlexCel.Core
public class TDataConnectionOlapProperties
Methods
Name | Description |
---|---|
Equals | Returns true if both objects are the same. |
GetHashCode | Returns the hashcode of the object. |
Properties
Name | Description |
---|---|
Local | Flag indicating whether we should get data from the local cube on refresh versus the original data source. true if a local cube has been created for OLAP data, and it should be used instead of the server. |
LocalConnection | Specifies a connection string to use when a local cube is available. This is used when local is set to true. |
LocalRefresh | Flag indicating whether we should refresh the local cube from the original data source. When true, the original OLAP data source is queried each time the user explicitly refreshes the data in the application, and a new local cube is constructed from this query. |
SendLocale | When true, the spreadsheetML app should send the user interface locale ID to the OLAP provider to retrieve localized member names and properties, etc. When false, no locale ID is expected. |
RowDrillCount | Maximum number of drill-through rows to return when the user drills through an aggregate value in a PivotTable. |
ServerFill | When true a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source if this information is available.When false, OLAP server background fill colors are ignored, and standard formatting rules within the worksheet are followed. |
ServerNumberFormat | When true, a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the number format from the OLAP source.When false, OLAP server number formats are ignored, and standard formatting rules within the worksheet are followed. |
ServerFont | When true, a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the font from the OLAP source (e.g., Arial or Tahoma). When false, OLAP server fonts are ignored, and standard formatting rules within the worksheet are followed. |
ServerFontColor | When true a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the font color from the OLAP source.When false, OLAP server font colors are ignored, and standard formatting rules within the worksheet are followed. |