trending configuration failed

Products

• Clarity PPM SaaS

Issue/Introduction

we tried to configure Monthly trending in Clarity and the job failed. I was able to create a snapshot Trend Type = All Trend Tables, Trend Period = "All Period" 

1. I tried to use  Trend Type = Monthly Trend Tables, Trend Period = "Current Period" with or without 2021 and it always failed 

2. Can you verify my understanding? I want to monitor the monthly trend of the investment custom attribute (number). I expected to

a. "create" a new trend  Trend Type = Monthly Trend Tables, Trend Period = "Current Period" by the "Create Data Warehouse Trend" Job

b. "update" the trend every month by "Update Data Warehouse Trend" Job

c. Should I see the information in DWH_TRD_INV_INVESTMENT? There is no monthly period column. (I don't see my custom attribute in DWH_TRD_INV_MONTH_FACTS)

 

Environment

Release : 15.9.3

Component : CLARITY DATA WAREHOUSE

Resolution

The job failure when trend period is set as Current Period, is a defect DE62523

1. There are a total of 24 Trend Tables, you can check the tables under dwh_trd_meta_table on DWH. Out of these 2 are FISCAL, 2 are MONTHLY, 1 is SUMMARY table. The other are tables that are populated irrespective of the Trend Type parameter. When you select "Summary Trend Tables" all tables are populated except for FISCAL and MONTHLY tables. When you select "Monthly Trend Tables" all tables are populated except for SUMMARY AND FISCAL tables. When you select "FISCAL Trend Tables" all are populated except for SUMMARY and MONTHLY tables.

2. Coming back to Trend Period. This affects the amount of data that is inserted into FISCAL and MONTHLY trend tables. If you select "All Periods" data pertaining to all months of the selected fiscal year is populated into FISCAL and MONTH trend tables. Similarly if you select Current, data is for current month. Previous is for previous month, and next is for next month.

For your use case of trending a custom attribute changes, you can track it monthly by running the job each month using the current period/all periods parameter. This doesn't impact the amount of data that is inserted into tables with TREND TYPE as "ALL" in dwh_trd_meta_table.

Note :- The DWH job should complete prior to running the create trend job as data is referenced from DWH and inserted into trend tables.