Performance impact when one CKF is used in another CKF

[Former Member]

Hi Experts!

I would like to know if there was a potentiel performance impact if a calculated key figure (CKF1) is used in another calculated key figure (CKF2) while designing queries.

In other words, which scenario is better for performance and why?

Example: CKF1 = KF1+KF2

CKF2 = KF1KF2KF3

Scenario A: CKF2 = CKF1+KF3

Scenario B: CKF2 = KF1KF2KF3

Thanks

Deepthi

[Former Member]

When you already have CKF1 with you, its better to use it. So, A is better thatn B.

But when you dont have CKF1 already calculated, then use B.

Thanks..

Shambhu

[Former Member]

Hi Deepthi Reddy,

I prefer to go for senerio B, insted of A. As Senerio A is depend on CKF1, until unless you get the value for CKF1, you will not get the CKF2 in Senerio A.

I hope you understood.

Regards,

S P.

[Former Member]

Hi Deepti,

In the current Scenario mentioned by you, as the calculations are not that big so it doest not make much difference in the performance.

Performance depends on the complexity of the query and calculation, and how we design the query's.

Thanks

Dipika

[Former Member]

It depends on how complex the calculation is.

Simply put if you already have a calculated keyfigure then it makes to sense to use it.

If you are using the CFK in multiple CFK's it is useful to create it.

For simple additions you do not need to think too much about performance issues but complex calculations might help again if you use it repeatedly.