Skip to Content
0
Former Member
Sep 10, 2007 at 01:26 PM

Doubt on Time Characteristic

18 Views

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.