Skip to Content
0
Former Member
Dec 01, 2009 at 10:05 PM

Distribution / Disaggregation By Time and Key Figure

34 Views

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!