2016-06-30
SSRS with SSAS – Message with no host or could not find host in AX 2012

Step 1
Check if host used in OLAP data source exists and there are correct permissions to connect to the host for SSRS and BI users.
Step 2
Sometimes you will need to change host in OLAP data source. To fix it:
- Open Microsoft Dynamics AX Management Shell.
- Run command: G
et-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.
See more

AGA pomaga – poznaj inteligentnego asystenta do przetwarzania zapytań ofertowych: ANEGIS Generative Assistant

Jak z pomocą narzędzi Power Platform, Microsoft Fabric i AI zrealizować plan na cyfrową transformację? ANEGIS Power Center

Obowiązkowy KSeF startuje za 4 miesiące! Umów się na bezpłatne konsultacje i przygotuj swój system na zmiany
Looking for a Microsoft partner? Let's talk about your project
Work with a team that has delivered implementations and projects for dozens of companies. Schedule an introductory call and see:
How to tailor Dynamics 365 to your company's processes, rather than the other way around
Which areas are worth automating to save time and reduce costs
Here is the step-by-step implementation process with Anegis: from analysis to post-launch support
Dziękujemy za wiadomość!
Oops! Something went wrong while submitting the form.

