SSAS Server Properties: AllowedBrowsingFolders

Way back when I started this blog I wrote about a few of the SSAS server properties, and today I’m revisiting this subject tot talk about the AllowedBrowsingFolders property.

This property is not immediately available as you need to click the “show advanced (all) properties” tick box to see it (as an aside I’m never sure why some of the options are hidden from you in this manner.)

2014-03-18 10_37_03

The folders that you fill our in this property specify which folders you can browse when saving files, opening files, and browsing files in Analysis Services Backup, Restore, PartitionProperties, and Synchronization dialog boxes.

2014-03-18 10_47_07

The info box on the browse dialog boxes even tells you about this property. Crucially it misses out the bit about it being an advanced property.

To specify more than one folder, use the pipe separator ( | ) in between each folder directory. The account running the SSAS must have read/write permissions, and also does not check the validity of the path. So it’s possible to enter an incorrect path, or a path that the account does not have permissions to, and for the property to be updated only for the actual error not to occur until someone attempts to browse to the folder.

If you totally mess up the path and cannot restart the instance then you will need to get your hands dirty and edit the msmdsrv.ini file. By default this is located in the directory path “C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config”. Right at the top of the file there you can see the key value pair


It’s an odd little config this one as most people assume that this list is populated form the backup/data/log properties, but being totally separate makes sense, especially with the synchronize option.

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

One thought on “SSAS Server Properties: AllowedBrowsingFolders”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s