comparing 2 tabular models for differences

Fra1978 126 Reputation points
2021-01-13T22:14:15.133+00:00

I have 2 tabular models, I was trying to consolidate them into 1 (I can see most of the dimensions are repeated on both.)

I don't want to miss less visible stuff like calculated columns or roles that the model might have... Is there a way of comparing 2 tabular models and highlight the differences in the models? Or at least some solution where I can export all of it and compare it perhaps with lookups in excel?

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,249 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Darren Gosbell 1,466 Reputation points
    2021-01-14T03:42:01.837+00:00

    The ALM Toolkit should be able to do this for you http://alm-toolkit.com/

    0 comments No comments

  2. Nandan Hegde 29,901 Reputation points MVP
    2021-01-14T04:26:50.16+00:00

    Hey @Fra1978 ,
    There are multiple ways to compare 2 tabular models:

    1) You can use DMV queries to get the cube meta data and compare them in Excel :
    https://bennyaustin.com/2011/03/01/ssas-dmv-queries-cube-metadata/

    2) Export the TMSL script or code of the tabular models and compare them via text compare :
    a crude way in case if both the models are too much different

    Hope this is what you were expecting :)

    0 comments No comments

  3. Lukas Yu -MSFT 5,816 Reputation points
    2021-01-14T05:45:13.71+00:00

    Hi,

    There is free opensource tool that you can use in VS to achieve the comparison, check here : BISM Normalizer -Database compare

    Regards,
    Lukas


    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November


  4. Mehshan Ansari 1 Reputation point
    2022-06-08T02:57:15.517+00:00

    You can compare 2 tabular models in Visual Studio with TFS using 'Compare with workspace version' . It provides a complete line by line diff report.

    0 comments No comments