Document counter restricted with characteristic values

[Aummad]

Hi

I have a requirement,

characteristic name: ABC

value of characteristic: Add, duplicate, Edit so on.

data in BW

doc number  line item   abc

001                      1              ADD

001                     2              ADD

001                      3              duplicate

002                      1              Add

003                      1              Add

004                      1              Edit

they want to uniquely count total doc number, doc number with respect to abc values end result looks like this

Abc              Count    % 

Add                  3         3/4 *100

duplicate         1         1/4*100

Edit                   1         1/4*100

I created counter using exceptional aggregation detail value <>0 and ref characteristic is doc. number.

I am getting right total count "4" but when i add ABC characteristic and the number of count is different  like "ADD"  = 8. its look like it is also counting line item too.

please help me to fix this.

Thanks,

[former_member206568]

You can do it by creating a formula variable counter on characteristic ABC and then RKFs on the specific values you want to count. See the following thread for details

Thanks

[Aummad]

Any comments please

[former_member200967]

Hi Asif,

The exception aggregation has no effect when the reference characteristic is in the drilldown. When you do exception agg with Order Number as the ref, and also keep Order Number in the drilldown, the exception agg is ignored except in the "Result" total rows.

EDIT: Please check this thread too BEx Exception Aggregation | SCN

Regards,

Manpreet

Message was edited by: Manpreet Singh