SCSM 2019 - Rebuild SSAS?

Question

Hello,

Yesterday, we changed the collation for our Analysis Services database (from "Latin1_General_100_CS_AS" to "Latin1_General_100CIAS").

As a result, the 'Cubes', 'Data Source Views', and 'Dimensions' were all deleted.

What is the quickest/best method to rebuild/reinstall the SSAS portion of the Data Warehouse?

thank you,
Chris

Answer 1

Hi @Chris.Pierce ,

as far as I know there is no option to install/re-install just the SSAS part of the SCSM DWH.

I am only aware of 2 options:

• Restore a backup of SCSM DWH
• Uninstall/Re-install the full SCSM DWH

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten