I have two fact tables which are unrelated in my script but have common dimensions. One approach i though was the to rename the same fields in my second fact to something different to the first and then in the dim add another line which gives the link to the second fact. The other option im thinking is to do as described with the fact tables, but create a copy dim. Any thoughts or better approaches?
If the 2 facts have common fields names then you can either use the source field in your expressions to separate the data, or rename the fields so that the fields for the two concatenated facts are kept separate.
Obviously the common dimension(s) would have the same field names.