Get ID from Analysis Server cube.

• Leonard Rutkowski

  SSCrazy

  Points: 2668

  More actions

  August 18, 2022 at 3:09 pm

  #4077964

  I am fixing an issue with our automated Analysis Server backups. We use SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS to get the catalog name, and then plug that into our t-sql to do a backup. The script puts the catalog name into the DatabaseID XML for the backup. The issue is, for some of the cubes, the catalog name and the database id are not the same. So, that cube does not get a backup.  We can't rename the cube, and changing the ID is troublesome, so, is there a way to get the database id, using T-SQL? I can use SSMS, and look at the properties, and it shows the ID, but I don't know how SSMS is retrieving that value.

  Thanks,

  Leonard

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 19, 2022 at 3:10 pm

  #4078405

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• October 7, 2022 at 9:55 am

  This was removed by the editor as SPAM