You can use the Analysis by Dimensions matrix to view the amounts in your general ledger using the analysis views that you have already set up. You fill in the Analysis by Dimensions window to define what will be shown in the matrix, and then you choose Show Matrix to view the matrix.

The columns in the matrix also display the following information.

Column Description

Code

Shows the code given to a dimension value.

Name

Shows the name given to a dimension value.

Total Amount

Shows the total amount for the amount type that you chose in the Show field on the Options tab.

Matrix

The remaining columns show amounts based on an analysis view.

To view an analysis by dimensions

  1. In the Search box, enter Analysis by Dimensions, and then choose the related link.

  2. Select the relevant analysis view. On the Home tab, in the Process group, choose Edit Analysis View.

  3. On each FastTab, fill in the fields. For more information about a specific field, select the field, and then press F1.

  4. On the Actions tab, choose Show Matrix.

  5. To see a specification of an amount shown in the matrix window, choose the amount.

Important
You cannot select a period length shorter than the period specified for the date compression on the Analysis View card.

The Next Set and Previous Set commands are inactive if you have selected Period in either the Show as Lines or Show as Columns field.

Note
You can use the Dimensions - Detail report to display a detailed classification of how dimensions have been used on entries over a selected period. You can use the Dimensions - Total report to display only the total amounts.

Tip
The Option FastTab gives you many different choices to view the amounts according to your needs.

You can also change the view by changing the contents of the Show as Lines field and Show as Columns field.

To reverse lines and columns, on the Navigate tab, choose Reverse Lines and Columns.

Tip

See Also