Skip to Content
avatar image
Former Member

How to understand to format Month/Year in webi

Hello Gurus,

I need some help in understanding how to address calculations in webi which have Date involved in it. I have created a simple BEX report and a Universe on top of it. I am not using a .unv universe. The query has Calendar Month/Year for time characteristics.

I Have 3 years data 2015/2016/2017. I need to show Sales for Current year, sales for Prior Year, Forecast for Current year and Budget for current year. How can I start writing the variable. I need basic understanding from where should I start. I searched a lot but could not find something. I followed the following two posts but in the second link the author has taken Fiscal period. I tried to replace it with Calendar month but it did not work.

https://bobjblog.wordpress.com/2012/03/05/web-intelligence-date-formats/

http://www.paulberden.nl/2011/06/year-to-date-comparison-with-previous-year/

Any help will be appreciated.

Regards

Prashant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers