Recently we were investigating the options to resolve the particular analysis requirements of a customer to combine well defined data held in BW with more ad hoc data from various sources. This wasn’t the first time I have come across this issue. It is a problem that has been around since the inception of Data Warehousing. Systems such as SAP BW were created specifically to centralise, homogenise and standardise data, to provide an efficient and consistent analysis view. Data warehouses also drive good data governance and security, so this gives great control of data from an IT viewpoint. Our requirement however, involves the opposite; namely de-centralisation, de-standardisation and control being passed to particular individuals or non-IT departments.