Development > Business intelligence > Setup > Dimensions 

This function is used to define the dimension tables containing reference data. These dimension tables can be attached to facts tables in the tab describing the links.

A dimension table is characterized by a list of fields.

Unlike the facts tables, which can be loaded by several synchronization rules (notably because it is possible to have in a same fact table, several facts types characterized by a type), a dimension is loaded using a same synchronization logic. This explains why there is a tab in the dimension table description specifying the way a table is loaded.

ABITUNNEL entry point

The ABITUNNEL entry point is used to modify the value of the OKK variable.

If [L]OKK equals 0 then a tunnel cannot be defined on the dimension.

Otherwise, a tunnel can be defined on the dimension.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

Is used to define the code and the title of the table but also an abbreviation which will be used to access the dimension table via the update processings.

Close

 

Fields

The following fields are present on this tab :

This code identifies the current record in a unique way.

It corresponds to the name of the table that will be created in the datamart database.

  • Abbreviation (field ABRDIM)

The table abbreviation must be composed of 1 to 4 characters (letters or numbers but must start with a letter). It is the unique identifier for all the table abbreviations of the data dictionary. The Adonix reserved words are prohibited.

  • Description (field ZINTIT)

 

  • field W

 

  • Evaluated title (field INTEVAL)

 

Close

 

Tab Description

Presentation

This tab is used to define the general characteristics of the dimension table, notably the loading rules. These rules are characterized by an origin table to which a set of annex tables can be linked, and by an extraction logic condition and a type of extraction. A specific processing code is used to manage exceptions if needed.

Close

 

Fields

The following fields are present on this tab :

Characteristics

An activity code is used to:

  • Make an element optional in the dictionary if the value associated with the activity code is null
  • Identify the specific/custom elements if they are marked with a code starting with X, Y, or Z
  • Size a maximum number of lines when the activity code marks elements from a grid

If the activity code is disabled:

  • The marked element will not be useable
  • The associated code will not be generated nor activated
  • Module (field MODULE)

 

Define the source table that will run through (with the records in the linked tables) on each time that an update of the dimension table will be triggered. This run through will be complete, if the update type is Delete and replace; if not, it will incremental, based on the modified records in the principal table.

  • Key (field INDLEC)

 

  • Extract filter (field FILTRE)

This condition is applied to the records in the source table during the update processes for the dimensions table. If is is not carried out, the record is not retained to be used in the update.

It is important to note that the complex expressions can be applied here, including the conditions used to intervene in the functions defined by the programmer (syntax func PRG.FONCTION...)

  • Update type (field TYPMAJ)

This field is used to define if the loading logic for the dimensions table must be :

  • of the type Incremental(on each triggering, the modifications are copied from the source table). Unlike the facts table, where a database trigger is used, in the case of the dimensions, the date of the last modification or creations is used, which must therefore must exist for the dimension tables.
  • or of the type Delete and replace (all the lines in the table are deleted prior to completely recreating them).
  • field WA

 

  • Delete empty record (field SUPVID)

This option is used to add (or not) an empty line in the dimension table during synchronization.

  • Multi-folder (field MULDOS)

This parameter is used to specify if this dimension is multi-folder or not.

  • Standard script (field TRTSTD)

Used to define the code for an optional process.

If it is entered, this process is called during the update, in order to carryout particular processes.

In this process, a label $ACTION is found and two variables that are used to define the call context :

  • The variable named ACTION is used to define the call context. The possible values are:
    • "DEB_DIM" at the start of the update.
    • "FIN_DIM" at the end of the update.
  • The variable named TABLE is used to identify the name of the dimension table being updated.

Thus it is possible to take control when the update of the dimension does not take place by a simple recopy of the table.

  • Vertical script (field TRTSPV)

 

  • Specific script (field TRTSPE)

 

Grid Links

  • Linked tables (field TABLNK)

Used to define the tables linked to the source table or to one of the tables that precede it in the links grid.

  • Abbreviation (field ABRLNK)

It corresponds to the abbreviation under which the linked table is open.

If this field is not populated, the default abbreviation of the table is used. It is particularly useful to enter an abbreviation if the table appears several times in the grid, since several linked lines in the same table need to be on line simultaneously.

  • Link key (field CLELNK)

It defines the table key code used to read the linked lines. By default, the first key of the table is used.

  • Type (field TYPLNK)

 

  • Link expression (field EXPLNK)

This field is defined as one or more calculated expressions separated by a semi colon. Each expression is evaluated, and the result used to identify the value of the key used to perform the join. When multiple joins are authorized, only the first elements of the key can be given.

In the expressions, constants can be used, as well as fields coming from the tables previously defined in the link list.

  • Date field (field FLDDAT)

This field is used for the setup of the table that contains the fields CREDAT and UPDDAT so as to generate the synchronization of the dimensions.

Grid Folders

  • Folder (field ADXDOS)

 

Close

 

Tab Fields

Presentation

Here is the detailed definition of the fields which can be of type:

  • Dimension (that is analysis criteria).
  • Parent Dimension(analysis criteria defined by another dimension).
  • Information (additional information fields).
  • Technical (fields present in the datamart but that are hidden to the end user. They can notably be used to manage authorizations or to specify the link contexts).

 

Fields

The following fields are present on this tab :

Grid Fields

  • Line number (field NUMDIM)

 

  • Field code (field FLDDIM)

Defines the code for the field in the facts table or the table describing dimensions. This code is that under which the field is known in the database (it is automatically suffixed with the characters "_0"). It is not visible when in the management reports (it is the title that is displayed) but can be viewed if looking at the SQL syntax that extract the data from the datamart.

  • Description (field ZINTDIM)

 

The field type is defined here, which characterize the entry format (numeric, any characters, date...) and the coherence controls (reference to a table for example).

The principal generic types that exist :

A : Alphanumeric
C : Short integer
L : Long integer
DCB : Decimal
D : Date
M : Local menu
MM : Local menu with filter
ACB : clob
ABB : blob

But many other predefined types exist. They often make reference to an annex table (currency, country...). A dedicated dictionary is used to described them and they can be selected using the key that is used to obtain the list.

  • Lg (field LNG)

Used to define the length of a field when this field uses a generic data type where the length is not fixed. This is notably the case for the types A and DCB.

  • Date (field TYPDAT)

When a field from the facts or dimensions table is of the type date and is defined as dimension, it is automatically associated with a dimensions table named AX3DAT, which is automatically managed.

It is then possible to specify here what are the time characteristics linked to the date that will be accessed in the analyses. A list of characters to be defined is given, not forgetting there are the following correspondences :

  • Y=year
  • S=half year
  • Q=quarter
  • M=month
  • F=fortnight
  • T=decade
  • W=week
  • D=day

Thus, for example, YMW signifies that a direct access is available for the year, the month and the week defined by the date.

  • Menu (field MENLOC)

Defines the local menu number associated with the field defined on the line.

When a field is of the type local menu (from 1 to 255) corresponding to the rank of a title in a table named local menu, stored in the messages table APLSTD.

On entry or on display, the following are displayed according to the choices made in the user interface :

  • either a title can be chosen in a scrolling list commonly called a combo box
  • or a list of buttons.

The interest of this type of entry is that the list of choices is displayed in the user connection language.

Each local menu number characterises the list of available titles. For example, the local menu 1 corresponds to the choice No / Yes in this order. In this particular case, the user interface can also be a check box.

If the field is associated with a miscellaneous table, the number that identifies it is defined here.

  • Object type (field TYPFLD)

Used to characterize the data in the dimensions table. The following values are possible:

  • Dimension signifies that the field is considered to be an analysis criterion stored in the dimensions table.
  • Dimension signifies that the field is considered to be an analysis criterion linked to another dimensions table. In certain cases (the fields of the type date, local menu, miscellaneous table) the dimension table is implicitly manage by the software package.
  • Information corresponds to a field that will be presented in the reports, but it is not considered as being descriminant from the point of view of the analysis and the data aggregation.
  • Technique corresponds to the fields that are used in the data structure (for example to define the links), but which do not need to be visible when constructing the reports.
  • Self-join (field ZAUTO)

 

  • Tunnel toward object (field TUNNEL)

 

  • Linked dimension (field FLDLIE)

When a field is of the type Information in a dimensions table, it must be attached to a field of the type Dimension. Therefore one of the fields of the type Dimension present in the dimensions table is entered here.

When the field is of the type Parent dimension, the dimension code is entered here to which it is attached.

  • Dimension title (field ZDIMINT)

 

  • Name of field (field DIMFLD)

 

  • Join option (field OPTJNT)

 

  • Loading formula (field FLDORG)

This adonix calculation formula is used to define the fashion in which the field is loaded in the dimensions table when the datamart is updated from a folder in the software package.

Such a formula can include constants, the fields coming from the tables declared in lines, the standard functions, but also the functions defined by a developer (by the syntax func PRG.FONCTION).

An activity code is used to:

  • Make an element optional in the dictionary if the value associated with the activity code is null
  • Identify the specific/custom elements if they are marked with a code starting with X, Y, or Z
  • Size a maximum number of lines when the activity code marks elements from a grid

If the activity code is disabled:

  • The marked element will not be useable
  • The associated code will not be generated nor activated

Additional info

  • Key (field CLE)

A dimension table must have available an index where the key values that are used to establish a join between the facts tables or other linked dimensions. This field is used to define these characteristics.

This is where the list of fields that make up the index are entered. The fields are separated by a '+' if there are several fields (for example, in the sites table FACILITY there is a key whose definition is LEGCPY+FCY).

A descending sort field is preceded with the sign "-" (warning, it is used in the left list).

The first field that makes up the index is without a sign and is therefore ascending.

  • field NAMCLE

 

  • Object "number of" (field NOMBRE)

When this box is ticked, an object Number is added in the created universe, this is used to directly access the number of lines in the dimensions table(globally or on given criteria).

 

Action icon

Field Selection

Fields

The following fields are included in this window :

Block number 1

The table code must be composed of 1 to 10 characters (letters or numbers but must start with a letter). It is the unique identifier for all the table abbreviations of the data dictionary. The Adonix reserved words are prohibited.

Grid

  • Field (field CODZONE)

Corresponds to the name field in the database table (this name is automatically completed with "_0").

  • Description (field INTITCOURT)

Title associated with the previous code.

  • Y/N (field SELECT)

If the response is Yeson the line, the selected field is transferred with its characteristics (type, length...) to the screen from which the selection function has been called.

It should be noted that, by right click on the line (without being in entry on the field), it is possible to globally set the lines to Yes or No from the current line.

Close

This function is used to add to the field grid fields coming from a table entered previously in the header of the window being opened from the current line. The origin table is proposed by default.

Default values are applied to the grid containing the lines that are thus recovered:

  • The main characteristics of the field are recovered as is (title, type, length, local menu, miscellaneous table, etc.)
  • Once the field is characterized by a type linked to an object (or if it is of the type Dateor Miscellaneous table, it is defined as a Parent Dimension.
  • If it is of type DCB, it is defined as a Measurement.
  • Otherwise, it is defined as an Information linked to the closest dimension.

If fields having the same title as a field to insert already exist, they are not inserted.

 

Close

 

Specific Buttons

This function generates a processing whose name is defined by "WMD" followed by the table code, and compiles it. This processing is automatically called by the datamart update processings.

The following fields are included on the window opened through this button :

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

  • All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).

  • To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

Close

This button is used to copy the record definition from or to another folder.

Menu Bar

Documentation / Paragraphs

This menu item allows access to the documentation management on the first paragraph of the documentation (if there is one) associated with the current record.

Documentation / Links

This menu item allows access to link management. It is used to define the links between the current record and other records (for example, the links between functions and parameters). These links are specific to the documentation and are used to load the generation of documentation structures.

Documentation / Generation

This menu item launches a documentation generation. You can also launch it from the Generation button at the bottom of the screen.

You can launch three types of generation one by one or simultaneously

  • The generation of the documentation structure from the dictionary (ADOCUMENT, ADOCBLB, and ADOCCLB tables)
  • The generation of the documentation from the previous tables
  • The generation of the field documentation

The range suggested by default takes into account the current record, but you can modify it at launch time.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation