Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Sep 25, 2012 7:31 PM by
Need help in creating alias table, apart from using same table again.
Sep 21, 2012 12:39 AM
I have one problem in which one fact has many wid's and these all fact wid's connect with the single dimension.
As per me I can create alias of the dimension and join them with fact.
x1-wid joins with xx1 wid of dimension1
x2 wid joins with xx2 wid of dimension1
x3 wid joins with xx3 wid of dimension1
as per me we can we can create the alias of dimension 1 and join with them.
But it will take time, is there any other way to achive it kindly suggest.
This content has been marked as final.
Show 1 reply
Re: Need help in creating alias table, apart from using same table again.
Sep 25, 2012 7:31 PM
in response to
Your question looks like Oracle BI-Apps question.
Please post it here: https://forums.oracle.com/forums/category.jspa?categoryID=147