ESS_REQUESTINFO_T

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)

ESS_REQ_STATE_T

State

The state of the current session or request: whether it is processing, terminating, or terminated.

Request Types

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