Skip to Content
avatar image
Former Member

Previous Calmonth calculation in SAP HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 02, 2016 at 03:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded