Previous year/period in WEBI

[former_member327592]

Hi,

Please help me here.

I have selections in webi report for posting period as July 2019 . I need to get last year amount ie Jun 2018 in WEBI

I have tried Relative data ,but no luck . This is using bex as a source . We can do this in Bex using offset but need this functionality in WEBI.

Appreciate your advice .

Thanks

[amitrathi239]

do you have data in webi from July 2019 to Jun 2018?

[saurabh_sonawane · Accepted solution]

Hi Manoj,

you have to create a flag in the BW side only. YTD TY and YTD LY flag.

else

we have to bring 2-year data from BW side do not filter the data buy fiscal period.

after that, you can use a relative date function to get the last year data.

Thanks,

Saurabh S.