This content has been marked as final. Show 7 replies
If the table has a prime key then you could alias the table in the physical layer, join the 'two' together and then use one table in the business layer to model aggregations - the fact table, the other for its non-numeric features the dimension table.
iam newbie to OBIEE,can u explain me how to do that pl.
Thanks and Regards
same scenario given to me ,but i dnt know how to do..
If you dont know How to create Alias table right click on Table -->New-->Alias table..create as many alias tables as need to meet your Requirement and use them as Dims and use main table as Fact.
There are 2 ways of doing this. By creating Alias in physical layer or by Duplicating the logical table in BMM.
Here is how you can to do it without creating alias.
1> Import table in physical layer.
2> Make sure primary key is defined. If not, double click the physical table, go to Keys tab, and then create a key. Select Primary key of the table in the columns.
3> Create a new Business Model. Drag and drop this physical table in business model.
4> Duplicate the logical table present in BMM. Now right click both the logical table and create a logical join between them.
5> After creating logical join one of the logical table will become Fact and the other becomes Dimension.
6> Drag the Fact table in presentation layer and use it for reporting.
I'd use method 2 in this post: http://www.varanasisaichand.com/2012/04/fact-and-dimension-from-single-source.html which is effectively a slightly different method from the one mentioned by Maqsood. Instead of copying/duplicating the whole table to be used both as Fact and Dimension, just divide the table up into 2 and put the Dim attributes in one logical table and put the Fact columns in another logical table and then join. That's my 2 cents.