Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frog314
Starting Member
6 Posts |
 Posted - 2004-03-20 : 09:56:49
|
Hi!I have build in the cube Sales (FoodMart 2000 database) distinct count measure which count distinct clients (on id). When I use this measure to analysis how many clients buy some group of products not everything is okay. I try to answer for question: How many customers buy group of products?To make analysis I’m use Panorama program. Could YOU help me solve this problem? I thing I have to build some calculated member but I don’t know how to do that!Here is example (what’s wrong):DATABASE: FoodMart 2000CUBE: SalesSELECTED DIMENSIONS:customersproducts MEASURE: distinct customers countEXAMPLE(Good Imported Beer) (USA customers) (distinct customers count) = 51 ---probably true(Good Light Beer) (USA customers) (distinct customers count) = 37 --- probably true(Good Imported Beer and Good Light Beer) (USA customers) (distinct customers count) = 88 FALSE!OR(All products) (USA customers) (distinct customers count) = 5581 = N.true ?? ??(Drink products) (USA customers) (distinct customers count) = 3458 = N.true ?? ??(Food products) (USA customers) (distinct customers count) = 5525 = N.true ?? ??(non-cons. products) (USA customers) (distinct customers count) = 4468 = N.true ?? ??But  (Drink and Food products) (USA customers) (distinct customers count) = 9010 = false!(Drink and non-cons products) (USA customers) (distinct customers count) = 7953 = false!(Drink and non-cons food products) (USA customers) (distinct customers count) = 13478 = false! *************Frog314************* |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-20 : 11:43:29
|
| Please don't cross post, once is enough:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33566 |
 |
|
|
|
|
|
distinct count problem