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

[former_member195433]

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 .

[carlos_weffer · Accepted solution]

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.

[former_member187192]

Derive Calmonth & Year from date in CALCVIEW itself.