BW query issue

[Former Member]

hi ,

i am facing a problem in my BW query.

My query is based on a ODS which have 2 key fields(doc no: and doc line no:). i am using a CKF for counting total no:docs, which is a replacement path variable using the doc no: . i am getting the exact count for the doc no:, bt when i drill down the doc line no: the picture changes, for same doc no: there are more than one doc line no:, the counter is showing '1' for all the entries. But the total is calculated for doc no: only

eg;

doc no: doc line no counter

43311 1 1

45511 1 1

46611 1 1

46611 2 1

46611 3 1

-

---

total 3

i dont want to display '1' for double entries.

can anyone give me a solution

[Former Member]

I am not very sure...

Try to use exceptional aggregation based on doc no. wise.

Vivek

[Former Member]

Hello Hari,

You need to change the model and remove the counter field as you can not put the logic on report side to count only 3 instead of fave as in ur case. instead of you should write a routine to count the numbers.

Cheers,

Sanjiv

[Former Member]

see, the total of counter is correct here,

is there any way in reporting side, to compare and make the counter 0 for line no: if the doc num had already counted

[Former Member]

Hi,

As of my knowledge this requirement can't be achived at reporting level. This can be done at modelling level by writing a routine and populate 1 if it is different doc. no., use that infoobject in the report level.

Note: performance will be very slow since it read record by record.

Assign if this helps you.

Cheers,

Malli.