on 2006 Jan 10 1:02 AM
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
Hi,
Its 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 dont 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
To the best of my knowledge it is better to the calculations and currency conversions at Query level.
Best Regards
Sunil.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.