locked
Processing SSAS Tabular Model Automatically RRS feed

  • Question

  • Hello,

    Please how can i automatically update my tabular model in the future when there's an update in my database.

    Thanks


    me

    • Moved by Tom Phillips Thursday, October 18, 2012 7:58 PM SSAS question (From:SQL Server Database Engine)
    Thursday, October 18, 2012 1:00 PM

Answers

All replies

  • To automate tabular models you can use AMO with C#, VB or powershell:

    http://tabularamo2012.codeplex.com/


    MVP MCT MCTS Daniel Calbimonte

    http://elpaladintecnologico.blogspot.com

    • Proposed as answer by Elvis Long Tuesday, October 23, 2012 9:42 AM
    • Marked as answer by Elvis Long Friday, October 26, 2012 5:32 AM
    Friday, October 19, 2012 6:23 PM
  • This can be planned as:

    • Maintain a log table with a staus value (Update Pass or Update Fail) for the database when ETL is scheduled
    • Schedule a SQL Agent to begion Process (Full/Add) on the model only when the latest entry in the log table is = Update Pass, else wait and poll again after a definte period.

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Friday, October 19, 2012 6:54 PM
  • Hi,

    You can create a SSIS package in which there is an Analysis Services Processing Task that will automatically process the SSAS tabular model .As simple as that.You can run this package either manually after an update or you can schedule a SQL job that runs at a predefined time daily based on your scheduled ETL

    (Though it may be too late for a reply to be helpful for the said user,I have replied regardless of it.So people who come across same/similar question can implement it) Hope it helps.

    Thursday, December 5, 2013 7:04 AM
  • Thanks

    Thanks Shiven:) If Answer is Helpful, Please Vote

    Thursday, August 6, 2015 5:07 AM
  • Ssas 2016 tabular model this is not working. Error message storageengineused set to tabularmetadata. For database this mode, you must use tabular APIs
    Friday, February 17, 2017 8:18 AM
  • Thanks!
    Thursday, April 25, 2019 1:04 PM