Patent Document ID: 20110246415
Application ID: 13032681
Patent Status: 0

Claim One:
1. A method for validating data, said method comprising: a processor of a data processing system generating warehouse data in a data warehouse by transforming source data in a data source into the warehouse data via an Extract-Transform-Load (ETL) transformation model; said processor generating a data cube by transforming the warehouse data in the data warehouse into the data cube via an On-Line Analysis Processing (OLAP) transformation model; said processor generating a report multi-dimensional data set (MDS 1 ) from the data cube via a data cube query of the data cube; said processor generating a reference multi-dimensional data set (S) from the source data via a source data query of the source data, said source data query corresponding to the data cube query; and said processor determining whether MDS 1 matches S; wherein if said determining whether MDS 1 matches S comprises determining that MDS 1 does not match S, then the method further comprises said processor performing an OLAP inverse transformation on MDS 1 to generate an OLAP multi-dimensional data set (MDS 2 ) and said processor determining whether MDS 2 matches S; wherein if said determining whether MDS 1 matches S comprises determining that MDS 1 does not match S and said determining whether MDS 2 matches S comprises determining that MDS 2 does not match S, then said processor performing an ETF inverse transformation on MDS 2 to generate an ETL multi-dimensional data set (MDS 3 ) and said processor determining whether MDS 2 matches MDS 1 and said processor determining whether MDS 3 matches S; wherein if said determining whether MDS 1 matches S comprises determining that MDS 1 does not match S and said determining whether MDS 2 matches S comprises determining that MDS 2 does not match S and said determining whether MDS 3 matches S comprises determining that MDS 3 does not match S, then said processor determining whether MDS 3 matches MDS 2 .