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

SSAS Change Management Expand / Collapse
Author
Message
Posted Tuesday, October 1, 2013 8:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 14, 2014 1:44 PM
Points: 19, Visits: 158
Not sure if this is the correct place to post this but I am looking to see if there is any where I can get a listing of objects on a SSAS database and at the very least a last changed date and or created date? I know on the database engine in the master database the SysObjects table has this information for each database on the server. Does anyone know where something like this is in an SSAS database? any help is greatly appreciated.
Post #1500643
Posted Wednesday, October 2, 2013 5:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
Just like the DB Engine, SSAS contains several DMV's you can query for this kind of data.
As a starter open a DMX Query window and run:
SELECT * FROM $System.DBSCHEMA_CATALOGS
SELECT * FROM $System.DBSCHEMA_TABLES

For more information about SSAS DMV's see http://msdn.microsoft.com/en-us/library/hh230820.aspx


Markus Bohse
Post #1500739
Posted Saturday, October 5, 2013 2:25 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 14, 2014 1:44 PM
Points: 19, Visits: 158
Awesome, thanks Markus. I will check that out
Post #1501860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse