Totaling in ProClarity

I've written a paper on Totaling in ProClarity.  It's certainly not comprehensive but I do hope it answers some common questions regarding totaling.  Please contact us with any feedback or questions.

Thanks,

-Joey

Aggregation in ProClarity 6.3 with SSAS 2005 SP2.docx

Comments

• Anonymous
  January 01, 2003
  I'd like to see detail on:

1. NonEmptyCrossJoin function is outdated for 2005 and should be replaced with NonEmpty function perhaps (ProClarity includes the prior optimization which was geared towards AS2000 and doesn't have an equivelent optimization for 2005).  This can have significant impact when displaying totals and subtotals
2. Performance impacts of the totals/subtotals.  Many of these caveats were mentioned in this posting: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3253692&SiteID=17

• Anonymous
  January 01, 2003
  Thank you for the feedback.  If we get a chance to revise this document, I'll definitely make sure it's updated. http://forums.technet.microsoft.com/en-US/proclarity/thread/62a360b2-f79d-443f-86b0-51d535f44040/