Skip to Content
avatar image
Former Member

How to get 0calmonth and 0calyear in HANA composite provider

Hi ,

I have 0calday coming from Calculation view and i have created a composite provider on calculation view. How can i deduce 0calmonth and 0calyear in composite provider ? I need month and year in bexquery .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 28, 2017 at 04:38 AM

    You could use "_SYS_BI".M_TIME_DIMENSION to obtain all time dimensions: CALMONTH, CALYEAR, CALWEEK, etc.

    A prerequisite is to Generate Time Data.

    https://archive.sap.com/discussions/thread/2155677

    Regards, Carlos W.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 24, 2017 at 08:52 AM

    Derive Calmonth & Year from date in CALCVIEW itself.

    Add comment
    10|10000 characters needed characters exceeded