Hi All,
in Planning Analyst 10.1, I created a Dlist and formatted it as Date MM/DD/YY. I created a cube using the Dlist in combination of another Dlist. Now I entered a date in this cube as 09/25/12 and the cube saves it 09/25/12. Now, I edit the Dlist and format it from Date to Numeric and save it. Now when I reopen the cube that date value becomes 41179. But, the ms excel numeric equivalent of this date is 41177. So, cognos analyst is certainly 2 numbers off. I was wondering if anyone has come across this. Any info is greatly appreciated.
Thanks,
Sameer
I replicate Same scenario on cognos 8.4 analyst. As cognos stores numeric value for date start from 01/01/1900 is 0 and the date provided has return me 41175 instead of 41177 or 41179. As you are comparing this with Excel of which index start at 1 instead of 0 for storing date that is 01/01/1900. This index numbers assists to get difference between date.