Context Values

This page is for advanced users. If you are not familiar with ActivePivot, MDX and OLAP concepts, we do not recommend to modify context values.

This page details a list of selected core context values available for ActivePivot 5.7. For an exhaustive and up-to-date list of all context values, please refer to ActivePivot 5 wiki

Those context values can be set at runtime through the user interface for a specific query. Whenever the context values need to be applied independently of the query for a specific user, a specific role or all users, it is recommended to declare them on the backend with the definition of the cube.

In the scope of your project, it is possible that custom context values have been defined. They would not be listed here.

MDX

mdx.aggressiveFormulaEvaluation

Restrict formula evaluation during crossjoin to tuples existing in the cube, instead of all possible tuples. Turn it off if you have a calculated measure that returns a value even against members with no contributors.COUNT.

Turning off this flag might drastically affect performance.

Default Value: true

mdx.axisPositionLimit

The maximum number of members allowed per axis in the result. If one axis contains more than this limit, it will throw an exception. If set to -1 no limit is set. This check is performed after evaluating NON EMPTY, light crossjoin and filters.

Default Value: -1

mdx.caseSensitive

If the mdx engine is case sensitive. It must be set to true when 2 members have unique names that are case insensitive equal. For instance [Underlyings].[ALL].[AllMember].[EUR] and [Underlyings].[ALL].[AllMember].[eur].

It is not recommended to turn this off.

Default Value: true

mdx.cubeFormatter

Define the cube's locale.

Default Value: en-US

mdx.defaultMembers

Map each hierarchy unique name to a list of possible default members. For example mdx.defaultMembers.[Geography].[City]: [ALL].[AllMember].[Berlin]

Default Value: undefined

mdx.formatters

Map each measure or level unique name to its formatter. For example: mdx.formatters.[Measures].[contributors.COUNT]:DOUBLE[0.0000]

Default Value: undefined

mdx.hiddenGrandTotals

A comma separated list of axis' ordinal to display without grand totals. This is equivalent of the Excel feature 'Remove Grand Total'.

For instance:

  • to hide the grand total from the column axis: mdx.hiddenGrandTotals: 0
  • to hide the grand total from the column and row axis: mdx.hiddenGrandTotals: 0,1

Default Value: undefined

mdx.hiddenSubtotals

A comma separated list of level's unique names to display without sub totals. This is equivalent of the Excel feature 'Remove Subtotals'.

For instance:

  • to hide any axis subtotal from the City level: mdx.hiddenSubtotals: [Geography].[City].[City]
  • to hide any axis subtotal from the City and Desk levels: [Geography].[City].[City]: mdx.hiddenSubtotals: [Geography].[City].[City],[Booking].[Desk].[Desk]

Default Value: undefined

mdx.ignoreInvalidMembers

Will prevent the engine from throwing an exception if encountering an invalid (i.e. inexisting) member.

Default Value: true

mdx.lightCrossjoin

When light crossjoin is enabled, the intermediary cross totals of the result set are not computed and not returned.

Example with lightCrossjoin: false :

  [AllMember, A, B]
* [AllMember, C, D] =
[
    (AllMember, AllMember),
    (AllMember, C),
    (AllMember, D),
    (A, AllMember),
    (A, C),
    (A, D),
    (B, AllMember),
    (B, C),
    (B, D),
]

Example with lightCrossjoin: true :

  [AllMember, A, B]
* [AllMember, C, D] =
[
    (AllMember, AllMember),
    (A, AllMember),
    (A, C),
    (A, D),
    (B, AllMember),
    (B, C),
    (B, D),
]

Default Value: false

mdx.resultLimit

The maximal number of cells allowed in the query result. An exception will be thrown if the result is greater than the defined limit. If set to -1 no limit is set.

Default Value: -1

Drillthrough

drillthrough.behavior

This context value specifies the behavior of the drillthrough engine when an exception occurs during the evaluation of a drillthrough post processed column. Three behaviors are available: SILENT, WARN, THROW.

  • SILENT: the exception is swallowed, and the result of the post processed column will be "N/A".
  • WARN allows to log the exception (WARNING level), but it is still swallowed and the result will still be "N/A".
  • THROW allows not to swallow the exception: the drillthrough query will then fail.

Default Value: SILENT

drilthrough.maxrows

Specifies the maximum number of rows that drillthrough queries are authorized to return. If this context value is set and the query engine realizes a drillthrough query will produce more rows than allowed, an exception is thrown.

Default Value: undefined

Epoch

epoch.id

Perform the query as of a specific epoch, using the epoch id. For instance epoch.id: 123

Default Value: undefined

epoch.strict

If enabled, any query performed with an unknown epoch id will throw an exception. Otherwise, the engine will fallback to the closest available apoch id.

Default Value: false

Miscellaneous

queriesTimeLimit

Any query which execution time exceeds this limit will be interrupted. Defined in seconds.

Default Value: 30

← ChartsDashboards →