Question:
Hi BW Gurus ,
Can any body help me . I have requirement in which the user selects a range of the year and month .Quaterly wise i need to find out the sum . and calculate the growth between 2 consecutive quaters EX - when we select July to Dec .I need to get the SUM ( July, Aug ,SEP )ie JAS an then SUM(Oct ,Nov,Dec) ie OND Growth =( OND-JAS)/JAS.
I have tried to the hard coded way , but that is not the way the client needs it . They want ,when selected dynamically automatically the query shd calculate all the requirement and give the output with out the hard code way .
I hope i have made my self clear .
PLZ Help me
Thanks In Advance ,
SZ
Answer:
Hi!
Creat an object as FISCQTR. Put it in yr cube and in yr update rules write a routine to feed values of Months as qtrs. Like of period > '001' and period < '003' then result = 1. I don't hv ABAP knowledge so the code whihc I hv written might not be correct.. but logic is correct.
Subsequrnly create variable for this object in yr Query and ask user to input the fiscal year and the Qtr. Subsequently give variable offset as +1 for the next qtr.
We have used this logic in number of cases successfully.
Answer:
this can be achieved with a combination of restricted key figures and calculated key figures, in addition to that you need one or two variable to be filled at runtime
it is hard to explain in writing, and I am not yet enough experienced on that side of the things to start it from scratch (and also, I never like to teach the whole story from scratch, as you might know)
but still an advice : USE THE SEARCH of this forum, this has been answered less than 2 month ago
Ch
Answer:
Thanks , i will search the forum .