Distince Count Problem

Distince Count Problem

Post by Wikus Scha » Wed, 25 Aug 2004 19:56:44


Hi,

I'm trying to solve the distinct count problem, but don't know hoe to apply
it to my cube.

Basicly
- [Fact Table] linked to a [link table] thats linked to a [Dimension] table


like
[Purchase] ------ [Purchase to Product link] ------- [Product]


Is this way ok, or is there a better way of linking many items to one fact
table entry???

Anyone, tx.
 
 
 

Distince Count Problem

Post by Jame » Wed, 25 Aug 2004 21:21:24

Hey,

Why don't u consider using a logical view to join the
purchase-product and product tables together.

Sometimes when build cube, just can't bother too much on
the database normalization rules.


rgrds,
James Gan HJ


know hoe to apply
a [Dimension] table
[Product]
items to one fact