Hello there,

I am working in developing an aggregation of measures that
will depend on as to whether an entity or company is on a
calendar or fiscal year.

That is i have measures loaded for 2004 by month, but
certain companies are in a fiscal and other are in a
calendar year.

So to calculate a YTD, the calculation will have to have
intelligence to know to aggregate in a fiscal year or
calendar year basis.

Any ideas are highly appreciated.

thanks!!

Have 2 seperate dimensions, 1 called fiscal year, one called calendar year. Aggregate over YTD in each dimension sperately and let the user choose which aggregation they want to use.

Will that work?

Regards
Jamie

"enrico" wrote:

The other idea is to have a new dimension called say "Calendar Type" with two members Calendar / Fiscal. When users are working with your cube they can easily then filter between the different system of calendar.

For this to work well, remember to ensure that the "Calendar Type" dimension does not have an ALL member, otherwise you data will appear to be twice as large when users fail to pick a single calendar type. Having no ALL member means that only one calendar type will be current a time

Rob

"Jamie" wrote: