Often I need to verify if the MDX results are correct after I fine tune the query or change the approach.
Usually, I copy and paste the cellset results in Excel and then compare them.
Recently, I got hold of a useful post from Chris Webb where he imported the cellset to a SQL table using SSIS and then used a Tablediff tool to compare the values. If we can make it a application, that would be great but till then, the approach serves the purpose.
You can read the blog here.
Source Click Here.
Post a Comment