on 09-15-2014 1:48 PM
Hi Swetha ,
It seems you have created structure in BW based on user input for a year.
Last 6 months
Last 7-9 months
Last 10-12 months
Ideally you'll be getting last year September to this year September.
So , you can write formulas in webi like
LY =[0-30] where ([structure]=min([Structure] in report) for last year September.
CY =[0-30] where ([structure]=max([Structure] in report) for current year September.
Difference will be CY-LY .
It is good to get sum of 0-30 from BEx and calculate % in webi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any replies please....,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Swetha,
Can you provide a little more detailed explanation. I am not clear what is your exact requirement. My understanding is currently based on the key date entered by user, bex query is calculating the values for defined buckets. The same you can implement in BO also using your existing query. Are you facing any challenge in implementing it?
Regards,
Nikhil Joy
Hi Nikhil
Thnaks for your reply. If you see the attachment, I need output in that format. But query is running based on one date, which is user entering date. user needs 4 months data. He wanted to select any month in webi, query has to take as input date of that month last day and need to provide data. Same way for other months also. I have only one query. How do I achieve this?
Regards
swetha
Hello Swetha,
Seeing your screenshot I thought BEx report is already available.
Regarding the requirement, you can implement this logic in BEx query side. You can define a customer exit variable which gives last day of month from selected calmonth. Let it be ZDate. PFB a link for similar requirement.
Create a KF structure with your required slabs(buckets) and restrict your keyfigure(say Amount) with posting date between the two dates as per your bucket logic. for eg:- 0-30- Amount restricted with posting date between ZDate and ZDate-30(use offset -30). Similar way using the same exit variable you can restrict your Key figure for required range by offset.
Same structure you can use in Webi report.
Regards,
Nikhil Joy
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.