Replace WTD Measure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replace WTD Measure

Trying to create WTD measure to rollup based on business weeks instead of calendar weeks. I have two hierarchies, the primary one is on a calendar basis and the secondary one is on a business week basis. I created the business week hierarchy so that if a month ends in the middle of the week the business week hierarchy knows that Sept 30 2004 and Oct 01 2004 are in the same business week. Is there a way to have my WTD measure calculate based on my business week hierarchy while my YTD, QTD and MTD measures calculated based on my normal calendar week hierarchy?

You can have your WTD Calculated Measure point to your your Fiscal or business hierarchy like in this example. SUM(PeriodsToDate([Time].[Fiscal].[Month]),[Measures].[Total Usage]) Here Im summing up total usage for each month based on my Fiscal hierarchy. To differentiate between the two hierarchies you place a period followed by the hierarchy name like this…. Time.Calendar and Time.Fiscal. Hope this helps Raulie