Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

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

    Add comment
    10|10000 characters needed characters exceeded