SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books
I need a count of a time dimension store
User Rating: / 0
Written by Dave Brown   
Monday, 24 October 2011 14:44
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.
This is a comment on "Time MDX Cheat Sheets"

Pyramid Analytics