The following constants are defined in the Essbase Visual Basic global text file ESB32.BAS, and in the C language header file ESBAPI.H
Maximum String LengthsThe following constants define the maximum lengths of various string types in the Essbase VB API and must be used for variable declarations in a VB application:
Constant | Definition |
ESB_USERNAMELEN | Maximum length of a user or group name |
ESB_PASSWORDLEN | Maximum length of a user password |
ESB_SVRNAMELEN | Maximum length of a server name |
ESB_APPNAMELEN | Maximum length of an application name |
ESB_DBNAMELEN | Maximum length of a database name |
ESB_OBJNAMELEN | Maximum length of an object name |
ESB_MBRNAMELEN | Maximum length of a member name |
ESB_FTRNAMELEN | Maximum length of a filter name |
ESB_ALIASNAMELEN | Maximum length of an alias table name |
ESB_PATHLEN | Maximum length of a file path name |
ESB_LINELEN | Maximum length of a line in a report |
ESB_DESCLEN | Maximum length of application or database description |
The following constants define the available information flags used in the DbReqFlags (Data Load) field in the ESB_DBREQINFO_T structure.
Constant | Definition |
ESB_DBREQFLAG_CALCDEF | Default flag for DbReqFlags field. Used the default calc script. Value: 1. |
ESB_DBREQFLAG_CALCDSCR | Custom calc script flag for DbReqFlags field. Used a custom calc script. Value: 2. |
The following constants define the maximum and minimum size for the MaxMemIndex and IndexPageSize fields in the ESB_DBSTATE_T structure.
Constant | Definition |
ESB_INDEXCACHEMIN_SIZE | Minimum index cache size for the MaxMemIndex field of the ESB_DBSTATE_T structure. Value: 1048576. No maximum value is defined. |
ESB_INDEXPAGEMAX_SIZE | Maximum index page size for the IndexPageSize field of the ESB_DBSTATE_T structure. Value: 8192 |
ESB_INDEXPAGEMIN_SIZE | Minimum index page size for the IndexPageSizeMin field of the ESB_DBSTATE_T structure. Value: 1024 |
The following constants define the available information flags used in the DimTag field in the ESB_DIMENSIONINFO_T structure.
Constant | Definition |
ESB_TTYPE_NONE | No dimension type. Value for DimTag field of ESB_DIMENSIONINFO_T. |
ESB_TTYPE_CATEGORY | Accounts: Currency ACCOUNTS tag. Value for DimTag type of ESB_DIMENSIONINFO_T. |
ESB_TTYPE_CNAME | Country: Currency COUNTRY tag. Value for DimTag field of ESB_DIMENSIONINFO_T. |
ESB_TTYPE_CTIME | Time: Currency TIME tag. Value for DimTag field of ESB_DIMENSIONINFO_T. |
ESB_TTYPE_TYPE | Type: Currency TYPE tag. Value for DimTag field of ESB_DIMENSIONINFO_T. |
ESB_TTYPE_PARTITION | Currency PARTITION tag. Value of DimTag field of ESB_DIMENSIONINFO_T. |