Skip to Content
0

Previous Calmonth calculation in SAP HANA

Nov 01, 2016 at 04:45 PM

59

avatar image

Hi Gurus,

I require 2 calculated columns as 0CALMONTH (which can be taken from M_TIME_DIMENSIONS table) and 0CALMONTH-1. I need to know how to calculate the Previous 0CALMONTH as a calculated column. Please suggest.

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vivek Vijayakumar Nov 02, 2016 at 03:05 AM
0

Hello Florian,

I have an input parameter based on 0calmonth and if I select Nov 2016, the report should display the previous month, Oct 2016. Please suggest how to express the same as calculated column or as a procedure/script.

Thanks in advance

Share
10 |10000 characters needed characters left characters exceeded