Ideas

New OLAP Cube required for Store replenishment related calculation

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 

  • Product Team
  • Jan 2 2016
  • Unlikely to Implement
  • Attach files
Note : Do not post a lengthy title for an Idea. Post your Idea clearly supported by Screenshots, Examples and Case Studies (if possible).