web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / XML for Analysis parse...
Microsoft Dynamics AX (Archived)

XML for Analysis parser: The 'domain\user' value of the 'EffectiveUserName' XML for Analysis property is not valid.

(0) ShareShare
ReportReport
Posted on by Akbarpasha

Hi All,

Getting the below error while running the "Spend by procurement category" report , its data set "DynamicsAXOLAP",  

Error : "XML for Analysis parser: The 'Domain\user' value of the 'EffectiveUserName' XML for Analysis property is not valid."

We have performed the below steps :

1 . Restarted analysis services , reporting services and AOS services, 

we have given the Analysis server name same as AX server name,

Kindly advise us how to resolve this issue.

Regards,

Akbar

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jie G Profile Picture
    Jie G on at

    Hi Akbar,

    This error always occurs if Analysis Services extension is not installed on SSAS server or Business Connector proxy account don't have access to SSAS/OLAP database.

    You can refer to the following link to add the account to Analysis Services.

    docs.microsoft.com/.../grant-server-admin-rights-to-an-analysis-services-instance

  • Akbarpasha Profile Picture
    Akbarpasha on at

    Thanks Ada, We have added proxy account in SSAS database , we are not facing that error now.

    We have recently done SQL migration, we have completed all the changes related to SQL server and database in AX which we know but we are not aware of SSAS setting, we have given AX SQL server name in System administration in "Analysis server" settings .

    We have deployed from Tools-->Business intelligence tools(BI) -->SQL services analysis services project wizard. Processed from SQL server management studio (SSAS database) ,

    while running the "Spend by procurement category" getting the report empty with values in error, please refer the below screen shot :

    report_5F00_error.png

    Kindly advise us how we can resolve this error.

    Regards,

    Akbar

  • Jie G Profile Picture
    Jie G on at

    Hi Akbar,

    Would you please open a new thread for this issue so that you can get more support? As the initial issue in the post has been considered resolved. Thanks for your understanding.

  • Akbarpasha Profile Picture
    Akbarpasha on at

    Thanks Ada, i will raise in another one.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans