Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Count Distinct help please

  1. #1
    Join Date
    Jun 2003
    Posts
    12

    Default Count Distinct help please

    How do I get a measure to count a distinct number of customers if I have a customer dimension and a customer fact table? the schema/cube is based on this fact table, but when the number of customers shows up..it is exponentially counting.
    I noticed this is also happening in the HR Foodmart.xml example. With Number of employees. This could be a real show stopper with us, if Mondrian does not allow this. Any info. given will be greatly appreciated...
    Thanks in advance. -T

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Count Distinct help please

    We don't support a count-distinct aggregator right now, and I don't think there's a workaround. Other people have asked for this too, so please log an RFE and I'll try to get to it soon.

  3. #3
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Count Distinct help please

    Change 643 fixes this.
    There is one case which does not work: rolling up a distinct count over a parent-child hierarchy. This is problematic because distinct count has to be evaluated in SQL (because it doesn't roll up), whereas parent-child hierarchies cannot be rolled up in SQL (because SQL cannot compute a transitive closure).

  4. #4
    Join Date
    Jun 2003
    Posts
    12

    Default RE: Count Distinct help please

    Where do I get Change 643? Please advise.Thanks in advance

  5. #5
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Count Distinct help please

    You can get change 643 (along with the rest of the source code) from our Perforce source-control server. Instructions are in the install guide.
    Alternatively, wait for the release: there will be one within a week.

  6. #6
    Join Date
    Jun 2003
    Posts
    12

    Default RE: Count Distinct help please

    thanks a million!

  7. #7
    Join Date
    Jun 2003
    Posts
    12

    Default RE: Count Distinct help please

    Any idea when a new version will be out..tried to build and obviously there are major steps here. thanks in advance,
    -T

  8. #8
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Count Distinct help please

    I know I promised a release in July, and I'm running a few days late. I've just posted a release candidate (mondrian-1.0-rc1.zip, under 'mondrian experimental').
    If there are no issues with this, the release will be in a day or two.

  9. #9
    Join Date
    Jun 2003
    Posts
    12

    Default RE: Count Distinct help please

    sorry to be a pest, but any ideas when the new release will be out? thanks -T

  10. #10
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Count Distinct help please

    Mondrian 1.0 was just released. Sorry for the delay!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.