6 Replies Latest reply: Oct 12, 2011 12:41 PM by Vimal Gasper RSS

SPM - Spend by Buying Organization

Prasanna Rangaraju
Currently Being Moderated



We have SPM 2.1 SP6 Patch 3. We have loaded data and also have hierarchies created.


When we try a new report with Buing Org and Spend, then we get a report with "Unassigned" and a a total value. The report just has only one line. Even though we have loaded all buying org, the report doesnt show spend for individual buying orgs.


Is DSE mandatory to have a report with Buying otg as dimension?




  • Re: SPM - Spend by Buying Organization
    Divyesh Jain
    Currently Being Moderated

    Hi Prasanna,

    By default the buying organization dimension has hierarchy enabled. Since no hierarchy exists in the system you see not assigned. You need to either create hierarchy if you have the data for that or change the dimension in query designer to not have hierarchy.


    Please note that if you remove hierarchy OOTB reports for buying org will not work since they assume hierarchy. But the new reports will work.


    Best Regards,