Inicio del área de contenido

Documentación de objeto Report using a Form Localizar documento en árbol de navegación

Report using a single-axis Form without Key Figures

In a single-axis form without key figures, characteristics are only selected in the columns. Using a formula, it is possible to define additional characteristics in the form (such as the variance as a difference between plan and actual). The characteristics selected in the form (such as plan/actual, plan/actual variance) determine which data is shown in the columns.

You choose the key figures and drilldown characteristics (that is, the characteristics whose values you want to choose to navigate through the report) during definition of the report. In the example below, the characteristics branch and region are selected, together with the key figures revenue and contribution margin 1.

The drilldown list contains a two-row column title. The first row contains the key figures (such as revenue) while the second row contains the selected characteristics (plan, actual, variance). The rows contain the values of the drilldown characteristics (here Illinois and New Jersey).

In the detail list, the columns contain the characteristics selected for the form, while the rows contain the key figures. The detail list shows the result for an object for which a search has been carried out (in this case, Illinois).

Example: Report using a single-axis form without key figures

Este gráfico es explicado en el texto respectivo

Report using a single-axis form with key figures

Here, the key figures (such as revenue, percentage of total) which appear in the rows within the form are determined. When defining the report, you choose the drilldown characteristics (e.g. branch, region).

In the drilldown list, the columns contains key figures, while the rows contain the values of the drilldown characteristics (here Illinois and New Jersey).

The detail list has only one column and contains the selected object (here Illinois) which you want to report on, while the rows contain the key figures.

Example: Report using a single-axis Form with Key

FiguresEste gráfico es explicado en el texto respectivo

Nota

Note that you set the detail list when defining a form. This means that the position of the elements set in the form reflects those in the detail list.

For this reason, which a single-axis form with key figures, the key figures are set in the rows. This is in contrast to the single-axis form without key figures, where the characteristics selected in the form are set in the columns.

Report using a two-axis Form with Key Figures

In the two-axis form with key figures, both the rows and the columns are defines with key figures or characteristics. These key figures can appear either in the rows or in the columns. If you choose to have the key figures in the rows, the characteristics appear in the columns.

When defining the report, you choose the drilldown characteristics as with other types of report.

Example: Report using a two-axis Form with Key Figures

Este gráfico es explicado en el texto respectivo

In the graphic shown here, the columns in the drilldown list contain two rows. The first row contains the key figures (sales quantity, revenue, contribution margin I), while the second row contains the selected characteristics (quarter). The rows contain the values of the drilldown characteristics (Illinois and New Jersey).

In the detail list, the columns contain the characteristics selected for the form, while the rows contain the key figures. The detail list reports on a chosen object (in this case, Illinois).

For details of how to create a form, see Overview: Form.

 

 

Fin del área de contenido