fact table join to multi record table - summary problem

[BrentNashville]

Pretty new to this and any help is appreciated. Have a scenario with a basic fact table with summary info. I want to link it to multiple other tables, each with a 1-t0-many relationship for purposes of having dimensions supplied from each table. For my summary measure, i don't want any row cascade from these other tables to cause a cartesian type product - i.e. the belowsintersetion of sample tablescauses the following:

fact table

ID Amount
1 $100

Joined table 1

ID Dimension Value
1 A
1 B
1 C

For my measures I get count of 3, total of $300 -,
I'm looking for count of 1, and total of $100 still regardless of the below "fact" table selection.
Any help would be greatly appreciated.
Regards,
BrentNashville

 

[blom0344]

Your model should be either a star or a snowflake. This will ensure that the SQL executed will prevent multiplication of data. In some cases it may be a good idea to build a database view first (from fact data) and use this to join to dimensional tables...

Ties Blom