cancel
Showing results for 
Search instead for 
Did you mean: 

Difference Between 0CALDAY vs 0Date

Former Member
0 Kudos

What is the fundamental difference between 0CALDAY vs 0DATE (0DAT) both Date InfoObjects? Which one is best to data model a reporting requirment to view data based on 'current day'?

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

No difference between the two interms of characteristics.

As you can see 0CALDAY references 0DATE.

But I think you cant use 0CALDAY as attribute but you can use 0DATE.

In terms of modelling 0CALDAY is better because its by default available in the "Time" Dimension if the cube.

Hope this helps

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

check it

former_member185132
Active Contributor
0 Kudos

0CALDAY is a time characteristic, while 0DATE is marked as a simple (non-time) characteristic, of type DATS. What this means is, you can include 0CALDAY in the time dimension but cannot do that for 0DATE. If you try it, it will throw an error saying "invalid type for context"

You can use either of them to model a report to see current day's data. You will need to restrict the infoobject as per 0DAT, which is the SAP exit for current day.