Modifying SSAS Tabular project through AMO RRS feed

  • Question

  • I am referring to working against a SSAS tabular project (model.bin file etc) and being able to modify the project through AMO, not referring to modifying a tabular database directly.

    Can I add hierarchies, change the sort column, hide columns etc and do it faster (and automated) than using Visual Studio 2012 interface using AMO. Can I connect to an existing visual studio project using AMO or AMO can only connect to a database?

    If AMO does not connect to an ssas tabular project is there any other way of modifying the project (model.bim). Today what I do is (I have to rebuild the whole project twice few times a week and the project has about 250 dimensions and 2 large fact tables, there is no problem with browsing performance but working with visual studio is very slow) modifying the xml with bunch of xqueries I wrote, to hide almost 500 columns change the sort order over 200 dimensions and similar stuff. I was wondering if there is another standard and efficient way of doing this?

    Thank you

    Gokhan Varol

    Friday, August 23, 2013 12:58 AM


  • Hi Gokhan,

    We can only use SQL Server Data tool to create a new, blank tabular model project. After creating a new tabular model project, we can begin model authoring by using the tabular model designer tools and wizards.

    However, we can use Tabular AMO or Tabular Database PowerShell Cmdlets to manage Tabular models. Here are some articles for your reference, please see:
    Tabular AMO 2012: http://tabularamo2012.codeplex.com/
    Tabular Database Powershell Cmdlets: http://tabularcmdlets.codeplex.com/

    I think you encountered the bad performance when you design the Tabular model by using SSDT tool. I would recommend you submit a wish to the Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

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

    Best Regards,

    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Monday, September 2, 2013 1:45 AM
    Monday, August 26, 2013 6:20 AM