Data Warehouse Trending - best practices on scheduling the job and using the data

Products

• Clarity PPM On Premise

Issue/Introduction

We are interested in enabling Data Warehouse Trend Reporting.

In order to be able to display the change of data over time, will we need to create separate trend snapshots instead of updating an existing trend snapshot? If our users want to see how data changes from month to month, would we create a new trend snapshot at the end of each month which captures the data for that specific month? We want to be able to make this data available, but want to ensure that we are setting up our jobs appropriately.

Environment

Release : All Supported Clarity releases

Component : CA PPM DATA WAREHOUSE

Resolution

If you would like a new snapshot taken every month and being able to compare between them then our recommendation would be to schedule the Create Trend job every month. This will create a separate snapshot.

If you would like to update an existing snapshot, you can do that with the Update job, but this will erase the existing trend data. It doesn't seem like this is a good use case for you.

For more information check the documentation here:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-7-1/advanced-reporting-with-jaspersoft/data-warehouse-trend-reporting.html

Also check this KB that explains the jobs parameters:

https://knowledge.broadcom.com/external/article?articleId=111629

The job can be scheduled in many ways, We recommend looking into the data after few runs and see the optimal use for you specifically.