SSIS job to check if SSAS cubes are working
Hi all, I am having some management problems and need to prove that the cubes are available for browsing. I have had a look at SSIS to see if there is a task but I suspect I need to script something out. Can anyone give me any pointers ? Many thanks.
October 22nd, 2010 3:45pm

YOu can use the Analysis Services Execute DDL task, with some non-destructive XMLA, like getting a list of databases on the server: <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> <RequestType>DBSCHEMA_CATALOGS</RequestType> <Restrictions /> <Properties /> </Discover> John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 3:52pm

Thanks John. Is it possible to check when a cube was last processed ? I want to be able to write this out to sql table (cube name and proccess date) TIA
October 22nd, 2010 7:45pm

SELECT CATALOG_NAME, CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBESJohn Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 7:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics