Cube storage location

  • I am just starting to use the Analysis Services and am trying to figure out how and where it stores the files for the cube(s) that have been created.

    Steve Johnson


    Steve Johnson

  • You can specify where Analysis Services stores the files by setting the data folder. Also, you can specify where the temp data folder is located too and you want to make sure this is on a drive with enough free space for processing your cubes. A standard installation will put the data folder in the program files\analysis services\data folder.

    hth,

    Michael

    Michael Weiss


    Michael Weiss

  • Thanks... I looked all over yesterday for this and couldn't find it....

    Steve Johnson


    Steve Johnson

  • Just a quick follow-up note: right-click on the server object in Analysis Manager to access server Properties. Among other things, you will be able to define the data and temp location here. Keep in mind that defining a new data location does not actually move the files - you'll need to do this yourself.

    Scot J Reagin

    sreagin@aspirity.com

    Scot J Reagin
    sreagin@hitachiconsulting.com

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

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