Distince Count Problem

Distince Count Problem

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


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

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

[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


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.

James Gan HJ

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