I get my fiscal periods from a legacy financial system.

The fiscal period is like 0052004 which is 005.2004. I would like to
construct a time hierarchy from this but time hiearchy needs a
datetime field of type date please advice how I can use the above kind
of time periods and build a calendar hierarchy.

Thanks
Karen

you can create a time dimension without having a date time information.
in your case, cut your string in 2 string (right 4 characters and the 3
left)
put the 4 last as the year level in your dimension (optionaly: set the
level type (in the advanced tab) to years)
put the 3 first characters as a second level called "period", and setup the
entire "0052004" characters as the key of the period dimension.

Now you have a time dimension with years and periods.
2004--> 005


"Karen Middleton" <karenmiddleol (AT) yahoo (DOT) com> a écrit dans le message de news:
a5fd468a.0409080229.4044a945 (AT) po...OT) google.com...

For a good overwiew of Time dimensions take a look at Tom Chester'a article
at www.tomchester.net

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Karen Middleton" wrote: