Im am using an SQL server 2005 AS cube and want to make a YTD calculation
which can handle the two different hierarchies that my time dimension has:
- Year-Month-day hierarchy
- Year-Week-dat hierarchy

Dpending on the attribute the user provides, the measure has to be cumulated
untill the given month (when the user provides a month) or week (when the
user provides a week).

I want to make 1 calculated member which can handle weeks and months.

Can anybody give me some help on this?

Thanks

Hi Pieter,

please go through this blog.
http://sqljunkies.com/WebLog/mosha/a...lelperiod.aspx

it talks about something simillar to your situation.
Might be helpful

Pieter M wrote: