AX2645

Managing column sequences

Tables can have one or more column sequences. You can create, edit, and delete sequences when creating or editing a table.

Column sequences can be used with data tables and reference tables (except picklist tables or KPI tables).

NOTE: Column sequences do not apply to virtual tablesA table that is used to present data queried from other tables. Instead of storing data in the table itself, a SQL statement is used to generate a data view. Virtual tables can be used in Axiom queries and other data queries just like any other table. or tables using the large table index scheme. The Sequences tab is not present when editing these tables.

Adding a sequence

Column sequences can be added to a table at any time. The ability to add column sequences is limited to administrators and to users with the following security permissions: either the global Administer Tables permission, or the Allow changing table structure permission for individual tables.

To add a sequence:

  1. From the Sequences tab of the Edit Table dialog, click Add Sequence.

    (missing or bad snippet)

    The New Column Sequence dialog opens.

  2. In the Sequence Name box, type a name for the sequence.

    (missing or bad snippet)

  3. If the sequence is for a partial year of data, edit the Start Period to reflect the starting period of the data.

    In most cases, the start period is 1 and does not need to be changed. However, if the sequence is for a partial year of data, you can specify the start period for the sequence.

    Example

    Imagine that you want to define a sequence for last year's data, but the table only contains columns for the last two months of the prior year. If you define those two months as a sequence, and leave the start period as 1, then Axiom Financial Institutions Suite will interpret the two columns as the first two months of the year rather than the last two, which would make some calculated fields incorrect. To correctly identify the two columns as the last two months of the year, you can set the Start Period to 11.

  4. In the Available Columns box, select the columns to be included in the sequence, then click Add to move them to the Columns in Sequence box.

    You can use the SHIFT and CTRL keys to select multiple columns. If a column is added in error, use the Remove button to remove it from the Columns in Sequence box. You can also click Undo Changes to undo any changes made to the column list in the current session.

  5. In the Columns in Sequence box, adjust the order and weight of the columns as necessary.

    (missing or bad snippet)

  6. Click OK to close the New Column Sequence dialog.

  7. To save the new sequence, click Apply (or OK if you are finished editing the table).

Editing a sequence

Column sequence properties can be edited at any time. Keep in mind that changes to a sequence may impact associated calculated fields, drill-through definitions, and data conversion.

The ability to edit column sequences is limited to administrators and to users with the following security permissions: either the global Administer Tables permission, or the Allow changing table structure permission for individual tables.

To edit a sequence:

  1. On the Sequences tab of the Edit Table dialog, select the sequence that you want to edit.

    (missing or bad snippet)

  2. Click Edit Sequence.

  3. In the Edit Column Sequence dialog, edit the sequence properties as desired, and then click OK.

  4. In the Edit Table dialog, click Apply or OK to save your changes.

Deleting a sequence

You can delete a column sequence from a table. If a sequence has associated calculated fields, those fields will also be deleted when you delete the sequence. If a sequence has associated drill-through definitions, then drill-through drilling will no longer be available for the columns in that sequence.

NOTES:  

  • You will be prompted to confirm the deletion before it occurs, but the confirmation prompt does not identify whether the sequence has any associated calculated fields. Before deleting the sequence, check the Calculated Fields tab for the table to be sure that no calculated fields use the sequence.
  • You cannot delete a sequence if it is mapped as part of a data conversion.

The ability to delete column sequences is limited to administrators and to users with the following security permissions: either the global Administer Tables permission, or the Allow changing table structure permission for individual tables.

To delete a sequence:

  1. On the Sequences tab of the Edit Table dialog, select the sequence that you want to delete.

    (missing or bad snippet)

  2. Click Delete Sequence.

  3. At the confirmation prompt, click Yes.

    The sequence is removed from the list.

  4. Click Apply or OK to save your changes.
See also