# Create Trend Job: Explanation of Parameters

**Document ID :**KB000111629

**Last Modified Date :**20/08/2018

Question:

What do the various parameters available on the "Create Data Warehouse Trend" job mean?

Environment:

CA PPM 15.3 and above.

Answer:

There are four parameters available, and explanations for each of them, is as below:

1. Trend Type:

2. Trend Period

3. Trend Year

4. Trend Name

1. Trend Type:

- All Trend Tables: Processes all the trending dimension and fact tables
- Summary Trend Tables: Processes all the dimension tables and the summary fact tables
- Monthly Trend Tables: Processes all the dimension tables and the monthly fact tables
- Fiscal Trend Tables: Processes all the dimension tables and the fiscal fact tables

2. Trend Period

- All Periods: Processes all periods for the current year. For a summary fact table, it simply stores the summary record (Same for all 4 options). For monthly facts, there are 12 fact records stored, 1 for each period in the current year
- Previous Period: Creates the trend and stores the data in the previous period. Example: If today is Sept 1, there would be 1 period worth of data for monthly that would be stored for August
- Current Period: Creates the trend and stores the data in the current period. Example: If today is Sept 1, there would be 1 period worth of data for monthly that would be stored for September
- Next Period: Creates the trend and stores the data in the next period. Example: If today is Sept 1, there would be 1 period worth of data for monthly that would be stored for October

3. Trend Year

- Determines what year to run the trend for
- If left blank, defaults to the current year
- If the Trend Period is set to Previous Period, Current Period, or Next Period, then the Trend Year is overwritten

4. Trend Name

- The Trend Name can be manually entered if the user wants a more descriptive name
- If left blank and the Trend Type is set to All Trend Tables or Summary Trend Tables, then the name defaults to the current date:hidden ID. Example: 2017-01-15:5000000
- If left blank and the Trend Type is set to Monthly Trend Tables or Fiscal Trend Tables, then the name defaults to the 1st day of the period:hidden ID. Example: 2017-01-01:5000000