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) / Procurement and sourci...
Microsoft Dynamics AX (Archived)

Procurement and sourcing "spend Analysis" reports

(0) ShareShare
ReportReport
Posted on by Ludwig Reinhard 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    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 on at

    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 49,438 User Group Leader on at

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

  • Community Member Profile Picture
    Community Member on at

    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

  • New_user_FS Profile Picture
    New_user_FS 5 on at

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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

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