SSAS 2016 Database Recreation

Rajesh Paruchuri 1 Reputation point
2022-06-28T15:56:06.257+00:00

I scripted an existing database with cube and a bunch of dimensions. After deleting the existing database, I tried to run the create statement I scripted prior to dropping and it throws me an error Database doesn't exist.

215780-image.png215806-screenshot-2022-06-28-105243.png

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.
999 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 25,721 Reputation points
    2022-06-29T05:39:54.853+00:00

    it throws me an error Database doesn't exist.

    And, do the SSAS database exists?


  2. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2022-06-29T06:26:38.483+00:00

    Hi @Rajesh Paruchuri ,
    Square brackets around the catalog name in an XMLA query will cause the error to occur. See more: Analysis Services (SSAS) Error when Executing Query - User does not Have Access or Database does not Exist.
    Best Regards,
    Joy


    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.