re: Updated Paper on Aggregations in ProClarity 6.3 - SCOPE_ISOLATION

rlharmon@yahoo.com — Wed, 02 Dec 2009 17:24:27 GMT

I know the paper references SQL Server 2005 SP2 specifically, but does this paper's recommendations work with SQL Server 2008 SP2.

Here is the MDX that I can not retrieve a sub-total too..

sum({[Date].[Date].currentmember.level.members}.item(0): [Date].[Date].currentmember,[Measures].[Closing])

[Measures].[Closing] is a Count measure from our Claim measure group.

To me this is a pretty straight forward Calculated Measure and I am not getting Sub-Totals or Grand-Totals.

re: Updated Paper on Aggregations in ProClarity 6.3 - SCOPE_ISOLATION

MSFTProClarity — Thu, 03 Dec 2009 00:23:37 GMT

Hello,

Thanks for contacting us. These types of questions are however best dealt with in the TechNet forum at http://social.technet.microsoft.com/forums/en-US/proclarity/threads/. If you're not able to find an answer to your question in an existing thread, please feel free to start a new one.

Thanks again!