Dumping Out SSAS Settings

Question

Dumping Out SSAS Settings

imani_technology

SSCrazy Eights

Points: 8200
More actions
August 19, 2016 at 11:31 am

#146158

Is there an easy way to document and export the various SSAS server settings?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

PB_BI SSCoach Points: 17463 More actions · Answer 1

Your settings are all in a file called MSMDSRV.INI which will be located in the location specified in the DataDir property on your AS instance. As for documenting it, it's just an XML file so you can query it whichever way is most comfortable for you and use the output as your documentation.

I'm on LinkedIn

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 2

Thanks, but I can't find the item in the specified directory.

PB_BI SSCoach Points: 17463 More actions · Answer 3

It should be in a folder called Config in the Datadir location.

I'm on LinkedIn