0 Replies Latest reply: Nov 22, 2012 3:15 AM by Ric79 RSS

    Bridge 11g

    Ric79
      Hi all,
      I've read the tutorials about bridging in obiee 11g but I need a check for my solution:

      A network node has multiple properties:
      FACT_NETWORK_NODE (SK_NODE_ID, ....)
         |
         |
      BRIDGE (SK_NODE_ID, SK_NODE_PROPERTY_ID)
         |
         |
      DIM_NODE_PROPERTY (SK_NODE_PROPERTY_ID, ...)
      In BMM I created: Fact_Network_Node e Dim_Node_Props.

      1) Now the bridge table has to be added as logical join in Dim_Node_Props?
      2) How about the Primary Key in the new Dim_Node_Props? It should be (SK_NODE_ID, SK_NODE_PROPERTY_ID)
      3) How about the logical join in BMM?

      Riccardo