Beginner: SSAS database location and file extension


  • I'm SSAS beginner. What is the default location on SSAS OLAP database and what is the file extension of this data file? Is there a log file similar to .ldf from relational database engine?
    Wednesday, February 02, 2011 5:45 AM


  • Default directory of analysis services Data files is 
    C:\Program Files\Microsoft SQL Server\MSAS10.<InstanceID>\OLAP\Data\

    Default directory of analysis services Log files is
    C:\Program Files\Microsoft SQL Server\MSAS10.<InstanceID>\OLAP\Log\

    and you can find all the objects of ssas database in .db file.

    • Marked as answer by jrara Wednesday, February 02, 2011 6:22 AM
    Wednesday, February 02, 2011 6:16 AM