1) short term
1) CS price optimization scope
In the forecast fact tables, there will be missing attributes that are available either in dimension tables or the historical sales fact table (P&L). List below:
To discuss, what
Q4:
| Attributes | Short term action (Q4) | Mid term/Long term | Dimension table in data like | Link with Historical sales fact table | Link with Forecast fact table | Availability in COPC07 | Availability in COPA03 | |
|---|---|---|---|---|---|---|---|---|
| Group of activity | Keep the design as it is | Unique at CPC | V_DIM_activity1 | GBU_Key | GBU_Key | Yes | Yes | |
| Country | Keep the design as it is | V_DIM_Customer | Customer ship to/sold to _Key | Customer ship to/sold to _Key | yes | Yes | ||
| GBU region | Add as an attribute in the forecast fact table | Unique per GBU and customer | Available | Not available | no (transformation rules on Zone attribute available in the query) | no (transformation rules on Zone attribute available in the query) | ||
| GBU customer segment | To add in the CPC table: (DIM_customer_material_rel) Add as an attribute in the CPC table and source it from salesforce CORE or BW Cube (not query) to the | Unique per GBU and customer | Available | Not available | No | Yes | ||
| Product brand name | CPC latest sales order Product brand name at ship to & material combination from copa03 | Unique per combination of GBU and product/material | Available | Not available | No | Yes | ||
| End use | CPC dimension latest sales order end use at ship to & material combination from copa03 | Unique per combination of customer ship to and material | V_DIM_gbr_enduse | Available | Not available | No | Yes | |
| GBU product family | CPC dimension latest sales order end use at ship to & material combination from copa03 | Unique per combination of GBU and product/material | Available | Not available | No | Yes (transformation applies) | ||
| Enterprise segment | latest sales order line item end use at ship to & material combination from copa03 | Available | Not available | No | Yes | |||
| Market | One market has multiple end use | V_DIM_gbr_enduse | End_use_key | Not available | ||||
| Ship to KA/Final consignee | Available | Not available |