Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Procurement and sourcing "spend Analysis" reports

Posted on by Microsoft Employee

Hi,

I setup a new company account, modified the existing purchase categories, posted some transactions (purchase orders) togehter with the categories and tried to run the spend analysis reports in the procurement and sourcing module. Unfortunately, these reports seem not working properly as they do not pick up my new company accounts that I setup and the transactions that I posted .

Does anybody have a tip for me on what to do?

Thanks,

ludwig

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Procurement and sourcing "spend Analysis" reports

    Hi,

    Have you processed the AX standard cubes? Once they are processed and provided that you have transactions recorded you should be able to see some data.

    Beat regards

    Ludwig

  • New_user_FS Profile Picture
    New_user_FS 5 on at
    RE: Procurement and sourcing "spend Analysis" reports

    hi Udit, Shoaib, just wondering anyone of can help me. wanted to generate the procurement spend report. got blank report.  am I missing anything?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Procurement and sourcing "spend Analysis" reports

    Hi Sohaib,

    Yes, that we have already tried and is working fine. I have handed over this issue to my technical team they are further debugging.

    Regards

    Udit Dhawan

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Procurement and sourcing "spend Analysis" reports

    Have you tried by executing your MDX query in SSAS Browser?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Procurement and sourcing "spend Analysis" reports

    Hi Sohaib,

    Thanks for your revert.

    Legal entity is same. I just change category hierarchy type and also process the cubes after that.

    Regards

    Udit Dhawan

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Procurement and sourcing "spend Analysis" reports

    If this is a newly created legal entity, please make sure to process SSAS cubes at least one. Usually the cubes are scheduled to process automatically, after specific intervals. Otherwise manual processing is required.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Procurement and sourcing "spend Analysis" reports

    Hi Ludwig,

    I am facing same issue, not able to generate any spend analysis report in procurement module. All showing blank reports with no data. 

    I changed the category hierarchy type with new hierarchy and assigned new categories to items. I have also done some transaction with new category through purchase order.

    Also i have redeploy cubes and process it again and able to browse and see data in SQL.

    Could you please assist me if you have some solution.

    Regards

    Udit Dhawan

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans