Compare SSAS xmla with bim in BISM normalizer

Arun Kumar 41 Reputation points
2021-11-23T04:52:40.333+00:00

Hi,

I have code in xmla and .bim format. I need to compare both using BISM and merge/update the codes. But BISM is not recognizing bim format in source or target. Is there a way to do it? Do i need to convert the bim format to xmla or viceversa?

Thanks,
Arun

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,231 questions
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,836 Reputation points
    2021-11-23T06:19:28.517+00:00

    Hi @Arun Kumar ,

    Thanks for your posting.

    Based on my researched, BISM Normalizer can recognizing Model.bim file in source or target. And you could right click the Model.bim file to view code, you will see the Model.bim file was written by Json. You cannot compare XLMA and Json using BISM normalizer. For more information, please refer to How to use BISM Normalizer and BISM Normalizer: Version 5.0 Released!

    Best regards,
    Carrin


    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.


0 additional answers

Sort by: Most helpful