OBIEE report using one table

Post date: 06-May-2011 09:06:08

Alias the table for as many dimensions that you need out of the table and use the original as the fact ... join them in the physical layer appropriately and set up your business model as well.

Physicl aliases are ot necessary, you can have only one table in physical layer.

In logical layer, select the fact, duplicate it, then rename and use as dimension.