Setting Up Analysis Line Templates

In an analysis report your analysis objects are shown on the lines. You can define the lines that you want to include in your analysis report by setting up analysis line templates. A template contains a set of lines representing the analysis lines that you see in the analysis report. A line can specify one or a range of items, customers, vendors or groups. You can also create a formula in a line to sum up the other lines. You can set up as many line templates as you like, and then use them to create new analysis reports.

To Set Up Analysis Line Templates:

  1. Open the Analysis Line Template window.

  2. Click the first empty line, and in the Name field, enter the name you want to give your new analysis line template. In the Description field, enter a description.

  3. Click Lines and in the Analysis Lines window create lines for the items, customers, vendors or salespeople you want to view figures for in your analysis report.

Note

You must fill in the Type field, the Range field, and the Description field.

Alternatively, when you want to create many individual lines for each item, customer and so on, you can click Functions and select the appropriate insert option and the program fills in all the relevant fields on the line.  If you need to, you can then edit the lines manually.

  1. For Help about a specific field, click the field and press F1. Press Esc to close the windows.

Note

In order to set up item/customer groups and salespeople, you must first set them up as dimensions and create an analysis view. You must then specify an item analysis view code for the analysis line template in which you want to include groups as analysis lines. The analysis report will be based on analysis view entries.

Related Topics

Setting Up Analysis Column Templates

Creating New Inventory Analysis Reports

Setting Up Analysis Types

Setting Up Inventory Analysis Views

Filling in the Type field

Filling in the Range field



© 2009 Microsoft Corporation. All rights reserved.