What is standard and exception aggregation?

Answer Posted / dhinnesh

Standard aggregation is normal aggregation .

Exception aggregation is aggregating w.r.t another characteristic or date .

for eg ; exception agg. max or min . this gives the result of max /min value of the result having common key combinations

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you give a list of standard web items delivered?

1721


What is delete table before extraction option?

1376


Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)

1513


Tell something you know about the dimension in the warehouse and how it can be optimized?

510


Which of the tables are inside and outside cube in an extended star schema?

515






What is automatic loading of similar/identical requests option?

1539


What is the index?

513


Differentiate between v1, v2, v3 jobs in extraction.

521


How do you convert web objects from 2.x to 3.x?

1529


How do you add an entry in the monitor log from the update rules?

1534


Do you have any idea how to improve the performance of the bw?

544


How New TSH Hierarchy top node TSH_SITE to be loaded into BI/BW.??

1149


What are the monitor settings?

1551


What are the server related tuning?

1459


What is a structure?

1534