Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> OT: Star Schema implementation in a front end reporting tool (Business Objects)
I have a star schema with 3 dimension tables (days, policies,
classes_and_flat_charges) and 4 fact (calendar_year_premium,
accident_year_premium, calendar_year_eanred_premium,
accident_year_earned_premium) tables. Each fact table joins to the dimension
tables in the same way. Implementing one fact table with the 3 dimension
tables in business objects is quite simple and works well. If I include the
other facts in the universe then I get loops for which I need a solution. I
have come up with the following and wanted to know what your thoughts on any
of the solutions provided are and how you have implemented similar
situations.
I know this is off topic and appreciate any input. I have tired unsuccessfully finding a good list for business objects related questions so if you know one please let me know.
Ken
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 15 2006 - 14:15:39 CST
![]() |
![]() |