cancel
Showing results for 
Search instead for 
Did you mean: 

0CALDAY

Former Member
0 Kudos

Hi experts-

How can I get data into 0CALDAY in following scenarios. Given that I have chosen 0CALDAY as time characteristic in my InfoCube definition.

ONE: I have filed (mm/dd/yy) in my flat file.

TWO: I have ODS object that has Data filed (an InfoObject) of type CHAR. (This is actually feeded from the file).

I am not sure do I need to create any InfoObject corresponding to this date field in my InfoCube and then assign (don't know how) to 0CALDAY.

I appreciate your help.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi:

If your dats i sin the format: mm/dd/yy

You need to write ABAP to convert it into YYYYMMDD if you want to map this to 0calday. You can write in Updsate Rules too.

Ram C.

Former Member
0 Kudos

Based on your replies, I think I can do as below.

Specify 0CALDAY in communication struct. while defining infoSource to load transactional data and assign date filed from flat file to this in transfer rules.

Am I correct?, If yes, can we also load the data as Masterdata. I mean using an infosource just for 0CALDAY and having file (or from ODS) with just one field.

Normally how this is done when using R3 as source system, is it loaded during transactional data load or separately loaded as master data?

Thanks

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

that mapping will be done in the Transfer structure... when u assign the datasource to your Infosource, you'll be taken to a screen where you'll map the fields coming in from the source system to that of your BW system under the tab "Transfer Rules"... Once you've mapped it, BW will automatically know that this field picks up the date that has been mentioned in your flat file...

Regards

Manick

null

Former Member
0 Kudos

Hi,

you need not create any InfoObject corresponding to this date field in your InfoCube... it would by default be there while you define your InfoCube itself under the Time Characteristics tab... There you jus need to choose the characteristic as 0CALDAY.. thats it...

Hope it solves your doubt..

Regards

Manick

Former Member
0 Kudos

Hi Manick, you are right. I am clear with that. But my question was, how can I actually map the incoming data (from flat file or ODS) to this 0CALDAY.