Calculated Columns

[Former Member]

Hi Frzz,

I have created a graphical calculation view, in which i have to create a Calculated column.

I can create Calculated Column at low level projection layer  OR on top level projection layer. My question is which one gives better performance??

FYI, In betwenn top level projection and bottom level projection i have created multiple joins.

Thank you.

Best Regards,

Krishna.

[Former Member]

Krishna,

That answer entirely depends on different scenarios....for e.g.

Let's say you want to calculate a column:-

• Net Price % which is equal to (Price at individual item / Total Price) -  In this case you have to calculation at lower level to get desired result.
• Total Revenue at Company Code Level = Net Price * Quantity

For above calculation i can do calculation once my data records are aggregated at company code level i.e. at upper projections after some joins or aggregations...

Second option will perform much faster......

What i a trying to say here is it is always good to do calculations on your aggregated data whenever possible as the calculation will happen for less records as comparison to millions of records at lower level. So, you always need to think which options to choose according to different scenarios....

Regards,

Kulwinder