Incremental loading of data in Analysis services

Martin Domínguez Brito 26 Reputation points

Incremental online upgrade of database engine to tabular or multidimensional Analysis services database
I need to update my Analysis Services database periodically only the incremental values.
I use the 2019 version of SQL Server Developer

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,167 questions
0 comments No comments
{count} vote

3 answers

Sort by: Most helpful
  1. CarrinWu-MSFT 6,826 Reputation points

    Hi @Martin Domínguez Brito ,

    Welcome to Microsoft Q&A!

    I am not very clearly with question. One SQL Server instance only can install Tabular model or Multidimensional model. If you would like to upgrade SQL Server version, you could download the installer from this link.

    If you would like to incrementally load, you could use the Process Add processing mode. For dimensions, adds new members and updates dimension attribute captions and descriptions. For measure groups and partitions, adds newly available fact data and process only to the relevant partitions.


    For more information, please refer to below links:

    Processing Options and Settings (Analysis Services)
    Incremental Load using ProcessAdd as a TMSL Script

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. CarrinWu-MSFT 6,826 Reputation points

    Hi @Martin Domínguez Brito , thank you for your reply. Because there have some difference between tabular mode and multidimensional model. You were click Process Database in tabular model, and in the Process Database dialog box, there have 4 options. If you click process partitions in tabular model, you will see ProcessAdd. For more information, please refer to below links:

    tabular model: Process database, table, or partition (Analysis Services)
    Multidimensional model: Processing Options and Settings (Analysis Services)


  3. Martin Domínguez Brito 26 Reputation points

    I have already studied a lot about "processing measures, dimensions, etc" and also the use of partitions in Analysis Services Multidimensional. My question is how can I generate a script that only adds the new rows from my SQL Server 2019 database engine and saves them in my dimensional analysis services database. or is it not possible to do it? For your attention, thank you very much.

    0 comments No comments