Compartir a través de


Item Analysis View Table

Specifies how you want to analyze the dimension information that you have posted for item entries, budgets, and so on.

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. 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.

Important

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.

List of Fields in the Table

Field Location
Calendar Source Field, Item Analysis View Table United Kingdom Local Functionality
Code Field, Item Analysis View Table Inventory
Last Entry No. Field, Item Analysis View Table Inventory
Last Budget Entry No. Field, Item Analysis View Table Inventory
Starting Date Field, Item Analysis View Table Inventory
Dimension 3 Code Field, Item Analysis View Table Inventory
Include Budgets Field, Item Analysis View Table Inventory
Analysis Area Field, Item Analysis View Table Inventory
Date Compression Field, Item Analysis View Table Inventory
Location Filter Field, Item Analysis View Table Inventory
Update on Posting Field, Item Analysis View Table Inventory
Dimension 2 Code Field, Item Analysis View Table Inventory
Blocked Field, Item Analysis View Table Inventory
Item Filter Field, Item Analysis View Table Inventory
Last Date Updated Field, Item Analysis View Table Inventory
Refresh When Unblocked Field, Item Analysis View Table Inventory
Dimension 1 Code Field, Item Analysis View Table Inventory
Name Field, Item Analysis View Table Inventory

See Also

Other Resources

How to: View Inventory Analysis Information by Dimensions