Skip to Content
0

Field routine in the transformation

May 14 at 12:36 PM

45

avatar image

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

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

2 Answers

Jörg Waldenmayer May 14 at 12:51 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Moha Nan May 14 at 01:06 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded