Hi experts,
Hoping someone can help me. I'm trying to achieve to things at once.
I have 2 cubes:
1 -> Weekly Sales cube from Another system
2 -> Periodic Sales cube from SAP
Both cubes report sales but Cube 1 is from another system so the key figures values are different.
I want to load the data of Cube 2 which we will take as bible into cube 1 or another Cube, disaggregating the Periodic data into weeks. However, I need to apportion or distribute the periodic data into weeks, based on the existing sales key figure values per week per account per store, as opposed to a simple even distribution.
E.g.
Cube 1
Week 1 = $20
Week 2 = $30
Week 3 = $30
Week 4 = $20
Cube 2
Period 1 = $150
Result should be after disaggregation / distribution / shaping
Cube 3
Week 1 = $30
Week 2 = $45
Week 3 = $45
Week 4 = $30
Overall result equals the period result but it has been properly distributed between weeks.
Any ideas on how to achieve this? I need to somehow access fact table data. We are on Netweaver 7.0 so we have access to BI IP if that is necessary.
Thanks in advance for any advice!