January 2010 Entries

I've seen this question come up a couple of times. What is usually being asked is "can we make the subtotals additive for a distinct count measure?" – and the short answer is a resounding No! But the short answer does not really make for a compelling blog post, so let's dig a little deeper into this issue. The more complete answer is that while there are some techniques that can make a distinct count "appear" to be additive in some circumstances, they are fundamentally flawed and will produce inconsistent ......

Share This Post:
Short Url: http://wblo.gs/ZtP

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.

Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

NetworkedBlogs

Blog:

Random Procrastination

Topics:

MDX, SQL Server, BI

Follow my blog

Twitter

darrengosbell @mtydeman sorry, was not on twitter last week. Yes, SSAS MD works well with snowflakes. The joins are resolved during dimension processing about 10 days ago

darrengosbell SSAS: Clearing the MDX Script for a session in SSMS http://t.co/jioE6bQO about 110 days ago

darrengosbell SSAS: Executing MDX Scope statements using SSMS http://t.co/Tpx9pfoz about 154 days ago

darrengosbell @MitchDenny thanks - I had a ball, #powerview is such a cool thing to demo about 246 days ago

darrengosbell @asantaballa @jenstirrup daxeditor is not me, that's an MS sample. I'm working on http://t.co/b1JsRLps at the moment about 303 days ago

darrengosbell @Technitrain I can see it too about 303 days ago

darrengosbell @jppp I hope you enjoy the 2012 release :) life's been pretty good - too busy, but still good. about 428 days ago

darrengosbell BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) http://t.co/dSWkG7PI about 428 days ago

darrengosbell @Kjonge just showed that in post-ctp3 #denali #Dax in #ssas will have query plans as profiler events about 586 days ago

darrengosbell Really hard choice for this timeslot @Kjonge, @jenstirrup & @marcorus all have sessions at the same time. Lucky I ordered the DVDs #sqlpass about 586 days ago

Darren Gosbell [MVP] - Random Procrastination

Business Intelligence, SQL Server, .Net, Powershell and MDX Madness

January 2010 Entries

SSAS: Can I make my Distinct Count totals subtotal correctly?

News

Twitter

Tag Cloud

Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: