Item Dim - Churn Type

Created by Robert Cross, Modified on Wed, 9 Jul, 2025 at 7:52 AM by Robert Cross

Item Dim - Churn Type

This dimension categorizes products based on their sales performance and lifecycle status to help understand changes in product portfolio over time. It identifies whether a product is new, has increased or decreased in sales year-over-year, or has been removed, enabling strategic decision-making about product management and market trends.

Output Column	Database Logic	Description
Item Key	Unique identifier key for each product item within the system.	This is the unique identifier assigned to each product, allowing the business to distinctly track and analyze individual products across reports.
Product Churn Type	Categorization of product based on its sales trend such as 'New Product', 'Existing Product (YOY Increase)', 'Existing Product (YOY Decrease)', or 'Removed Product'.	This field classifies products according to their performance changes, indicating if a product is newly introduced, growing, declining, or discontinued, which supports product portfolio evaluation.
Product Churn Type Order	Assigns a numerical order to churn type categories to prioritize or sort products by their lifecycle or sales performance status.	This numeric ranking helps prioritize products based on their churn classification, with new products ranked highest and removed products ranked lower, facilitating clearer insights into product portfolio dynamics.

Script Logic Details

Item Key: [Level(Item.Item).Item Key]
Product Churn Type: [Level(Item - Churn Type.Item - Churn Type).Churn Type]
Product Churn Type Order: IIF( [Level(Item - Churn Type.Item - Churn Type).Churn Type] = 'New Product' , 1 , IIF( [Level(Item - Churn Type.Item - Churn Type).Churn Type] = 'Existing Product (YOY Increase)' , 2 , IIF( [Level(Item - Churn Type.Item - Churn Type).Churn Type] = 'Existing Product (YOY Decrease)' , 3 , IIF( [Level(Item - Churn Type.Item - Churn Type).Churn Type] = 'Removed Product' , 4 , 5) ) ) )