Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Check measures across Analysis Services DBs Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 8:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 2, 2014 2:26 AM
Points: 1, Visits: 389
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.


Post #1430181
Posted Thursday, March 14, 2013 10:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
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
Post #1431120
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse