Understanding Exception Aggregation via Examples

WRITTEN BY: supportmymoto.com STAFF

Hiya Everybody, i really feel some of the Advanced/Complicated matter in BEx (SAP BI/BW) is Exception Aggregations. Lets attempt to perceive varied Exception Aggregation accessible in BEx Designer through Examples. (This weblog doesn’t cowl Hierarchy associated Exception Aggregation)

 

State of affairs : Wish to know the qty at Firm Code stage and Firm Code + Materials Group Degree.

 

First we are going to attempt to perceive (With Instance) what’s the primary distinction between commonplace aggregation (Summation) and exception aggregation (Summation).

 

Output for above KF’s :

 

As we will see there’s distinction within the output nonetheless the definition of each the KF are identical. Solely distinction is one is enabled with exception aggregation on Materials Group.

KF with Commonplace Aggregation works on particular person row line. (Denoted with Orange strains)
For instance : AR firm code satisfies the 500K expression Therefore the output 1.

Exception Aggregation works with a Ref CHARACTERISTIC (Materials Group) on which the calculation might be carried out.
KF with Exception Aggregation present the worth 7 (Inexperienced Boxed Worth) i.e 7 Materials teams in firm code AR satisfies 500K expression.Mainly, the calculation is finished by conserving the Ref CHARACTERISTIC in Drill down however the output is proven with out the ref attribute within the structure.

Lets examine the under screenshot for a similar.

When you drill down on the Materials Group, we will observe out of 9 Materials Teams 7 satisfies the 500K Expression.

Now simply maintain solely Materials Group within the drill all the way down to get the Complete worth at total Firm Code stage (Blue Boxed Worth).

See also  Samsung Galaxy Buds/Buds+/Live/Pro randomly dead? Here's how to fix them

Notice : the worth for Materials Group is modified as worth from all the corporate code are summed up.

The conduct is analogous for under talked about Exception Aggregation (Kindly observe above understanding for under screenshots in sequential method)

  1. Max (Exception Aggregation “Most” With Ref Char on Materials Group)
  2. Min (Exception Aggregation “Minimal” With Ref Char on Materials Group)
  3. >1 R (Exception Aggregation “Exception If greater than One Document Happens” With Ref Char on Materials Group)
  4. >1 V (Exception Aggregation “Exception If greater than One Worth Happens” With Ref Char on Materials Group)
  5. >1 V <>0 (Exception Aggregation “Exception If greater than One Worth <>0 Happens” With Ref Char on Materials Group)
  6. Avg (Exception Aggregation “Common” With Ref Char on Materials Group)
  7. Avg <>0 (Exception Aggregation “Common of Detailed Values Which can be Not Zero, Null or Error ” With Ref Char on Materials Group)
  8. Counter (Exception Aggregation “Counter for All Detailed Values” With Ref Char on Materials Group)
  9. Counter <>0 (Exception Aggregation “Counter for All Detailed Values Which can be Not Zero, Null or Error ” With Ref Char on Materials Group)
  10. 1st Worth (Exception Aggregation “First Worth” With Ref Char on Materials Group)
  11. Final Worth (Exception Aggregation “Final Worth” With Ref Char on Materials Group)
  12. Std Dev (Exception Aggregation “Commonplace Deviation” With Ref Char on Materials Group)
  13. Variance (Exception Aggregation “Variance” With Ref Char on Materials Group)

Output at Firm Code :

Output at Firm Code and Materials Group :

Output at Materials Group :

 

The Above conduct just isn’t adopted by “Common Weighted With Calendar Days” and “Common Weighted With Working Days” Exception Aggregation.

See also  Is Birch Good for Firewood? White Birch Firewood Vs Black Birch Firewood

For Exception Aggregation to work on “Common Weighted With Calendar Days” and “Common Weighted With Working Days” requires a Non-Cumulative KF with reference char as 0CALDAY.

Under is the instance for “Common Weighted With Calendar Days” and “Common Weighted With Working Days” :

Drilling Down on Calday will clarify how the output is calculated :

 

 

Calculation Logic : The Quantity or Amount saved every day divided by no of days.

For Common Weighted With Calendar Days : 475000/31 = 15323.

For Common Weighted With Working Day : 350000/22 = 15909.

Notice : For Working Day, think about the Quantity/Amount just for working day (Weekdays).

 

Thank You.

 

 

NOTE : Please do not copy - https://supportmymoto.com

Leave a Reply