Hi all

I have a very huge case database with me

The case database contains
Case info - caseid, caseno and name
Vehicle Info - vehicleid, caseid, vehicle name etc
Occupant Info - occupantid, vehicleid, occupantname etc

How to form cubes and dimensions on the above entities. How to give BI info on the above data.