SSAS - Interconnection / Granularity

Question

I have 2 fact tables with each measure group, production and production orders. Products have production information with a lower degree of detail (at the component level), production facilities have information at a higher level (order level with the number of headers, etc.).

I created a surrogate key link between two tables on productionorderid. As soon as I add the identifier Prod (from productiondetailsdim) to the pivot table, it returns the actual qty (from the prod order dimension group), and I cannot combine qty from the two measure groups.

How can I create the right connection between them? See My foggy usage chart. Production information is a dull one that links two fact tables; currently DimProductionDetails is in actual relationship with Production. I'm not sure what the relationship with the production order should be (there are a lot of them now).

See sample data between two tables:

I have to duplicate this behavior:

Answer 1

Do you want all the actual qty from the prod ordering group to be repeated next to each product? If so, then many-to-many relationships are true. I suspect as soon as I explain how it works, you will find a problem.

" ", . , , 245295 1/1/2015, 245295 1/8/2015, , null, , , , . , , , DSV, , . . ( - , .)

: , qty , . "--" , , , ProductionOrder_SK ( ) . "" "" "" "false". , , " ", null.