Analysis View Table

List of Fields in the Table

The primary purpose of using dimensions on G/L entries, budgets and so on is that at a later date you can analyze the dimension information you have posted. By using analysis views, you can retrieve information about dimensions according to the criteria you set. You can then investigate trends and analyze relationships based on the dimension information that you have posted.

For each analysis view, you can specify up to four dimensions, as well as specify criteria for G/L accounts, dates and business units. You can also set filters on dimensions not included in the analysis view, by clicking Analysis, Filters on the analysis view card. Different analysis views can therefore be created for different purposes. For example, you can have an analysis view relating to sales in a particular area for a particular time period. When you create an analysis view you must update it using the Update button on the analysis view card or by using the Update Analysis View batch job. The program will then gather only G/L entries that fulfill the dimensions criteria and other filters set by you.

This dimension information can be viewed and analyzed in the Analysis by Dimensions window, where you can see a matrix window with axes defined by you. By redefining the axes and using filters, you can create a highly specific breakdown of how dimensions have been posted and what relationships exist between dimensions.

Attention:

If you have not placed a check mark in the Update on Posting field, you must use the Update button or Update Analysis View batch job to ensure that an analysis view has been updated with the most recent posted entries.



© 2009 Microsoft Corporation. All rights reserved.