Skip to Content
0

How to understand to format Month/Year in webi

Aug 04, 2017 at 08:35 PM

85

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.

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

10 |10000 characters needed characters left characters exceeded

How are the values in calmonth/year.

Is calmonth/year object datatype is steing or date?

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

0 Answers