I am doing crime analysis data warehouse implementation. I had done the tables but I am stuck with the measures...What I want is not answer....The logic How to think? There is 7 tables ; Fact table is Crime, Dimension tables will be Officer, Victim, Offender, Time, Location, case. I plan to use Location, case and time (Cube). I dont know whether the view is correct or not...For example; Chief officer - How many crimes happen by location/time. No of prosecuted case/closed case. Highest crime case/highest crime rate Officer - Which police officer prosecuted the case? similar offenders/victim for cases?.I know control files, data files and all, but can u suggest me how to implement script for report?
Submit an article or tip