Error while executing reports in the SPM UI

[Former Member]

Hi,

We try to run an OOB report "Spend by Supplier". After report generated, tried to add few more dimensions Source system supplier and Category to the same report.

After the report started, it gave an error massage.

Error message states that

"Dimension(s) in result do not match query - report execution aborted"

Kindly suggest how resolve this issue.

Regards,

Alaap

[Former Member]

Hi Alaap,

Seems like there is some problem with you BW query. Please try and run the 'Spend Analysis Final Query' in BEx first to see if you get the same error or may be you get more details as to what the problem is.

Depending on how much data you have in your system, you may not be able to execute the default query. In this case please create a copy query with only the necessary dimensions & measures (characteristics & key-figures) and execute that to test.

Regards,

Rohit