2.2.10.1.3.5 QueryContextQueryDefinition

The syntax is defined as follows:          

 QueryContextQueryDefinition= 
   OPEN(133)
   Int32(221) 
 Int32(223)
 Int32(567)
 Int32(231)
 Int32(501)     
 Real64(502)
 Int32(542) 
 Int32(571)
 Int32(572)
 Real64(586) 
 Int32(587) 
 Int16(134) 
 Int16(135) 
 Int16(227) 
 Int16(248) 
 CellFormulas 
 *AxisInformation 
 *CalculatedMembers 
 SkipComingObject
 [SessionQueryContext] 
 Int8(552)  
 [MPATH(551)]
 [SessionQueryContextLevelCustomRollups]  
 [StatefulVisualTotals]
 CLOSE

Element

Description

OPEN(133)

A common data structure that indicates the beginning of the element.

Int32(221)

This is a bitmask that represents the internal state of the query context, as to how calculation is shared between the client and the server.

SESSION QUERYCONTEXT: 0x00000001

QUERYCONTEXT EMULATED MODE: 0x00000002

QUERYCONTEXT ISOLATED MODE: 0x00000004

QUERYCONTEXT ZOMBIE: 0x00000008

QUERYCONTEXT OWNS MPATH: 0x00000010

PN_QC_READONLY: 0x00000020

Query context is in read-only mode (no commit).

Cancel was requested by user: 0x00000100

There are Stateful Visual Totals

on the query context: 0x00000200

Any non-server items should be treated

as not existent, such as ignore client

calculation definitions: 0x00000400

Secure middle-tier setting: 0x00000800

Do not use formula cache: 0x00001000

Debug mode for the Query Context: 0x00002000

Query context is initialized: 0x80000000

Int32(223)

This value indicates the Execution Location. For more information, see [MSDN-ExecutionLocation].

Default: 0x00000000

Optimal performance (application chosen): 0x00000001

Client: 0x00000002

Server: 0x00000003

Int32(567)

This value indicates the Default MDX visual mode. For more information, see [MSDN-DefaultMDXVisualMode].

Int32(231)

Mask indicates which optional properties are to be returned in the query.

FORMAT 0x00000001

BACKCOLOR 0x00000002

FORECOLOR 0x00000004

FONT_NAME 0x00000008

FONT_SIZE 0x00000010

FONT_ATTR 0x00000020

ALIGNMENT 0x00000040

Int32(501)

Bitmask that indicates which SONAR algorithm to use. More information about the Analysis Services SONAR algorithm can be found in [MSDN-ASPIA].

SONAR_POLICY_DEFAULT 0

SONAR_POLICY_WINDOWING 1

SONAR_POLICY_ALLSCAN 2

SONAR_POLICY_ISOLATED 3

SONAR_POLICY_IGNORE_VP 4

SONAR_POLICY_INFINITE_VP 5

SONAR_POLICY_LARGEST_AREA_FIRST 6

SONAR_POLICY_OR_QUERIES 7

Real64(502)

This value indicates a cache ratio (default: 0.5). For more information see [MSDN-CacheRatio].

Int32(542)

Bitmask indicates the Query Context CacheMode (Default: 0xFFFFFFFF). This is for communication between Storage Engine code component and Cache Registry code component.

CACHE_MODE_NOTUSED 0xFFFFFFFF

CACHE_MODE_DEFAULT 0

CACHE_MODE_REGONLY 1

CACHE_MODE_SCAN 2

Int32(571)

This bitmask provides additional information as to which variant of the SONAR algorithm to use.

DEEP_DATA_SET 10

DEEP_REMOTE_DATA_SET 50

DEEP_REMOTE_DATA_SET_INFINITE 0

Int32(572)

This value indicates the depth to be used in the SonarDeepRemoteDataSet.

Real64(586)

This value indicates the SONAR Cache Ratio (default: 0.5).

Int32(587)

This value indicates the number of remaining overall seconds for query time out. Since query calculation is shared between client and server, they must coordinate on remaining time within user-set timeout parameter.

Int16(134)

This value indicates the number of sets. This could be named sets, client defined sets, or an axis.

Int16(135)

This value indicates number of calculated members.

Int16(227)

This value indicates number of user defined functions.

Int16(248)

This value indicates number of cell security restrictions.

*AxisInformation

Repeated for each axis definition.

*CalculatedMembers

Repeated for each calculated member (server side or client side).

SkipComingObject

This data (user-defined function) is ignored.

[SessionQueryContext]

Only when INT32(221) has set SESSION_QUERYCONTEXT bit.

Int8(552)

This value indicates the number of user-defined default members.

MPATH(551)

This value indicates the MPATH including user-defined default members.

[SessionQueryContextLevelCustomRollups]

Only when INT32(221) has set the SESSION_QUERYCONTEXT bit.

[StatefulVisualTotals]

Only when INT32(223) is FORCE_SERVER.

CLOSE

A common data structure that indicates the end of the element.

Show: