Need to create a Cube named as Replenishment Cube for Managed SItes with the following columns and parameters:
Cube - 1 (Managed Site)
- Cube shall take input for Date Range for Sales data
- Cube shall take input for As on for Stock , PO , SO, STO and other Information.
- Column to be included in Cube as per selected Sites
- POS Sales
- Site Stock Qty
- PO Pending Qty for that Site
- SO Pending Qty in that Site
- STO Pending Qty for that Site
- Pending Package for Organization Site
- All WH Stock Qty for Organization Site against W Location Type
Cube - 2 (Organization Site)
- Cube shall take input for Date Range for Sales data
- Cube shall take input for As on for Stock , PO , SO, STO and other Information.
- Column to be included in Cube as per selected Sites
- POS Sales all Sites
- Site Stock Qty al Sites - Managed Sites
- PO Pending Qty all Sites
- SO Pending Qty all Sites
- STO Pending Qty all Sites
- Pending Package for Organization Site
- Selected Organization Sites Stock