Data Comparison

[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

[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?

[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.

[deepakjain2020]

Will try to work around in that way, but comparing lot of cells side by side seems to be difficult.

[declanr]

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.