This structure 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. 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 |
Validate |
Restructure |
ClearData |
GetStats |
GetCurrencyDb |
SetCurrencyDb |
SetCurrencyType |
SetCurrencyType |
GetCurrencyType |
GetCurrencyRate |
Export |
ParExport |
DataLoad |
SQLImport |
Import |
StreamDataload |
SQLRetrieve |
CancelUpdate |
ClearUserLocks |
Report |
SpreadsheetOperation |
SpreadsheetCellOperation |
SQLConnect |
SQLListDsn |
SQLGetDsn |
SQLDatabases |
SQLTables |
SQLColumns |
Calculate |
ParseCalcScript |
RunDefaultCalcScript |
SetDefaultCalcScript |
GetDefaultCalcScript |
CalcStats |
ListCalcFunc |
VerifyJavaSpec |
UpdateCdfCdm |
VerifyFormula |
ListUdfs |
UdfInfo |
LoadAlias |
RemoveAlias |
ClearAliases |
ListAliases |
SetAlias |
GetAlias |
DumpAlias |
BuildDimStart |
BuildDimension |
BuildDimFile |
GetDSInfo |
GetSelectedMbrInfo |
GetMbrInfo |
GetMbrCalc |
CheckMbrName |
TestDriver |
GetDimInfo |
GetAttributeNameSpecs |
GetSmStats |
PerfCommand |
GetOtlInfo |
OtlQueryMbrs |
OtlQueryMbrs |
OtlQueryUDAs |
OtlQueryAttrib |
OtlGetUpdateTime |
GetAttrInfo |
CheckAttribute |
PutReplicatedCells |
GetReplicatedCells |
List location aliases |
Create location alias |
Delete location alias |