Data model Help Urgent Plz!!

[Former Member]

Hi Gurus,

We have a requirement for developing a infocube, where we load data daily based on user activity. we need to load data at <b>hourly(hhmmss), day of the week(like monday, tuesday.. etc), date(YYYYMMDD),Week (Week of the month YYYYWW), Monthly(YYYYMM), Quartly(YYYYQ), Year (YYYY),system(char), title(char).. etc</b>

<b>

my question is, can i use SAP business content for hourly and day of the week ? if there is one can you please tell me which infoobjects i should use? or if i create a custom one should, can someone tell me the definition of the infoobject.?

</b>

Its really urgent, i should start working on creating them by this afternoon. Any help will be great help

thanks,

Deepak

[Former Member]

0CALDAY for day

0CALQUART1 for quarter

0CALMONTH for month

0CALYEAR for year

[former_member184494]

Why cant you use just a timestamp for this ?

0tctstmp ?

it will have the date and time together and I assume that no two loads can happen at the same time same day?

You could then derive the others :

day of the week , month quarter etc..

Timestamp is the combination of Date and time...

Arun

[Former Member]

Hi,

For time you can use 0TIME.

For day of week, i think you have to create custome one

Hope it helps ..

Ravi

[Former Member]

Deepak, your question is not clear........"hourly(hhmmss), day of the week(like monday, tuesday.. etc), date(YYYYMMDD),Week (Week of the month YYYYWW), Monthly(YYYYMM), Quartly(YYYYQ), Year (YYYY),system(char), title(char).. etc" are these charachters in your cube???

I had a similar question, i dont know if this is what u mean....take a look