Hi, I need help in replicating this in SSAS, which I have tried for almost a month and still failed. In Cognos Transformer, I brought in 2 fact tables. Fact 1 and Fact 2 have almost identical keys except Fact 2 has an extra key namely "Requirement Key". This cube will have a calculated measure based on measure from each fact tables. (Calculated Measure = Fact1.Measure1/Fact2.Measure 2).

If I were to create one cube out of these fact tables, how do I allocate Measure 1 from Fact 1 to Requirement Key, an unrelated dimension for Fact 1 but a true dimension for Fact 2? I was able to build the cube successfully in Cognos as Transformer do not "join" the two fact tables, rather they build categories and allocate measures to these categories.

For SSAS, the two facts will need to be joined in order for this to work. Hopefully you will have a solution for me. Thanks!!!