Check measures across Analysis Services DBs

• yeungz

  Valued Member

  Points: 65

  More actions

  March 12, 2013 at 8:11 pm

  #291041

  Currently I have 12 Analysis Services DBs that schedule to update every month. (They are all the same hierarchy/Structure).

  After the monthly update, I will check the job status and run a mdx query to check the Measures for every databases.

  (paste the query -> select databases -> run the query -> eye ball checking -> Loop 12 times...)

  Any suggestion to check measures across DBs in more efficient way instead of manually run the query 12 times??

  Thanks.

• Mackers

  SSCrazy

  Points: 2935

  More actions

  March 14, 2013 at 10:47 am

  #1597139

  Use SSIS and loop through the databases running this MDX and feed the data into a table.

  Then do the comparison in SQL Server

  Mack