SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books
| I need a count of a time dimension store |
| 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"
