Skip to Content

How to understand to format Month/Year in webi

Aug 04, 2017 at 08:35 PM


avatar image
Former Member

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.

Any help will be appreciated.



10 |10000 characters needed characters left characters exceeded

How are the values in calmonth/year.

Is calmonth/year object datatype is steing or date?

* Please Login or Register to Answer, Follow or Comment.

0 Answers