what is exception aggregation
Answers were Sorted based on User's Feedback
Answer / nimma
The Exception aggregation is used in special scenarios
where we do not want to show the result of key figure as
simply the total of all the values. For example:
Is we are looking at a report which shows the Number of
employees by year for the past 10 years the total field for
the Number of employees shows the total of all the figures
for the past 10 years which is wrong but it should show the
last value i.e the recent years figures becoz the number of
employees is not something to add up.
Here we use the exception aggregation to let the BEx know
how to show/summarise the values, here in this case we use
Last Value...
Some more examples of exception aggregation are Average,
First Value etc...
| Is This Answer Correct ? | 108 Yes | 4 No |
Answer / sudhakar
Exception aggregation can be used to derive additional information out of a limited number of Key Figures provided in the InfoCube that is to be analyzed.
Thereby, you can create Calculated Key Figures by using a formula that uses exception aggregation itself (this is a nested exception aggregation).
Example: Exception Aggregation as "Total" is used to aggregate the result of a key figure with respect to the Reference Characteristic.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / damodar reddy
Exception Aggregation is which specifies how key figure is
compressed using time characterstics
| Is This Answer Correct ? | 2 Yes | 33 No |
Answer / surya
Exception in Reporting is to indicate any deviation from a
threshold value. Say you build a Query for Sales Analysis
for various salesorganisations for a top level manager in
sales, You indicate some threshold values in Netsales Amount
to indicate if it is exceptionally low or high , with
different colors in the report, so that it could be
immediately taken care . The same exception can be reported
with the help of reporting agent , by capturing the
exception and sending the same through Emails to managers.
| Is This Answer Correct ? | 5 Yes | 108 No |
What is the use of infocube in bw system?
What is the use of multi-provider in the sap?
What exactly do you know about the sap bw?
what are the datasources for inventory
HOW TO SUPRESS TEXT DATA WHILE LOADING MASTER DATA? HOW TO LOAD MASTER DATA WITH OUT CREATING INFOPACKAGE?
I am learning SAP BI.i want learn more about Extraction in Bi.can please provide more info about it.what is the use of Extraction in real time.please provide detailed information about it.
What are the versions in objects?
How many LIS structures are created?
What is hierarchy?
Suppose, You are working on a report, how do you know from which INFOCUBE ,report should be generated ?
How to check for standard info Objects, InfoCubes, Ods/DSo,transformations, reports, queries..etc in bi7.0/bw3.5? (Is there any T-Codes to find out)
remodeling is applied only on info cube? why not dso/ods?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)