question

00chrispierce00 avatar image
0 Votes"
00chrispierce00 asked 00chrispierce00 commented

SCSM 2019 - Rebuild SSAS?

Hello,

Yesterday, we changed the collation for our Analysis Services database (from "Latin1_General_100_CS_AS" to "Latin1_General_100*CI*AS").

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

120516-image.png


msc-service-manager
image.png (35.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AndreasBaumgarten avatar image
0 Votes"
AndreasBaumgarten answered 00chrispierce00 commented

Hi @00chrispierce00 ,

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you. I was afraid that might be the case.

0 Votes 0 ·