Can't have a bug-free BI system

In BI reporting environment, especially if it reports on global and regional level, there are a number of report designs and modeling techniques that needs to be considered as to prevent future pain of spending many man days and time to fix them. Most of the issues arises from frontend such as data binding in web template and incorrect variable applied in the Bex queries. The bigger issues lean towards the data standardization or cleanliness of master data across all the SAP and non-SAP feed systems. In order to consolidate the figures for global reporting, the master data has to be compounded to its source system or a single set of master data to be agreed upon from different regional master data management as the global standard. BI standards and governance play a major role here all the way from standardizing the infoobject (and its attribute),hierarchies and mapping DSO/table contents as they are the baseline for the accuracy of data churn out from the ETL layer into reporting display.There is no escape from having to perform multiple data reload or self-transformation whenever there is a change in one of those object. The always changing business process requires snapshots reporting and this introduce complexity in term of time dependence and versioning of master data and hierarchy.