http://www.sqlmag.com/authors/author/author/5777813/rsscomment/5777813en-USFri, 25 May 2012 09:21:13 GMTFri, 25 May 2012 09:21:13 GMThttp://www.sqlmag.com/article/reporting2/analysis-services-2005-brings-you-automated-time-intelligence#commentsAnchorMon, 09 Jun 2008 16:34:48 GMT
oops should have proof-read better. Should read: I tried this with my own cube, and got NA for every member of my fiscal calendar hierarchy except for the members at the Fiscal Year level, which is what I expected, given the MDX generated.]]>DavidMon, 09 Jun 2008 16:34:48 GMThttp://www.sqlmag.com/article/reporting2/analysis-services-2005-brings-you-automated-time-intelligence#commentsAnchorhttp://www.sqlmag.com/article/reporting2/analysis-services-2005-brings-you-automated-time-intelligence#commentsAnchorMon, 09 Jun 2008 16:34:28 GMT
Here’s what I don’t get: ( [Date].[Fiscal Date Calculations].[Year to Date], [Date].[Fiscal Year].[Fiscal Year].Members ) limits the scope to just the Fiscal Year members of the Fiscal hierarchy. Yet figure 4 shows all members of the hierarchy affected by this script. I tried this with my own cube, and got NA for every member of my fiscal calendar hierarchy except for the members at the Fiscal Year member, which is what I expected, given the MDX generated. I had to add assignment statements for Fiscal Quarter, Fiscal Month, and Fiscal Day of Month in order to get Year to Date values for all members of my Fiscal hierarchy. Can someone explain what I’m missing? Thanks.]]>DavidMon, 09 Jun 2008 16:34:28 GMThttp://www.sqlmag.com/article/reporting2/analysis-services-2005-brings-you-automated-time-intelligence#commentsAnchorhttp://www.sqlmag.com/article/reporting2/analysis-services-2005-brings-you-automated-time-intelligence#commentsAnchorThu, 12 Jan 2006 22:17:11 GMT
This article is very useful]]>ChandraPrakashThu, 12 Jan 2006 22:17:11 GMThttp://www.sqlmag.com/article/reporting2/analysis-services-2005-brings-you-automated-time-intelligence#commentsAnchor