Enter an alphanumeric analysis code. This field is mandatory. The field contains a lookup where you can check if your analysis code is in use. This facility helps to avoid duplication when you have many analysis codes.

Enter an analysis code description. This field is mandatory. You can optionally enter descriptions in more than one language. For more information on the Translation Option, see Introduction to QAD Enterprise Applications User Guide.

Specify the report chart code. This field is mandatory, and must contain an existing report chart code. Financial Report Writer retrieves financial data from several source domains to form a common reporting COA. The report chart is composed of a GL account shared set, a sub-account shared set, a cost center shared set, a project shared set, and SAF concepts. It also includes the COA cross-references that translate the COA of the source domains to the report COA. The detailed elements of the report analysis code are based on the selected report COA.

Select a dimension as a controlling dimension. When generating reports, you can generate a report filtered on each value of the controlling dimension, which saves you having to generate each report individually.

The drop-down list for the Controlling Dimension field is populated based on the dimensions you select in the Dimension area of the General tab. For example, if you select fields for the GL, Sub-Account, and Daybook dimensions, these three options are available as controlling COA dimensions.

When running a financial report, you can specify an analysis code with a controlling dimension as a Filter Analysis code to control the bursting. You must also specify Yes in the Report Burst selection field in Financial Report Run. The report run then generates a separate report for each value of the controlling dimension. For example, if the analysis code has a controlling dimension of Entity, the report run generates reports for each entity.

See Financial Report Run.

Specify the type of analysis code. This field is mandatory. There are four types:

If the Analysis Type is set to Analysis, a list of dimensions to include is displayed. If you select a dimension to include, a new tab appears to enable you to enter details for that dimension, as shown in Report Analysis Type: Analysis. A new tab is displayed for each dimension that you select. You can select as many dimensions as you need. The tabs are displayed in the order they logically appear in your chart of accounts.

Each tab enables you to enter details for the dimension. You can enter the source dimensions by range or by value. In the example in Report Analysis Type: Analysis Dimension, you add an analysis code dimension of type GL.

In the By range area, you can enter a GL account in the GL Account Begins field or you can enter a range of accounts in the GL Account Range fields. The advantage of entering a range is that the list of GL accounts in the analysis code dimension is dynamically updated when you add a GL account. You do not need to update the report analysis code dimension. The View GL Accounts button enables you to browse the list of GL accounts in the range. Click the lookup button on the right and use the Ctrl and Shift keys to multi-select the GL accounts in the range. To add the selected list of GL accounts to the dimension, press Enter.

In the example in Report Analysis Type: Analysis Dimension, the GL accounts are entered by value. To enter accounts by value, insert a new row and select a GL account using the lookup browse. You can use the multi-select browse to add multiple GL accounts.

Although this example uses GL accounts, the functionality works the same way for any dimension you select on the General tab.

If you set the Analysis Type field to Calculation, the General tab is displayed with a Calculation Formula field, as displayed Report Analysis Type: Calculation.

This field is only displayed when the analysis code type is Calculate. You can enter two types of calculations:

Summations: If you enter a list of report analysis codes, separated by commas, you can calculate the sum of balances. For example, C01, C02, C05 results in the sum of report analysis codes C01 + C02 + C05. In this type of calculation, you can also subtract. To subtract, place the report analysis code in parentheses. For example, C01, (C02), C05 results in the sum of report analysis codes C01 – C02 + C05.

Multiplications or divisions: You can enter a maximum of three factors separated by * or /. For example, to calculate C01/C02*C05, the system first divides C01 by C02 and then multiplies the result by C05. You can also use constants. For example, to calculate C01/C02*100, the system first divides C01 by C02 and then multiplies the result by 100. This method is useful for percentage calculations.

You cannot combine summations and multiplications or divisions in a single calculation report analysis code. However, you can use the result of a calculation as a component of a calculation in another report analysis code.

You cannot use parentheses in multiplication or division calculations. However, you can circumvent this restriction using cascaded calculations.

Be careful not to create circular references when using cascaded calculations.

C04=C01*C02, C05=C03/C04, and C02=C05/C06 are not allowed in the same report tree. The value of C02 depends on the value of C05 (last calculation) and, similarly, the value of C05 depends indirectly on the value of C02 (the first two calculations). Circular references cause the report run program to abort with an error message.

Specify the name of the taxonomy that applies, and to which the report analysis code belongs. There are multiple XBRL taxonomies, such as IFRS XBRL and US GAAP XBRL. Each taxonomy has specific structures and element naming conventions.

Specify the ELR code that identifies the report structure in the taxonomy. In each taxonomy, subdivisions are used to target reporting subareas with their own relational structure and label structure. These subdivisions are referred to as Extensible Linkbase References (ELRs). An ELR can relate to a single report.

Specify the XML element name tag used in the XBRL taxonomy. For example, each balance row in the IFRS-XBRL taxonomy has a unique XBRL element name as an identifier, such as AssetsAbstract.