The Site Products table's auto-generate feature leverages data from previously created tables—such as Sites, Products, and Periods—to automatically populate key columns like Site, Product, and Period. This reuse of existing structured data streamlines the definition of valid site-product combinations, significantly reducing manual input, minimizing errors, and ensuring consistency across the model. By drawing on these pre-defined inputs, the system accelerates setup and maintains alignment across related tables, making it easier to scale and maintain accuracy in complex planning scenarios.
All Combinations: Selecting "All Combinations" will automatically generate every possible combination of sites and products based on the data in the Sites and Products tables, ensuring full coverage without manual setup.
Specific Combinations: Choosing "Specific Combinations" allows you to selectively generate only the relevant site-product pairs, giving you greater control and precision in defining valid combinations for your scenario.