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
The following table lists the fields in this table.
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 |
Calendar Source Field, Item Analysis View Table |
United Kingdom Local Functionality |
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 |
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 |
Calendar Source Field, Item Analysis View Table |
United Kingdom Local Functionality |
See Also
Other Resources
How to: View Inventory Analysis Information by Dimensions