calculation -- transfer rules / updates rules / query ?

[Former Member]

Hello BW Experts,

Which is the best place to do the calculations for key figure. Tranfer rules / update rules / query ?

Any suggestions appreciated.

Thanks,

BWer

[Former Member · Accepted solution]

Hi,

It’s always a trade-off between a poor query performance (in case of calculation on query level) and bigger DB space for infoproviders (in case of calculating in TRs or URs).

So, you need to choose what is preferable for you. And don’t forget that not all calculations is possible to make on a query level.

About calculations in TRs or URs - as Vijay said, you may do it in TRs (if you have several data targets with URs – one place to maintain rules) or in URs (if your data targets have (or have not at all) different logic in calculations.

Usualy they say that business logic transformation is better to make in URs.

Best regards,

Eugene

[Former Member]

Hi!

To the best of my knowledge it is better to the calculations and currency conversions at Query level.

Best Regards

Sunil.

[Former Member]

Hi BWer,

It all depends on your application.

Normaly you want to get in/out of the source systems as quickly a possible. hence you normally avoid processing in transfer rule.

But if you have more than one data target why process data in each update rule instead maintain it once in transfer rules.

If you can avoid calculations in query the performance of your queries will be better.

Vijay.