Time dimension with different start dates 1

[argturus]

I have a time dimension that has a different fiscal pattern depending on the company. This means that the start date of a financial year is not allways the same.
I need to know how to handle this in AS.

Thanks

Arg

 

[Flybridge]

The easiest way is to create a time dimension per company, but that increases the number of dimensions and relies on some user intelligence to select the correct time dimension - and my experience suggests that is not always a right assumption to make!

You could perhaps make them alternate drill downs using the company name, e.g. Time.Company1, Time.Company2 etc. That would make it easier for the users to make the right selection

 

[johnherman]

Create your own Calendar table.

We have the same situation here, where we have one five week month each quarter and once in awhile, have two five week months in a quarter to catch up. In any case, the basic time unit (besides day) is week. Months consist of 4 or 5 weeks, quarters contain 13 weeks with the exception noted above, so our fiscal months and years do not coincide with the calendar EOM and EOY.

In your case, the calendar table would either have a separate column for each company or would have the company name as part of the key (preferred).

-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw