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

---

]]>