Post reply

Record count/hash compare

  • August 8, 2013 at 3:31 am

    #296775

    Hi guys, have any of you ever put a structure/solution in place so you can audit a cube? Being able to reconcile between source, stageing,DW and finally the cube.

    If so how have you done it?

    My thoughts so far, take measure counts from the cube. These will be totals for entire cube for each measure.

    Then for each measure, get the corresponding values from the DW and Staging.

    Has anyone done something similar? is there anything i need to be aware of?

    Is there any example code I can have a look at?

    thhanks guys.

    Ian Cockcroft
    MCITP BI Specialist

  • August 8, 2013 at 3:42 am

    #1639660

    What I usually to is create a quick analysis in the cube browser, and then recreate the same data in SQL. (the ROLLUP function can be useful to calculate totals and subtotals).

    It's quite time-consuming, especially if you have a lot of logic in the cube.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply