We’re upgrading your documentation experience!
A new doc website is live at docs.openit.cloud — a temporary preview during our transition. This website is now in maintenance-only mode (only critical issues will be addressed).
Explore the new website and send us your feedback!
#
Accessing Analysis Server Web Interface - Cannot open database
#
Problem
There will be times that the Analysis Server web interface is accessed, and the page displays the error, Cannot open database "database_name" by the login. It can be because there was no database created and deployed.

#
Resolution
Follow these instructions to solve the issue:
Using the Analysis Server console application, execute the command (CreateSql):
OpeniT.Server.Etl.Console.exe CreateSqlLet the process finish, then execute the command (CreateOlap):
OpeniT.Server.Etl.Console.exe CreateOlapLet the process finish, then execute the command (DeploySql):
OpeniT.Server.Etl.Console.exe DeploySqlLet the process finish, then execute the command (DeployOlap):
OpeniT.Server.Etl.Console.exe DeployOlapLet the process finish.
Access the web interface again and the home page should be displayed.