August 8, 2013 at 3:31 am
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
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