Field routine in the transformation

[moha_nan]

Hi Gurus,

I am a new BI user and trying to write a field routine for the field "Counter" in the transformation from one DSO1 to another DSO2 (or in transformation from DataSource in DSO1). The field “Counter” is defined only in the target DSO and is not filled from source. The initial value of counter should be 1 and increases by 1 for each new record for the Key Purchasing no., Purchasing Item and Number. Purchasing no. and purchasing Item are always same where the Number should be sorted in ascending order. see example Input

There are many purchasing no., Purchasing Item in the PSA or in DSO1. So the field Counter should be filled in the same way.

Input:

Purchasing no. | Purchasing Item | Number

1111 | 10 | 1

1111 | 10 | 6

1111 | 10 | 5

Output:

Purchasing no. | Purchasing Item | Number | Counter

1111 | 10 | 1 | 1

1111 | 10 | 5 | 2

1111 | 10 | 6 | 3

Thank you

[moha_nan]

Hello Joerg,

There are other fields which should be derived in the formular of the transformation in connection with the field Counter (1,2,3..). So I need the field "Counter" in the transformation only not in the query.

Regards,

Moha

[former_member242986]

HI Moha,

what is the reason for the Counter? do you want Count the purchase items in the reporting, then just add a keyfigure with the constant value 1.

Or would you like to count the changes? Currently I don't understand the requirements.

Please give more Information.

regards

Jörg

[moha_nan]

Hello Jörg,

There are other fields which should be derived in the formular of the transformation in connection with the field Counter (1,2,3..). So I need the field "Counter" in the transformation only not in the query.

Moha