Introduction

Understanding how Ajilius works in general terms will help you to learn the features of the application, without having to re-learn the basics every time.

We designed Ajilius around five types of screen:

  • List
  • Master-Detail List
  • Data Entry Form
  • Data Entry List
  • Script

Learn the basic use of these screens in the following sections.

List

A list screen – as its name implies – shows a list of a single type of data.

Each list has a title bar. The title bar may have actions specific to the list, such as the “Delete” link in the following example.

doc_ui_list_01

When lists may contain a large volume of data, a search box enables you to progressively filter the list as you type. All columns from the list are included in the filter.

doc_ui_list_02

If a list has more than one screen of data, paging controls support moving to the beginning or end of the list, or moving one page forward and backward. The number of rows per page can be adjusted in the User Settings screen.

doc_ui_list_03

The remainder of the list – referred to as the list body – is dedicated to the rows of data.

doc_ui_list_04

Master-Detail List

A master-detail screen is comprised of two lists, side-by-side. Let’s highlight where they differ from standard lists.

The master list is on the left side of the screen.

doc_ui_master_01

The detail list is on the right side.

doc_ui_master_02

Clicking a link in the master list …

doc_ui_master_03

… causes the detail list to update with information related to the master link.

doc_ui_master_04

Data Entry Form

Data entry forms support the entry and modification of information about your data warehouse and its content.

A typical data entry form is comprised of two sections. The left side has the controls for data entry:

doc_ui_de_01

The right side typically has a rich text editor for documentation. We strongly encourage you to keep your documentation up to date as you go, it helps the richness of the generated user documentation.

doc_ui_de_02

Data entry controls may be optionally grouped into sections.

doc_ui_de_03

You submit the form using the buttons at the bottom right of the screen. The Cancel button is always present, and closes the form returning you to the previous list. Other buttons will depend on the nature of data entry being performed. Typical examples are Add (add the contents of the form to the database), Change (change the database to reflect the details you changed), and Delete (delete the row from the database).

doc_ui_de_04

If we find errors during validation of your data, they are displayed with appropriate messages to help you correct the data.

doc_ui_de_05

Data Entry List

A data entry list is used when the same type of change needs to be applied to multiple rows in the Ajilius metadata.

The two most common forms of data entry list are select-lists and check-lists.

A select-list is a list of items for which a value may be selected from a drop-down list:

doc_ui_del_01

A check-list is a list of items from which one or more may be selected using the checkbox:

doc_ui_del_02

Use the action buttons to submit the form, or cancel and return to the previous screen:

doc_ui_del_03

Script

Script screens are for the testing of ELT scripts that are generated by Ajilius from your metadata.

The script screen has two panels. The left panel typically displays the DDL script to create the table/s in your data warehouse:

doc_ui_script_01

The right panel typically displays the ELT script that extracts, loads and/or transforms your data:

doc_ui_script_02

Execute the scripts using the action buttons at the bottom of the screen:

doc_ui_script_03

Next Steps

Now that you understand the basic screen types in Ajilius, you can move to the next section and learn about how to navigate around the application.

Navigation