Skip to Content
0
Former Member
May 09, 2008 at 07:00 AM

Modelling with InfoSet / MultiCube

15 Views

Hi you experts,

now here is a real challenge for you. Imagine, there is no heaven, only following BI Data:

FI

0FIAR_C03 (0DEBITOR,0COMP_CODE) with "current account value"

100500 ...... 100.000,-

SD

ZSDINVOICE (0CUSTOMER, 0CUST_SALES, 0COMP_CODE, 0DIVISION) with "yearly revenue"

100500 ...... 35.000,-

100501 ...... 30.000,-

100502 ...... 12.000,-

...

And now the task.

in FI there is ONE CustomerNr.(100500) which is paying for himself and for another Customers as well, so therefore in FI there is e.g. 100500 as Customer and this should be set in relation with SD Invoice Data of customers 100500, 100501, 100502

How can I solve this task?

Does anybody have any idea? MultiCube, InfoSet, Hierarchie??

Thank you very much

Standa