I need a count of a time dimension store
I need a count of a time dimension stored as weeks (leveled up to Years) based on a SQL db table date as every Friday so that when you apply this measure to the same time dimension you should see it increment from the start of a year giving you the rolling # of weeks YTD. I can get the total based on MAX for the year but I need the measure to change and show it based on dimension date. When I attempt this I get a duplicate dimension error. (embarrassed to say I'm using SQL Server 2000.) Any suggestions or help would be greatly appreciated.