Abstract: A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. Whether MDS1 matches S is determined. If MDS1 doesn't match S, then an OLAP inverse transformation is performed on MDS1 to generate an OLAP dataset (MDS2) and whether MDS2 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S, then an ETF inverse transformation is performed on MDS2 to generate an ETL dataset (MDS3) and whether MDS2 matches MDS1 and whether MDS3 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S and MDS3 does not match S, then whether MDS3 matches MDS2 is determined.

Abstract: A method and program product for automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model (UIAM). A Multidimensional Expressions (MDX) query is generated based on a user visit to a business intelligence application. Based on initial user visit(s), a cube-based UIAM is constructed by including a representation of a first set of user interest(s) in a first set of UIAM item(s). The cube-based UIAM is transformed into a data warehouse-based UIAM. Based on subsequent user visit(s), UIAM items are updated to represent a second set of user interest(s) and UIAM item scores are adjusted to specify how frequently and recently user interests are indicated by the user visits. An update of data in the data warehouse is detected. Reports representative of user interest(s) represented by the updated UIAM items having the top k scores are generated.

Abstract: A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. Whether MDS1 matches S is determined. If MDS1 doesn't match S, then an OLAP inverse transformation is performed on MDS1 to generate an OLAP dataset (MDS2) and whether MDS2 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S, then an ETF inverse transformation is performed on MDS2 to generate an ETL dataset (MDS3) and whether MDS2 matches MDS1 and whether MDS3 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S and MDS3 does not match S, then whether MDS3 matches MDS2 is determined.