using derivation tables in derivation?

Hi,

in our BW project we extract data of accounting based CO-PA. Now we need to map various cost elements to the different key figures for reporting - e.g. all sales revenues cost elements to one key figure "revenues" and so on...

Using formulas would be a huge implentation effort. This is why we think about using a separate derivation table.

Does anyone have experience using derivation tables in transformations?

We also thought about using hierarchy nodes. Does anyone know how to map the values of the single cost elements to the hierarchy nodes?

Thanks for help!