Large number of Cost Plans makes Incremental DWH take a long time to complete

Products

• Clarity PPM SaaS

Issue/Introduction

Large number of Cost Plans makes Incremental DWH take a long time to complete

Steps to Reproduce:
1- A database with many cost plans 
2- Configure System Options - DWH
 Include Weekly Period Data                     - checked
 Include Monthly Period Data                 - checked
 Include Fiscal Period Data                     - checked
 Consistent Fiscal Periods Across Entities     - unchecked
 Include Only Financial Plan of Record         - unchecked
3- Implement solution from https://knowledge.broadcom.com/external/article?articleId=219974
4- Run Update Financial Plan Actuals after Toggle from Step 3 is set

 

Expected Results: Incremental Load DWH completed in 15-30 minutes

 

Actual Results: Incremental Load DWH takes over an hour to complete

 

Workaround: 
Run the full load which takes less time

Environment

Release : 16.0.3, 16.1

Resolution

This is being pursued at Broadcom under DE67864