Question:
HI all,
Here comes a challenging problem for all of you.
Scenario is like this:
There are 3 GL account codes (0gl_account), that has to be grouped and aggregated value has to be taken for further calculations. There are around 150 such grouping has to be done.
Solution: We create 150 such restricted key figuers and finally do the calculations according to the result we get.
Is there any way of doing the grouping like this in Bex itself, i mean in a kind of looping, 3 accounts are selected, results are calculated, next 3 accounts are selected, results are calculated..and so on....
Please share your views and ways to handle this kind of things.
Answer:
Sounds like you should create an attribute on the account number! Then you could do your reporting on the attribute. Or you could create a structure that holds the grouping.
regards
Kristian Appel
Answer:
according to me, the way to go would definitely be an attribute on your 0GL_ACCOUNT which you ppopulate in the Update or Transfer Rules (each time a specific value for each 3 accounts that belong together). Then use this attribute in your drill-down or drill-across et voila...