1 Reply Latest reply: Oct 8, 2012 4:56 AM by Joan Puig-Oracle RSS

    olap star schema design

    966768
      i have two dimention tables like source_ip and dest_ip in db how do i can combain them as single dimention in awm
        • 1. Re: olap star schema design
          Joan Puig-Oracle
          Hi.

          I'm not sure if this would solve the problem given your specific requirements, but you might want to create a (materialized) view combining the two tables and then map the dimension to this view.

          Either that or be creative with the JOIN CONDITION (although I'm not sure this can be done within AWM).

          I hope it helps.

          Joan