Creating an Ad Hoc Analysis Variant

Context

An ad hoc analysis variant is only available for the currently scheduled table analyses. The definition of this variant is not saved on the database, and therefore is available only for the table analysis you are currently scheduling.

Procedure


  1. With transaction TAANA you can access the screen Table Analysis:. Administration.

  2. Choose Start of the navigation pathTable Analysis Next navigation step ExecuteEnd of the navigation path. A dialog box appears.

  3. Enter the table name.

  4. Choose the input help for the Analysis Variant.

  5. In the dialog box Analysis Variants: Selection, choose Ad-Hoc Variant.

  6. Select the fields for the analysis variant.

  7. Choose Continue.

    Alternatively, you can restrict the analysis to part of a table field, for example, to perform an aggregation on the year for date fields. To do this, you use the DDIC definition of the table you want to analyze to specify the fields you want to aggregate as subfields, and to specify the offset and length required. Enter the values in the offset and length subfields, for example, offset = 0, length = 4 if you want an aggregation over the year for a date field.

  8. Apply the analysis variant.