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.
typedef struct ESS_REQUESTINFO_T { ESS_LOGINID_T LoginId; user login identification tag ESS_USERNAME_T UserName; user name ESS_SVRNAME_T LoginSourceMachine; Login machine name ESS_APPNAME_T AppName; connected application ESS_DBNAME_T DbName; connected database ESS_USHORT_T DbRequestCode; Request code ESS_DESC_T RequestString; Request string ESS_TIME_T TimeStarted; time started (in seconds) ESS_REQ_STATE_T State; current process state } ESS_REQUESTINFO_T, *ESS_PREQUESTINFO_T, **ESS_PPREQUESTINFO_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 | The name of the requesting user. |
ESS_SVRNAME_T | LoginSourceMachine | Server name from which the session or request is being made |
ESS_APPNAME_T | AppName | The active application (if any) for the session or request |
ESS_DBNAME_T | DbName | The 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 Request Types below. |
ESS_TIME_T | TimeStarted | how long the session or request has been in progress (in seconds) |
State | The 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