MTD,YTD calculations at sap bo Oracle universe

[Former Member]

Dear SAP BO Experts ,

I know how to create MTD and YTD using sap bw since backend is bw for my reports and dashboard, l want to know how to create MTD YTD at universe level for my dashboard ,

For web intelligence , I know we can create in web intelligence so

Kindly let me know MTD YTD calculations at universe level please

[ayman_salem]

Use substr to get month and year from a date (current date 'sysdate' or another date), then use it to calculate MTD and YTD as in WebI

ex. cCurrDate: to_char(sysdate)

MonthOfCurrDate: substr(@Select(cCurrDate),4,2)

YearOfCurrDate: substr(@Select(cCurrDate),7,4)