Approaches to the development of multi-dimensional databases: lessons from four case studies