Skip to Content
0
Former Member
Feb 17, 2011 at 05:26 PM

Getting data of next 4 months in Webi

25 Views

Hello Experts,

I have data of next 4 years in my database. I have created one date object in universe and I have created prompt on this date object. My requirement is as follows :

User will enter the date through prompt and my report should pull data for next 4 months from entered date and display in report as follows:

e.g If user enters date as 17/02/2011, then report should pull data of next 4 months as follows:

March Apr May Jun

Records for March Records for April ........ .......

I think this should be achivable using Crosstab. But I am not getting exact way to do this.

Any help in this regard is greatly appreciated.

Regards,

Chinmay