-
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.
-
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
-
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
-
Forum Rules
|
|