Skip to Content
0
Former Member
Aug 06, 2007 at 02:20 PM

How to map 0CALWEEK 0CALMONTH 0CALYEAR in BI 7.0 transformation

257 Views

Dear all,

Could you please tell me on how to map 0CALWEEK, 0CALMONTH, 0CALYEAR in BI 7.0 transformation ?

Scenario : I have a datasource which delivers WL_ITEM_DATE (date) field which can be mapped to 0CALDAY in the transformation.

I have other time characteristics like 0CALWEEK, 0CALMONTH and 0CALYEAR to be mapped. I am sure, they have to be mapped only based on the available date field.

Please guide me on how to achieve this.

Thanks

Karthik