Difference Between 0CALDAY vs 0Date
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'?
Praveen G replied
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