Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Difference B/w Aggregation and Projection in SAP HANA

Hi experts i was trying to learn and know the difference between Aggregation and Projection in SAP HANA studio while creating Calculation view.

Am new to this subject and would like to know when we use those palettes. If any good related links please do post the reply.

Appreciate your response.

Thanks in advance..

regards,

vijay kumar vanamala

Tags:
Former Member
Former Member replied

Hi Vijay,

On a higher level, both Projection and Aggregation do the same thing i.e. Reduce the amount of data transferred to the next level.

You should use Projection when number of records generated by an analytic view can be reduced by grouping and applying a filter.

You should use Aggregation when you are dealing with Raw tables and calculated measures in the calculation view. Aggregation will perform any of theses actions MIN | MAX | COUNT | SUM | AVG ([DISTINCT] .

Best Regards,

Chandan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question