|
|
|
|
This page allows you to define the column structure of a report. Tell me more.
Select the “Maintain Column Structure” link present under the “Analysis Tool “ business component.
The “Maintain Column Structure” page appears.
Enter the following fields:
|
Column Structure ID. |
The number identifying the column structure based on which an analysis report is generated (Alphanumeric, 10). Mandatory. |
|
|
|
|
Desc. |
The description pertaining to the column structure (Alphanumeric, 40). Mandatory. |
The system displays the following in the “Column Definition” multiline:
|
Column ID. |
The number identifying a particular column of the column structure. |
Note: The system automatically generates the Column IDs from ‘A’ to ‘O’ in the multiline.
Enter the following fields in the “Column Definition” multiline:
Note: The number of rows of the multiline must not exceed 15.
|
Column Name |
The name or the heading of the column (Alphanumeric, 40). Mandatory. |
Note: The value entered here must not have any special characters other than ‘>’ and ‘<’.
|
Column Type |
Use the drop-down list box to select the type of the column. You can select from “Data” or “Column”. The system displays the first value by default on launch of the page. |
Note: The column of the report may just display data or can contain a formula relating some of the other columns of the same report.
|
Formula |
The formula based on which computed data is displayed in the column (Alphanumeric, 30). |
Note: You can enter values in this field only if the “Column Type” has been set to “Formula”.
Formula Correctness
The following things must be taken care while entering the formula:
The formula must not have any special characters other than ‘+’, ‘-‘, ‘*’, ‘/’ and ‘%’.
The formula must not start with a special character other than "(" and ")".
Other than the specified special character it can have only the following characters from "a" to "o" or "az","bz","cz","dz"....."oz". (The values “az”,”bz”…”oz” denote the summations of the respective columns).
The formula must not have two or more continuous special characters.
Also, every open parenthesis "(" must have a corresponding close parenthesis ")".
|
Qty. / Value |
Use the drop-down list box to specify whether quantity or value is displayed in the column. You can select from “Qty.” or “Value. The system displays the first value by default on launch of the page. |
|
Actual / Budget |
Use the drop-down list box to specify whether actual or budgeted value is displayed in the column. You can select from “Actual” or “Budget”. The system displays the first value by default on launch of the page. |
|
Column Total |
Use the drop-down list box to specify whether column total must be displayed at the bottom of the column. You can select from “Yes” or “No”. The system displays the first value by default on launch of the page. |
|
|
Use the drop-down list box to specify whether the columns can be printed. You can select from “Yes” or “No”. The system displays the first value by default on launch of the page. |
|
Print Seq. No. |
The number identifying the order in which the columns of the structure are to be printed in the report (Alphanumeric, 6). The system defaults the print sequence with 0, 1, 2….15. |
Note: This field must be left blank if the “Print” field has been set to “No”.
Click the “Update Column Structure” pushbutton to update the column structure.
The system saves the column structure.
The system displays the following:
|
Created By |
The login ID of the user who created the column structure. |
|
Created Date |
The date on which the column structure has been created. |
|
Last Modified By |
The login ID of the user who modified the column structure last. |
|
Last Modified Date |
The date on which the column structure has been modified last. |
To proceed, carry out the following
Select the “Analysis Report” link at the bottom of the page to generate the analysis report.
Maintaining column structure – An overview
Column structure comprises of the details like: the number of columns present in the report, the type of column (whether the column simply displays retrieved data or information computed based on a formula), whether the column displays value or quantity, whether the displayed data is budgeted or actual etc.
You can enter a unique number identifying the column structure and also a description of the same. Details pertaining to each of the columns must be specified in the multiline. The system displays column IDs from ‘A’ to ‘O’ in the multiline. For each of the columns, you can specify the column name, column type, formula, specification of whether the column data is quantity/value and actual/budget, whether column total must be printed at the bottom of the column and the sequence or order in which the columns must be printed.
If the column structure is created the first time then the system saves the data. If the structure has already been created, then the system updates the modifications.