Error adding 0TCTTIMSTMP to infocube

[former_member254358]

Hi,

I have a datasource with a date and a time withe the following format:

'20160201' and '092333'.

Reading about how to add a time field to an infocube I saw the info object 0TCTTIMSTMP but, when I insert this info object to the infocubre I can't do it.

Later I read it was possible to concatenate date and time and insert this string to 0TCTTIMSTMP.

Is it the correct way?

In my infocube, will I have date (0calday, 0fiscper, and so on) and the time?

Thanks a lot.

Regards.

[bhavinvyas · Accepted solution]

Hi David,

Please see this thread,

https://scn.sap.com/thread/1808801

Hope it helps!!!!

Thanks,

Bhavin Vyas

[Former Member]

Do you really need a timestamp ?

In some cases such dimension can be more than X% relative to fact table and it can lead to bad performance. I would prefer to store date and time separately.

Another bad effect is in a huge SID-table of infoobject.

[former_member254358]

Not really.

I can store date and time separately.

0calday to store date but which infoobject I can use to store time?

Thanks.

[Former Member]

0TIME 🙂 (or any infoobvject in reference to 0TIME)

[former_member254358]

Thanks.

I'm going to change to 0TIME in the infocube and see  if it works.

Regards.

[former_member254358]

Hi,

I've tried to concatenate this way_:

yyyymmddhhmmss

and although the load finish correctly if I see data in the infocube the data for are not in a correct format.

Have I to concatenate the date and the hora in a different way?

Thanks.

[Former Member]

Hi,

try concatenate from formula in transformations.

map date and time to 0TCTTIMSTMP, then in formula use : <datefiled>&<timefield>

[former_member254358]

Thanks a lot.

Now perfect.

Regards.