Skip to Content
0

Key Figure Model

Jun 05, 2017 at 09:30 AM

27

avatar image
Former Member

Source Fields :

Account CompCode FID Currency Amount

AA 10 AB SGD 100

AA 10 AB EUR 200

Target Fields:

Account CompCode FID Curr1 Curr2 Curr1Amt Curr2Amt

AA 10 AB SGD BLANK 100 BLANK

AA 10 AB BLANK EUR BLANK 200

Target is a Write Optimized DSO and Source is a Cube

Issue here is in the Target DSO, I am getting 2 line items for the same characteristic combination as in my Routine I have written if Curency from Cube is SGD then it should go to Curr1 is DSO and if its EUR then it should go to Curr2 but as the code works line by line its creating 2 line items for the same char Key.

Is there a way to align the records so that my Output is like this with only One Line Item:

Account CompCode FID Curr1 Curr2 Curr1Amt Curr2Amt

AA 10 AB SGD EUR 100 200

I have already tried Rule Groups but because of Multiple Key and Amount Fields its not working.Any other suggestions?

Thanks

Aditya

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers