0 Replies Latest reply: Nov 28, 2012 10:55 PM by 970450 RSS

    Difference between Dimension Id and Dimension Key

      I am reading the third chapter of Rittman's OBIEE book on design of Repository.

      It says while building the BMM, don't drag the dimension Id columns from physical layer to logical layer as the BI Server takes care of the join for you but make sure you drag across the dimension key columns as you will need these later on to create your logical table keys.

      Can someone enlighten me on what is the difference between a dimension id and dimension key (may be with an example).