1 Reply Latest reply on Jun 4, 2013 5:50 PM by SaichandVaranasi

    cardinality in BMM layer

      Dear All ,

      I have a question in the rpd in OBIEE that is what difference we will get when we have given an option in the BMM layer as 1 to many 0r many to 1 to 1 in the Joining tables .I would like to know that this cardinality will give any difference in the record count in the reports .

      Please suggest me what is the usage of the cardinality in sql query out put .

        • 1. Re: cardinality in BMM layer

          From the guide "A key property of a logical join is cardinality. Cardinality expresses how rows in one table are related to rows in the table to which it is joined. A one-to-many cardinality means that for every row in the first logical dimension table, there are 0, 1, or many rows in the second logical table. The Administration Tool considers a table to be a logical fact table if it is at the Many end of all logical joins that connect it to other logical tables"

          It really matters when you specify the driving tables if left hand side has less reocrds than right hand and makng it as driving table by menitoning the cardinality

          1 person found this helpful