Tabular Report Writer allows you to define and execute snapshots of the enterprise’s transactional activity for a certain date and time. The Tabular Report module includes the following interfaces:

  • Setup Report
  • Generate Preview of the report
  • Generate tabular reports in the hard copy and/or electronic format

Reports generated by the Tabular Report Writer provide combined views of the entire data set (or a segment of it if you use logical conditions) from all sources in the data model on all levels of aggregation simultaneously. 

Tabular Report Editor Screen

The Tabular Report Setup screen (Fig.) follows the general design concept of Task Setup screens and consists of the following basic components:

  1. Pull-down menus
  2. Main Toolbar
  3. Report Selection Pane
  4. Tab Pane

File Menu

File Menu of the Tabular Report Writer (Fig.) provides the following standard functionality:

New Tabular Report

Opens a blank Tabular Report Writer filled with default parameters

Open Tabular Report

Selecting this option opens the Tabular Report Lookup (Fig.). 

Tabular Report Lookup

Task lookup of a Tabular Report Editor screen (Fig.) lists tasks available for selection.

 Clicking on a Tabular Report name activates an array of buttons on the bottom of the Lookup window.

  button opens Tabular Report Version Selection window (Fig.) chronologically listing modifications of the highlighted Source (see Saving Source setup below).

 

 

 button opens a read-only lookup listing all permutations of the highlighted Tabular Report version setup.

Note: Pressing the OK button of the Tabular Report Lookup will open the LATEST version of the selected Task.

 button of the Tabular Report Lookup opens a Deleted Tabular Report Versions window listing versions that have been removed from the active inventory but exist in the compressed form for possible retrieval and reactivation.

Tabular Report Version

Tabular Report Versions enable users to keep the track record of the particular task’s modifications and deletions. The system creates a version of the Tabular Report saved under the same name. Versions are identifiable by the date of the save, name of the user, and by the statement entered in the Comment dialog. 

The system assigns a numeric order to a Tabular Report Version and the modification type (NEW or UPDATE). The latest saved Task version will be an active (executable) variant of the Tabular Report. 

The previously saved versions of the Tabular Report are stored in archived form and will not be available for execution or results viewing. They will only be accessible from the Editor screen where you would be able to retrieve and re-save them to make them “working” versions.

Save Tabular Report  

If you are saving a newly created task for the first time, the system will produce a Name Dialog (Fig. 5), where you would enter a name and description.

Whether you are saving (saving as) a new Task or after making changes to an existing one, the system will prompt you to write a short comment. The Enter Comment dialog window will open (Fig. 6) when you press the OK button of the Name Dialog prompting you to enter a short statement describing the purpose/scope of the changes. 

These comments are helpful when identifying stages of the task buildup and tracking the modifications. 

When saving tasks the system performs operations that are specific to a particular task’s purpose. It creates tables, instances, and sources, builds data models, inserts fields, etc. All these actions are covered in detail further in this document as we discuss various tasks’ setup.

Save As

This function saves a currently open Tabular Report under a different name. The Name Dialog will open containing the current name and description. Type in a new name and description and press OK to complete the Save As operation.

Rename Task

Selecting this option opens a dialog window where you will be prompted to enter a different name and description for the current task.

Note: This is not an equivalent to the Save As. No copy of the current task will be made.  

Track Current Tabular Report History

Selecting this option accesses Tabular Report Version lookup (Fig.) where you can see the history of changes done to the selected Tabular Report setup.

A new Task Version is created each time you save the task setup. The latest version of the task is its working version. 

The system allows retrieving the setup at any stage of the development recorded in Task History. The retrieved task version can be re-saved to render it a working version. 

The retrieved version of the report could also be ‘saved as’ should the need arises to go in another direction from that point. 

View/Override Locks

To avoid conflicts, the system prevents several users from working on the same source simultaneously. Selecting View/Override Locks option accesses the Locks Manager where you can view and, if you have the appropriate access permission level, override system locks. 

Remove locks by right-clicking on the Lock icon and selecting Remove from the right-click option menu. 

Hanging Locks

“Hanging lock” may occur when the system was not shut down properly and other systematic errors or glitches which unfortunately can place in any environment. These are the locks that linger from the previous sessions preventing users from opening their own tasks and their names are listed in the window as the holders of locks. If this happens, you have to remove it using the Lock Manager or, if you do not have permission to do so, consult your SA.

Generate Report

This option allows you to print the contents of the currently open screen. In the case of the Data Source Editor, for example, you will be able to print out all details of the current source setup including source layout, loader actions, etc. 

The Print Setup screen will open where you can adjust page orientation, font selection, etc. When done, the Print Preview screen will open prompting you to initiate printing or generate a PDF file. 

Save as a Favorite

This option allows you to save the setup of the task as a favorite. Favorite objects are listed separately in the Favorites pane of the Project Management screen for easy access.

The Dialog window will open (Fig. 8) prompting you to enter a name and a description for the Favorite.

Shared checkbox – A checkmark here will make the Favorite accessible to other users.

 

 

Edit Menu

The contents of the Edit pull-down menu dynamically change as you switch from tab to tab and reflect the current tab’s functionality. 

Execution Menu

The execution menu contains one option that initiates printing the current report.

 

View Menu

View menu provides access to the Report Preview screen.

Main Tool Bar

Main Tool Bar of the Tabular Report Writer (Fig.) consists of buttons that largely duplicate the functionality of the above-described pulldown menus. 

 New           Open        Save    Save As       Delete Favorite         Print       Execute Preview 

 

 Report Preview 

The report Preview function allows you to see how your report is going to look and modify the setup. 

In order to run the preview, you have to select Model dates for each Data Model associated with the current report. To do this, open the screen’s Date for Preview tab and select available model instances from the arrow button menus available for each model involved in the report.

Report Selection Pane

Report Selection pane (Fig.) provides additional access to the Reports Lookup. 

The name of the currently selected report is shown next to the Report selection button.

The pressing  button opens the Rename Report dialog where you can change the report’s name and description. 

Tabs Pane

Tabs Pane consists of the series of tabs where you set up parameters for your report. Report parameters include Data Model, Detail fields, and Calculated field selection. You also may need to map selected fields to the corresponding columns in the source models. Assigning Logical conditions to the report helps to narrow down data on display as dictated by your area of interest. Setting up footers/headers and other “cosmetic” features will improve the visual comprehensiveness of your report.

Models Tab

On the Models tab (Fig. 11) you select data models containing sources of data for your report. Selected data models may include original segmented or continuous sources, data models generated in the course of execution of the Portfolios and/or Aggregations, or a combination of the above.

Model Tab’s Tool Bar  

Buttons of the Model Tab’s Tool Bar (Fig. 12) provide standard functionality for this type of screens. Data Grid’s toolbar provides functionality to: 

 Add – adds a row to the grid

 Insert – inserts a row above the selection

 Delete – removes selected rows from the grid

 Copy – copies selected rows to the clipboard

 Paste – pastes the rows from the clipboard into the grid

 Move up and down – arranges rows in the Data grid

 Button appears dynamically when you click on the Model Name in the grid and provides direct access to the Model Editor screen.

Data Grid

Into the Tab’s Grid, you insert models that contain data you need to report. 

Fields Tab

On the Fields tab, shown expanded in order to display the entire contents of the tab’s grid (Fig.) you determine what data will be shown on the printout of the report. Obviously, there will be columns containing numerical information that reflects the purpose of the report. The system allows you to include any other field available from the main source table or detail set on which the report is based.

The data in the selected fields will be displayed throughout the report for every combination of the Detail field selected on the Subtotals tab.

Aggregate Data Records with Identical Attributes  – ‘Yes’ here indicates that the system will aggregate all transactions with identical contents of the report columns selected on the Fields tab, with the summarized (calculated) fields.

Data Records Include all Subtotal Elements – ‘Yes’ here activates the Detail Set selection pane.

Data Grid:

Data Grid of the Fields Tab displays the selected report fields. After selecting fields for the display you can:

  1. Set up calculation formulas in order to fine-tune the data display using auxiliary fields and simple commands.
  1. Set up data display parameters, e.g. dates, numbers, column widths, etc.
  1. Set up new fields for consolidating data from different original fields.

Field Name – Into this field you enter the column name as it exists in the source. You can type column names manually or select them from the Lookup. 

Detail Description – Into this field you enter the column name as you want it to appear on the report.   

Aggregation Type – Relevant only for Amount fields. The arrow button menu (Fig. 14) lists aggregation types supported by the system.

Show in Totals – The checkmark here indicates the total will be calculated for this synthetic field. If the field is going to contain a percentage of values or any other type of value for which calculating totals makes no sense, the checkmark should be removed. 

Calculation Formula – Into this field, you can insert a calculation formula using SQL syntax.   button provides a list of fields available for the formula use.

Auto Width – Checkmark here will initiate automatic field width adjustment depending on the size of data

Column Width – Into this field, you enter a number of characters you know the data there would not exceed.

Value Format – Use the menu to select from supported formats.

Sort Order – Use the menu to select from available options – None, Ascending, and Descending.

Sorting Sequence – Here you distribute the sorting priorities among columns of the report. Field marked with number 1 will be used first in the sorting sequence. Within this arrangement the field numbered 2 will be used second and so forth. 

Detail Set Selection Pane

The system allows you to base the report on a Detail Set. Detail set is a combination of details (fields of the source) that can be mapped to the multiple models and then stored across the system for subsequent use with conditions, portfolios, aggregations, and other tasks permitting multiple model environment. 

 button opens a lookup where you can select a detailed set compatible with the data models you have selected for your report.

 button opens the Detail Setup screen where you can view and edit the selected Detail Set and Mapping Tab

One of the crucial steps in the Tabular Report setup is mapping the report fields to the corresponding fields of the original data source. It is done on the Mapping Tab (Fig.). 

Although the initial mapping is done automatically, sometimes, especially in multiple source environment or/and when Add New button was used when entering display fields, the system fails to identify the appropriate source field. In this case, you would have to do the mapping yourself by using the lookup. 

The system also allows you to modify the initial mapping by replacing system-selected column names with other column names from the lookup.

 The read-only pane on the left side of the tab lists all fields defined for the report. 

Field Mapping Parameters Pane

Field Mapping pane displays mapping for each field of the report. Each row in the pane’s grid represents a Data Model involved in the task.   

Model Column

Filled by the system this column displays the report’s model names.

Expression column

As a rule, Mapping is done automatically. The system scans all the sources and identifies the source columns that correspond to the selected fields. 

You can modify the default mapping by selecting other column names from the lookup. 

  1. Click on  button to open the lookup window.
  2. Select an appropriate column name from the lookup and click OK

If the system fails to map a data attribute to a column in one or several data models, the corresponding cells will be left blank. In this case, the mapping should be done following the above-described steps.

Manual Input

You can also enter the column names manually by double-clicking on the input area and typing in the information. When doing so make sure to include the prefix of the column name.

Mapping Expression

The system allows you to fine-tune the mapping by writing an SQL expression into the Expression field.  For example, you may want to insert an expression for currency conversion, Buy/Sell indicator selection, etc. The lookup, in this case, will provide you with referenced column names preceded with the $ sign.

Note: In order to appear in the Lookup, reference columns must be set up as auxiliary fields.

Value Type

This field becomes active when a Calculation formula is used. You are enabled to select the appropriate Data format from the arrow button menu (Fig. 16).

Value Size

This field becomes active when a Calculation formula is used and Value Type is set on ‘Character’. Input here indicates what number of characters the value in the field would NOT exceed.

Value Nullable

This field becomes active when a Calculation formula is used. Check Mark here will allow nulls in a Calculated field.

 

Synthetic Fields Tab

Synthetic fields are report-specific columns created in order to display the results of various ad-hoc calculations. Populated during the report execution, synthetic fields are displayed on the report only and data there is not stored in the Database. 

For a Synthetic Field to function, it requires a name, title, and calculation formula (Value Expression). For instance, if as a result, the user has exposure in local currency and exchange rates the system can calculate exposure in home currency.   

Fields used in the formula are referenced by name, prefaced with a “$” sign. For example, the formula for converting the exposure into the home currency will look like: 

$exposure_in_local_currency * $exchange_rate

Note: Please keep in mind that both fields should be defined prior to this calculation. 

If depending on the type of the currency, there is a need to alternate the types of the calculations (i.e. division vs. multiplication) he may use logical conditions (if). 

Note: Axiom supports MS Excel syntax for calculations and conditions setup.

Synthetic Fields tab, shown on the illustration below in the expanded version (Fig.) consists of the data grid equipped with the standard Tool Bar for inserting, deleting, copying, pasting and moving rows.

Field Name/Field Description – Into these fields you enter the field name and its description. You can type names manually or by selecting them from the Lookup.

Show in Totals – The checkmark here indicates the total will be calculated for this synthetic field. If the field is going to contain a percentage of values or any other type of value for which calculating totals makes no sense, the checkmark should be removed.

Calculation Formula – Into this field, you can insert a calculation formula using SQL syntax.  button provides a list of fields available for the formula use.

Auto Width – Checkmark here will initiate automatic field width adjustment depending on the size of the data.

Column Width – Into this field, you enter a number of characters you know the data there would not exceed.

Value Format – Use the menu to select from supported formats.

Sort Order – Use the menu to select from available options – None, Ascending, and Descending. 

Sorting Sequence – Here you establish the sorting priorities by various columns of the report. Field marked with number 1 will be used first in the sorting sequence. Within this arrangement the field numbered 2 will be used and so forth.   

Auxiliary Fields Tab

Auxiliary Fields are fields from the source model that contain data used in ad-hoc calculations to modify data in the fields of the report but do not appear on the report themselves. These fields are referenced in the calculation formula for the report’s fields (see Fields Tab).

For example, your model may have a field called “foreign gross amount” and another field called “exchange rate” while the report requires the results in “Domestic gross amount” expressed in domestic currency. In order to convert the “Foreign” amount in the domestic currency, you would multiply the “foreign amount” by “exchange rate”. 

If, at the same time, you do not want to show the “foreign gross amount” and “exchange rate” fields in your aggregation results you would:

  1. Set them up as auxiliary fields into the Auxiliary Fields tab
  2. On the Fields tab create a new field called “gross_domestic_amount” and as the formula enters “foreign gross amount” * “exchange rate”.

Auxiliary Fields tab (Fig.) consists of the data grid where you insert the columns that are to serve as the auxiliary fields and a standard Tool Bar.

 button opens the Column Lookup listing columns from the source data model(s).

Note: you CAN NOT use columns selected as display fields for auxiliary fields setup. 

 Buttons insert a row into the grid allowing you to manually enter the name and description of the new Auxiliary field. 

Subtotals Tab

On the Subtotals tab (Fig.) you select Detail fields for which you want the system to summarize data when compiling the report. The summaries will be calculated and displayed for every combination of the selected details. The following components constitute the Subtotals Tab:

Subtotals Tab Tool Bar  

Buttons of the “Subtotals by” Tab’s Tool Bar (Fig. 19) provide functionality standard for this type of tabs:

  1.  Column Lookup
    2. Add New/Insert
    3. Delete
    4.
     Copy/Paste buttons 
    5. Move Up and Down buttons

Subtotals Tab Grid

Into the Data Grid of the Subtotals tab (Fig.), you insert the details (column names) you want the system to use for showing the subtotals of the report data. Checkboxes below the grid allow you to control the data display on the final printout.

Column Name

Contains the name of the selected columns as it appears in the lookup. This name will be used by the system to map the selected column to the source tables.

Detail Description

It contains the name of the subtotals column as it will appear in the column’s header. You can change it manually (see above).

Display Values as…

The system allows you to alternate the selected column value display between Value and Description (or both). For example, if the selected column contains Branch, you have an option to display Branch Code, Branch Description, or both. 

Indentation

In this field, you enter the number of characters to determine the depth of the indentations on the report.

Value Format

In this column, you set up the format for a date or the numerical data display. An arrow button opens the menu of supported formats.                          

Sort Order

The Arrow button menu allows you to alternate between ascending and descending order of data display.

Additional Report Formatting Parameters

The following format parameters for the report can be specified by placing checkmarks into the three boxes below the grid:

 Checkmark here will instruct the system to move the Totals line in front of the breakdown.

 Checkmark here will instruct the system in case of the carryover to place names of the Subtotals fields at the beginning of each page. 

 

Streams Tab

On the Streams tab (Fig.) you can enter values against which to run the report. 

Stream Key Name 

This field of the tab’s data grid displays column names that were defined during the Data Model setup.

Stream Key Value

This field of the data grid is where you enter the Key values. 

Use  button or if there is no lookup available enter key values manually.

 

 

Conditions Tab

The system allows you to narrow down the data in your report to the desired degree by using logical conditions. In the Conditions tab (Fig.) you can stipulate logical conditions for data extraction.

Conditions Tab’s Tool Bar

Logical Conditions tab’s toolbar (Fig.) provides the following functionality:

 Insert Conditions

Pressing this button opens a menu listing available conditions for your selection (refer to the Logical Conditions section of this document). 

Delete Conditions

Pressing this button removes the selected condition from the panel. The warning window will appear.

 Move Up and Down Buttons

The “order of appearance” is irrelevant to the conditions processing. However, when several conditions are used, the Portfolio Definition Panel may get cluttered making the logic difficult to see at a glance. Up and Down buttons are provided to arrange conditions in a specific order that conveys the logic of the data selection commands in the most comprehensive way.

 Copy All, Copy One and Paste Buttons

Copy and paste functions allow you to move conditions to other tasks.

 Validate CheckBox

Mark in this box will prompt the system to check if the values you entered in the conditions actually exist. The system will reject the non-existing values.

If you need to enter a non-existent value i.e. infinite margin of an interval, you must disable this feature.

Please refer to the Logical Conditions section of this manual for the complete instructions on how to set up logical conditions. 

XML Tab

The functionality of this tab is explained in the context of the Electronic Tabular Report Submission below in this document.

Headers/Footers Tab

On this tab (Fig.) you specify the contents and location of the report features.

The working area of the tab is broken into the input fields for every feature of the report:

  1. Header (1st page)
  2. Header (subsequent pages)
  3. Footer
  4. Report Title

Into each input field, you enter information specific to the purpose of the report. 

Each input area, i.e. Header, Footer, etc. is provided with a  button that accesses the menu listing pre-set macros for the command to the system to insert necessary information. You can combine manual data entry with macros to create a comprehensive “cover” for the report.  

You can also adjust the spacing and alignment of the information as it should appear in the report.

Page/Font Setup Tab

On this tab, you can set up visual parameters of the report, such as Fonts and Font size, paper size and page orientation, margins and indents, etc.

Dates for Preview Tab

On this tab (Fig.) you select Model Date for the preview of the report. The grid of the tab lists all models on which the current report is based. 

The Report Date field displays a date of the previously saved preview. Here you can enter any date you want by typing over the default entry.

The Data Grid displays Model Instance combo box’s input field displays Model Instance used in the current report. Arrow button menu lists available Model instances.