Hi,
This may sound very simple, but just to re-establish my understanding on the Time Chars, I am asking a clarification.
I have a report which has Calendar Month, Bill Date and Reading Date read from flat files(3 columns in that).
I am defining 3 new Chars as DATE types and then when I create a cube, I add these under the Time dimension. Is this correct?
Someone confused me with a statement that we dont need to define any Time Char as we just point all the Time related columns to a single Time Char? No idea what it meant.
Also, please let me know, if these Time Chars will be able to be displayed in which ever format I want in the report.(like DD-MON-YYYY in one report and only MON-YYYY in another).
Please clarify.
Regards,
Sam.