This discussion is archived
1 Reply Latest reply: Oct 8, 2012 2:56 AM by Joan Puig RSS

olap star schema design

966768 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points