Single table model which is very much possible with OBIEE. FACT Table is NOT mandatory in Physical Layer.
In your case you have 5 dimension tables...Let me pick 1 table as an example.
1) Import that dimension table in physical layer and no need to join it with any other table in physical layer.
2) Drag this table to BMM layer as a new Logical Table say Dim1
3) Create a new Dummy Logical table say Fact1. Drag a single column from physical table to this Dummy Fact say 'Users'
4) Select Dim1 & Fact1 and apply a complex join (logical join) from Dim1 to Fact1 (1-M). You Dummy Fact will turn yellow in color to represent it as Fact table which is identified by OBI Server.
5) Now, just drag the Dim1 from BMM to presentation layer and upload the repository.
Once above steps are completed, you are good to start reporting on Dim1.
Hope this is useful for you to understand...Also, you may refer OBIEE SA System Subject Area for reference which uses just a single table RPD modeling.
http://oraclebizint.wordpress.com/2008/04/25/oracle-bi-ee-101332-sa-system-subject-area-autoloading-profiles-and-bursting/
Until Next Post... :)
No comments:
Post a Comment