How to Programmatically generate .asdatabase from SSAS database from SSAS server?


  • Is there a way to  Programmatically generate .asdatabase file and other ssas config files from SSAS database? Not by devenv .dwproj. 
    Thursday, April 03, 2014 2:15 AM

All replies

  • Hi Jackie,

    The .asdatabase file was not on the Analysis Services serer, so we cannot get it from SSAS server. This file is available when you run a Build on your Analysis Services project in SQL Server Data Tools. You can find it in the bin folder in the location where your project is stored.

    If I have anything misunderstood, please point it out.

    Charlie Liao

    If you have any feedback on our support, please click here.

    Charlie Liao
    TechNet Community Support

    Thursday, April 03, 2014 7:10 AM
  • Thank you very much for your answer. 

    I know how to generate the asdatabase: (I can do it by devenv.exe  project.dwproj or build the ssas project manually).  How ever I want to programmatically generate .asdatabase by C#.

    I programmatically did some modifications on the SSAS database(drop some dimension and measures),  then I want to generate .asdatabase so that i can deploy it to the server. I know i can do it by xmla as well.  But I really like deploying the cube by .asdatabase, not xmla. Any thoughts?



    Thursday, April 03, 2014 8:17 AM