Hi,
I have 2 cubes: MAIN & REP
MAIN contains my Trial Balance
In REP, I want to upload data to report on units sold & GP per unit per salesperson
- REP will need a new dimension [Salesperson] that does not exist in MAIN
- [Account] in REP will be significantly smaller than [Account] in MAIN. I expect 6 accounts (3 for Units sold, 3 for GP)
My question is: can I upload data using Data Management to REP (or do I have to upload to MAIN then use Data Maps to move it to REP)? If so, can someone direct me to a resource? I can't work out how to change the destination from MAIN to REP.
TIA