Skip to Content
0
Aug 21, 2017 at 11:15 AM

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

267 Views Last edit Aug 21, 2017 at 12:03 PM 2 rev

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