Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Oct 8, 2012 9:56 AM by Joan Puig-Oracle
olap star schema design
Oct 8, 2012 7:52 AM
i have two dimention tables like source_ip and dest_ip in db how do i can combain them as single dimention in awm
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: olap star schema design
Oct 8, 2012 9:56 AM
in response to
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.