AX2314

Design considerations for drill-through drilling

The following design considerations and special behaviors apply when drilling through data in an Axiom file. For more information on how the drill sheet itself is created, see How the "drill-through" drill sheet is created.

Drilling behavior with alternate aggregations

Use of alternate aggregations on an Axiom query or a GetData function have no impact on whether a cell is eligible for drill through, and no impact on the results of that drill. If the source column is eligible for drill through, the drill will be performed regardless of the aggregation setting.

Drilling behavior with data conversions

If data conversion is enabled for the Axiom query or the GetData function, the conversion does not apply to the drill through data. Data will be presented as it was entered in the target detail table.

Drilling behavior for certain Axiom query configurations

Note the following drilling behavior with certain Axiom query configurations:

Configuration	Drilling Behavior
Nested Axiom queries	You can drill through a value from a nested Axiom query. A nested Axiom query is where the in-sheet calc method of one query is used to build out a second "child" query. The drill context will be derived based on the Axiom query where your cursor is currently located. For example, if AQ1 builds out multiple data ranges for AQ2, and your cursor is in an AQ2 data range, then the drill context will be determined based on AQ2. In most cases, this setup will result in values that are eligible for drill-through drilling as you would expect.
Parallel Axiom queries	You can drill through a value from a parallel Axiom query. A parallel Axiom query is where multiple Axiom queries update the same set of rows. The AQ# tags for each query are on the same row. In this case, you can only drill through values from the query that is listed first on the Control Sheet. For example, if AQ1 and AQ2 update the same set of rows, then only those values that come from AQ1 can be drilled. If your cursor is on a value from AQ2, Axiom Software tries to derive the data column using the AQ1 settings. Since no data column is present in the AQ1 settings, the value is not eligible for drilling. NOTE: If the first query context is invalid for drilling (for example, if AQ1 is disabled, or if it has no content in the field definition row), then Axiom Software will attempt to drill on the next relevant query—in this example, AQ2.
Multiple-row field definition	Multiple-row field definitions are not supported for use with drill-through drilling.

Configuration

Drilling Behavior

Nested Axiom queries

You can drill through a value from a nested Axiom query. A nested Axiom query is where the in-sheet calc method of one query is used to build out a second "child" query.

The drill context will be derived based on the Axiom query where your cursor is currently located. For example, if AQ1 builds out multiple data ranges for AQ2, and your cursor is in an AQ2 data range, then the drill context will be determined based on AQ2. In most cases, this setup will result in values that are eligible for drill-through drilling as you would expect.

Parallel Axiom queries

You can drill through a value from a parallel Axiom query. A parallel Axiom query is where multiple Axiom queries update the same set of rows. The AQ# tags for each query are on the same row.

In this case, you can only drill through values from the query that is listed first on the Control Sheet. For example, if AQ1 and AQ2 update the same set of rows, then only those values that come from AQ1 can be drilled. If your cursor is on a value from AQ2, Axiom Software tries to derive the data column using the AQ1 settings. Since no data column is present in the AQ1 settings, the value is not eligible for drilling.

NOTE: If the first query context is invalid for drilling (for example, if AQ1 is disabled, or if it has no content in the field definition row), then Axiom Software will attempt to drill on the next relevant query—in this example, AQ2.

Multiple-row field definition

Multiple-row field definitions are not supported for use with drill-through drilling.

Drilling behavior for "mixed" report configurations

A "mixed" report configuration is one where GetData functions are used within an Axiom query. In this case, the GetData functions are eligible for drill-through as if they were stand-alone GetData functions. All normal drill-down requirements for GetData functions apply.

Axiom Software evaluates the Axiom query for drill-down eligibility first. Because no database column is present in the field definition row for this context, the Axiom query is determined to be ineligible for drill down. Since the parent Axiom query is ineligible, the GetData function becomes the primary drill down context and can be drilled if otherwise eligible.