on 10-01-2008 3:39 AM
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'?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.