on 09-16-2016 10:05 AM
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any comments please
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.