SQL Server Performance

Replace WTD Measure

Discussion in 'Analysis Services/Data Warehousing' started by Lowcut, Sep 21, 2004.

  1. Lowcut New Member

    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?
  2. Raulie New Member

    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


Share This Page