Results 1 to 3 of 3

Thread: trouble with distinccount..

  1. #1
    Join Date
    Dec 2004
    Posts
    5

    trouble with distinccount..

    Hello,

    I have a cube with a lot of dimensions. Two of them are ItemNo and LocationCode. I need to have two measures "Locations Shipped To" and "Item Count". For those, I need to have a count of different locations/items matching current dimension filters. So I tried adding a calculated member:

    distinctcount({[Item].Members})

    but it only shows 0 or 1

    Am I missing something here?

    thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607
    Hi:

    Take a look at my articles at:

    http://www.databasejournal.com/featu...le.php/3454931

    and at:

    http://databasejournal.com/features/...le.php/3482536

    If you still have issues, let us know, but the stuff you're trying to do should be well within the scope of the "basics" discussion.

    Good Luck!

    Bill

  3. #3
    Join Date
    Dec 2004
    Posts
    5
    I made a dumb mistake back there - fixed it, and it works now.. Somewhat. I have a problem though.

    Say I have Item and Location dimension.

    If I select single Location, then ItemCount shows correct count. But if i select two or more Locations, then ItemCount shows count as if all the Locations where selected..

    Any ideas why would it be so..?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •