Page 1 of 1
Data Comparison
Posted: Wed Jun 18, 2014 1:48 pm
by deepakjain2020
Hi All,
I have two cubes having same dimensions, but the order of dimension is not same.
Both cubes have 7 dimensions.
Cube have around 2 million+ records. I want to compare whether both the cubes have same data.
Can someone please let me know is there any way to compare apart from Export data?
Regards,
Deepak Jain
Re: Data Comparison
Posted: Wed Jun 18, 2014 1:57 pm
by jim wood
Why haven't you tried doing a visual comparisum side by side using the cube viewer or are you trying to balance every value? To do so the dimensions would have to be indentical or summarised in some way? Either way isn't a high level visual check good enough?
Re: Data Comparison
Posted: Wed Jun 18, 2014 3:16 pm
by tomok
If the dimensions are truly the same then just configure a view in each cube that pulls data from the highest possible level then compare side by side. You might even consider creating a check total consolidation in each dimension that includes all leafs. You can then use those nodes in your views.
Re: Data Comparison
Posted: Wed Jun 18, 2014 4:58 pm
by deepakjain2020
Will try to work around in that way, but comparing lot of cells side by side seems to be difficult.
Re: Data Comparison
Posted: Wed Jun 18, 2014 5:18 pm
by declanr
deepakjain2020 wrote:Will try to work around in that way, but comparing lot of cells side by side seems to be difficult.
As stated above you can create a single consolidation in all 7 dims that has every leaf as a child. You can create the consols either by TI or manually, either way wouldn't take more than a couple of minutes to do.
Then you end up with 1 cell in each cube to check side by side... all in all a very very easy couple of minutes work.