Question:
Hi All,
I have a situation wherein the data is supplied like this:
Customer, City, Bill Amount, Invoice Amount,
Roger, AU, 100,110
Mike, PR, 200,220
but in the cube I want to store it as account based model...
it should look like this....
Customer, City, KF Type, Amount
Roger, AU, Bill, 100
Roger, AU, invoice, 110
Mike, PR,Bill,200
Mike, PR,invoice,220
My initial plan is to create transfer structure with Keyfigure holder for billing amount and invoice amount. Then the transfer rule will have KY type to indicate wheter it is bill or invoice and then only 1 KF for the two.
In between the structure and rule will be a start routine.
Am I going the right direction? if there is a simppler way of doing this please share...thanks in advance
Cheers
Answer:
Hi,
First, I don't quite understanding why you wanna do like that way since it'll increase the cost of data staging between InfoSource and DataTarget;
From my opinion, it's not suggested except that you met special cases;
Anyway, i have experience sharing with you - add coding into the start routine of update rule to split the data_package to the format you want: one_to_multiple.
Regards, echoes
Answer:
Hi echoes,
Thanks for the reply...that confirms im on the right track just need to call in the ABAPERS...
The reason im doing this is two fold 1 is a special case 2 it will save space in the fact table. One of the advantages of account based modelling
Thanks,
Rhett