Skip to Content
0

How to get Prior Year and Prior Year Same Month in Webi if we are having only YEAR and MONTH object

Aug 21, 2017 at 11:15 AM

74

avatar image

Hi All,

Can anyone help on below scenario.

we have been building webi report with current month(CM), current year(YTD), Prior year(PYTD) and Prior Year same month(PYSM) bukets.

we have only YEAR and MONTH objects from source so we used those in different data providers like below.

MTD>> YEAR prompt equal to value 'XXXX' MONTH prompt equal to value 'XX'
YTD>> YEAR prompt equal to value of 'MTD YEAR' and MONTH less than value of 'MTD MONTH'(so it would pull user selected year and less than months)
PYTD>> YEAR prompt less than value of 'MTD YEAR' and MONTH less than value of 'MTD MONTH'(so it would pull user selected less than year and less than months)
PYSM>> YEAR prompt less than value of 'MTD YEAR' and MONTH equal to value of 'MTD MONTH'(so it would pull user selected less than year and only month)

here we are having issue with YEAR in PYTD and PYSM,

If we are doing like above it has been pulling all the previos years in PYTD and PYSM but

we want to pull only prior year in PYTD and PYSM based on prompt of MTD.

do we have any alternative way to do at universe level.

.

How we can achieve this, can anyone please provide solution for this.

Thanks in advance.

Vijay

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Aug 21, 2017 at 01:00 PM
0

Sounds like you'll need to investigate the date/time functions of your database, e.g. SQL Server's DATEADD and DATEDIFF functions

Share
10 |10000 characters needed characters left characters exceeded