cancel
Showing results for 
Search instead for 
Did you mean: 

Aging report format ..??

Former Member
0 Kudos

Hi All

My client is asking attachment format for aging report. we have one aging report based on user entering posting date (key date). we calculating all aging values for respecting buckets in sap bex. How can I bring user output here? any helping hand here pls.

Regards

swetha

Accepted Solutions (0)

Answers (2)

Answers (2)

sateesh_kumar1
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Structure means ..?? can you explain detailly pls. I have created buckets like , 30, 60 90 120 etc.., As per attached scr shot, how do I present (design webi), bex query? i think your solution is close, can you pls explain detailly ...

sateesh_kumar1
Active Contributor
0 Kudos

How you created buckets in BEx.

Are they 0-30 for sep 11, 0-30 for mar 12,0-30 for and so on ?

or only 0-30 ?.

If you have only one keyfigure for 0-30 , then in BEx structure is used.

can you post your BEx query snapshot.

Former Member
0 Kudos

any replies please....,

nikhil_joy2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

nikhil_joy2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Nikhil

I built bex query already. User wants to display 4 months data in webi in same page and comparing it. How do I provide (webi format) for user, I have only one query in bex.

swetha