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.

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