many to many relationship. RRS feed

  • Question

  • For regular relationship, we use the following query to know what data the cube will finally have.

    select * from
    fact_table f inner join dim d
    where f.some_key=d.some_key

    For Many-to-Many relationship, what query should we use? since it have 3 tables involved, should we inner join 3 tables?
    Wednesday, October 12, 2011 8:01 AM


  • Hi,

    Using "inner join" query is just roughly for your reference. For exact monitor, i'd suggest you enable SQL Server Profiler to look into its queries fired when processing your cube. Additionally, process command also can redefine the query within the "QueryDefinition" tags, check "Out of Line Bindings" of this article .


    • Marked as answer by Daniel Wu Tuesday, October 18, 2011 2:31 AM
    Monday, October 17, 2011 10:08 AM

All replies