Forum Replies Created
-
Posts
-
If you want to compare the measures in the facts than you need a shared dimension (or conformed dimension). So normally you have a date dimension, customer dimension, etc. These can be shared between the facts. In dimensional modeling every describing attribute should be in the dimension. When the number of different records are small I sometimes leave them in the fact. I’ve read some where that this can increase performance instead of numerous small dimension tables.
As it seems in your xls second tab you want to create a kind of a snowflake star schema? and related only via the site article dimension table. Seems not correct ot me but may I don’t understand the diagram. So I would suggest trying to create a conformed dimension between the two facts and see whether how it performs. If not try to add it as a field in the fact. not sure whether the latter is working. Never done this like this…
Good luck!
Hennie
