Pipeline Management Calendar and Product Dimensions Dependency

Pipeline Managements uses the following common dimensions for filtering purposes:

• Time / Calendar dimension - ensures the Period filter shows all available past and future periods for which there are opportunities
• Product dimension - ensures that the Product Group filter shows the latest hierarchy

Run the following Analytics Data processes for ongoing maintenance of Pipeline Management:

• Refresh Denormalized Time Dimension Table for BI

  Run this process following updates to the CRM Calendar profile (ZCA_COMMON_CALENDAR) such as defining periods for future years. This ensures that the

• Refresh Denormalized Product Dimension Table for BI

  Run this process following updates to the Sales Catalog such as product group hierarchy changes.

For more information, see Scheduled Processes for Analytics Data.