Dive Tags

Adds a new column to the window after it is built with arranged dimension values and any summarized values.

NOTES:

• Unlike column, which creates summary columns at the creation of the window, the add occurs in sequence with other window operations.
• An add calculation can use information about the window's sort order and filtering, which column calculations cannot do.
• Add tags can refer to column tags.

Automates inclusion of rows between an explicit start and end of a rotate. Use within a rotate block.

The optional attributes left-inclusive and right-inclusive can be used to specify an exclusive range.

This example snippet rotates columns 2 through 12 into rows.

Refers to a summary column, or calculated column defined in the cPlan or in the window block.

NOTES:

• The column tag can be followed by an expression, or label and format tags.
• A column tag makes a summary from detail records.
• A column tag cannot refer to another column tag or an add tag.

• Column and dimension tags are always processed (and data generated internally) before all other operations in a window, which are then processed sequentially.

Creates a CrossTab by adding a cross dimension and column.

NOTE: When multiple dimensions and columns are listed in the cross block, the result is a MultiCrossTab window.

Specifies an xlsx file to use as input, along with options for interpreting that data in the file. The following attributes are supported for use:

• sheet—Specifies which sheet in the Excel file to pull data from. The value can be either a name or a number. Spectre checks for a name match first. If that fails, it will try treating sheet as a number. Name matching ignores case, and if multiple sheets have the same name it will only look at the first one that matches. If this value is empty, then the first worksheet in the Excel file is used.

• range—Specifies a range of cells to use from the input. Any cells outside of the range are ignored. The format for the range is the top-left cell (column letter and row number), followed by a colon, followed by the bottom-left cell (column letter and row number). For example:

  A1:D25 returns the 25 rows from the first column (column A) through the fourth column (column D)

• limit-rows—Directs the build to use a specific number of rows from the Excel file.

• headers—Indicates the presence or absence of column headings in the Excel file. Set to false to name each column manually.

• start-row—Defines the row number to begin reading data from. If this value is empty, Spectre attempts to automatically determine which row represents the start.

  NOTE: If the headers value is set to true, the value of start-row should be the row number the header is on.

• password—Provides a password if the Excel file is password-protected. It is not recommended to use password-protected Excel files as data sources.

• trim—Removes any leading or trailing spaces from the data. This is the default behavior for Spectre. Set to false to disable the trimming of white space.

Controls presentation of the data for a dimension or column.

NOTE: The format tag may be provided on a window dimension even if that window dimension is a rollup. If not provided, the format will be the default format because rollup dimensions do not inherit format.

See Spectre Format Conventions.

TIP: A Dive file's "format=" takes precedence over a cPlan's "format=" property.

Takes the summarized rows of that window, uses them to filter a different cPlan, and then switches the dive over to that cPlan. Any subsequent windows work on the new cPlan.

A parent window, which is any window except the last one, can have a jump tag in it.

In this example, the dive jumps to extra.cbase. The only dimension in this window is "Mood", so this filters extra.cbase to only the "Mood" values present in this window, which are the top 3 by Weight.

After the jump, subsequent windows are based on the filtered extra.cbase data.

Identifies a heading column that indicates which columns are rotated to create a row, and value columns for the rotated column values. This tag names the columns that the respective row-out arguments refer to.

TIP: Elements for the rotate-output-names are labeled Row Name Column and Value Columns in the GUI.

Sorts the data in the window by the specified column or columns. The reverse tag reverses the sort order.

If an alternative sort is defined for a named string column when the cBase is built, the alternative sort order is used for the Dive.

Specifies a Tunnel script as the source for the input data. The tunnel script is executed and Spectre treats the resulting table of data as if it were a text file.

As with other data inputs, tunnel-input takes parameter provisions (same as in dive-input blocks), column options (same as in text-input blocks), and the stale-after option (same as in odbc-input blocks).

Available starting with Spectre 7.1(6).