SSRS with SSAS – Message with no host or could not find host in AX 2012Continue reading
When running report connected with SSAS users get message “No such host is known” or “A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond <host or IP>”.
Check if host used in OLAP data source exists and there are correct permissions to connect to the host for SSRS and BI users.
Sometimes you will need to change host in OLAP data source. To fix it:
- Open Microsoft Dynamics AX Management Shell.
- Run command: Get-AXReportDataSource -DataSourceName DynamicsAXOLAP| format-list
- Copy the string from “ConnectionString”, change value in property “Data Source=” to your correct SSASServerNme\SSASNamedInstance and run the command: Set-AXReportDataSource -ConnectionString “<ConnectionString>” -DataSourceName DynamicsAXOLAP
- Redeploy reports to SSRS.
The retail industry is still dealing with the effects of the pandemic that lasted almost three years. In addition to this, further global events are causing disruption to the supply chain or financial stability of many retailers globally. As the industry confronts new challenges shaped by economic and geopolitical factors, it also faces trends influenced by changing customer expectations and needs. Here are 5 developments and trends to watch.
An interactive, AI-powered support for sales, customer service, marketing, and supply chain - Microsoft Dynamics 365 Copilot leverages generative AI and natural language processing technology to perform simple, yet time-consuming daily tasks that workload employees but can be automated.
Every company management facing a system change wonders what steps should be taken to ensure that this change does not cause turbulence to its business. Identical dilemmas are faced by any IT company that provides services to implement a new system. I will focus on these dilemmas today.
Artificial intelligence (AI) and machine learning (ML) technologies are changing business every day - just as new tools and services are frequently emerging to expand their use cases. PwC estimates that the impact of these technologies on the global economy will add approximately $15.7 trillion to its value by 2030 (1).