Item Analysis View Table

List of Fields in the Table

The primary purpose of using dimensions on item entries, budgets, and so on is that at a later date you can analyze the dimension information you have posted. By using item 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 three dimensions, as well as specify criteria for items, dates and locations. On the item analysis view card, you can also set filters on dimensions not included in the analysis view, by clicking Analysis, Filters. 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 clicking Update on the analysis view card or by using the Update Analysis View batch job. The program will then gather only item ledger entries that fulfill the dimensions criteria and other filters set by you.

 

This dimension information can be viewed and analyzed in the Invt. Analysis by Dimensions window, where you can see a matrix window with axes that you have defined. 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 click Update on the analysis view card or use the 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.