Contains information that can be used to display information about, or terminate, sessions and requests. A session is the time between login and logout for a user connected to Essbase Server. A request is a query sent to Essbase by a user or by another process; for example, starting an application, or restructuring a database outline. Each session can process only one request at a time; therefore, sessions and requests have a one-to-one relationship. This structure is similar to ESS_REQUESTINFO_T, with the addition of the ProviderName and connparam fields.
typedef struct ESS_REQUESTINFOEX_T { ESS_LOGINID_T LoginId; ESS_USERNAME_T UserName; ESS_USERNAME_T ProviderName; ESS_CONNPARAM_T connparam; ESS_SVRNAME_T LoginSourceMachine; ESS_APPNAME_T AppName; ESS_DBNAME_T DbName; ESS_USHORT_T DbRequestCode; ESS_DESC_T RequestString; ESS_TIME_T TimeStarted; ESS_REQ_STATE_T State; } ESS_REQUESTINFOEX_T, *ESS_PREQUESTINFOEX_T, **ESS_PPREQUESTINFOEX_T;
Data Type | Field | Description |
---|---|---|
ESS_LOGINID_T | LoginId | A unique number assigned to the user when the user logs in |
ESS_USERNAME_T | UserName | Name of the requesting user |
ESS_USERNAME_T | ProviderName | Name of the user directory. Example: @Native Directory |
ESS_CONNPARAM_T | connparam | Unique identity attribute identifying a user or group in a directory. Example:native://nvid=f0ed2a6d7fb07688:5a342200:1265973105c:-7f46?USER |
ESS_SVRNAME_T | LoginSourceMachine | Server name from which the session or request is being made |
ESS_APPNAME_T | AppName | Active application (if any) for the session or request |
ESS_DBNAME_T | DbName | Active database (if any) for the session or request |
ESS_USHORT_T | DbRequestCode | A positive integer representing an active session. Example: 774896669 |
ESS_DESC_T | RequestString | A string representing the type of request. For possible values, see ESS_REQUESTINFOEX_T. |
ESS_TIME_T | TimeStarted | How long the session or request has been in progress (in seconds) |
ESS_REQ_STATE_T | State; | State of the current session or request: whether it is processing, terminating, or terminated. |
Process xref request
xref test
Restructure
GetCurrencyDb
SetCurrencyType
Export
SQLImport
SQLRetrieve
Report
SQLConnect
SQLDatabases
Calculate
SetDefaultCalcScript
ListCalcFunc
VerifyFormula
LoadAlias
ListAliases
DumpAlias
BuildDimFile
GetMbrInfo
TestDriver
GetSmStats
OtlQueryMbrs
OtlQueryAttrib
CheckAttribute
List location aliases
ClearData
SetCurrencyDb
GetCurrencyType
ParExport
Import
CancelUpdate
SpreadsheetOperation
SQLListDsn
SQLTables
ParseCalcScript
GetDefaultCalcScript
VerifyJavaSpec
ListUdfs
RemoveAlias
SetAlias
BuildDimStart
GetDSInfo
GetMbrCalc
GetDimInfo
PerfCommand
OtlQueryMbrs
OtlGetUpdateTime
PutReplicatedCells
Create location alias
Validate
GetStats
SetCurrencyType
GetCurrencyRate
DataLoad
StreamDataload
ClearUserLocks
SpreadsheetCellOperation
SQLColumns
SQLGetDsn
RunDefaultCalcScript
CalcStats
UpdateCdfCdm
UdfInfo
ClearAliases
GetAlias
BuildDimension
GetSelectedMbrInfo
CheckMbrName
GetAttributeNameSpecs
GetOtlInfo
OtlQueryUDAs
GetAttrInfo
GetReplicatedCells
Delete location alias