nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Procurement - Buyer Productivity dashboard is not returning data

Pankaj Pandey

Procurement dashboard "/shared/Procurement/Dashboards/Procurement/Buyer Productivity" is not returning any data when we are passing the value for buyer parameter. Although, when running it without passing buyer parameter, it's working. Interesting thing is, when running it with the XYZ buyer which is returned by the dashboard when running it without buyer, its not working for that buyer also.

Can someone please help if you have faced similar issue.

Find more posts tagged with

OTBI

Accepted answers

Bhaskar Konar

Hi @Pankaj Pandey,

Thanks for the details.

Can you please try the second filter like following instead of the existing one to see if there's any betterment.




TRIM(BOTH ' ' FROM "- Buyer"."Purchase Buyer Name")

Thank You!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/64282#Comment_64282

Yes, that's the reason.

Please use the filter like following, it should work fine.




TRIM(BOTH ' ' FROM "- Buyer"."Purchase Buyer Name")

Thank You!

All comments

Pankaj Pandey

Example, when running without passing buyer parameter.

Pankaj Pandey

Example, when passing the buyer parameter. It did not return data.

Passed one of the buyer returned in above example.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24709/procurement-buyer-productivity-dashboard-is-not-returning-data

Hi @Pankaj Pandey,

I tried replicating the issue in my instance but it is working fine for me, i.e. if I pass individual 'Buyer' the dashboard is bringing them accordingly.

This is OOTB content should work fine unless there's any data issue.

Can you check if the 'Buyer' is having any extra space?

Can you try running 'Unprocessed Requisition Lines by Buyer' from Answers? Just filter the report with the parameter that you are passing from Dashboard Prompt and see if it is returning data.

Hope this help.

Cheers,

Pankaj Pandey

@Bhaskar Konar Thank you for checking on this.

I have run the 'Unprocessed Requisition Lines by Buyer' for one of the buyer returned when running it without passing buyer. Please see below result, it didn't return.

Pankaj Pandey

@Bhaskar Konar Also, I checked from backend (per_person_names_f) and yes, I can see one extra space at the end of buyer full name.

Full name: "Moon,Willie B "

Bhaskar Konar

Hi @Pankaj Pandey,

Thanks for the details.

Can you please try the second filter like following instead of the existing one to see if there's any betterment.




TRIM(BOTH ' ' FROM "- Buyer"."Purchase Buyer Name")

Thank You!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/64282#Comment_64282

Yes, that's the reason.

Please use the filter like following, it should work fine.




TRIM(BOTH ' ' FROM "- Buyer"."Purchase Buyer Name")

Thank You!

Bhaskar Konar

Hi @Pankaj Pandey,

Please try the following XML to see if it is returning Data:

XML -- Space Issue.txt

Thank You!

Pankaj Pandey

Since its seeded dashboard do we need to customize it first to modify the individual analysis filters?

What are the steps ? if you could provide it will really help.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/64288#Comment_64288

Hi @Pankaj Pandey,

Yes, you are correct.

Seeded / OOTB folders are Read Only and we can't do any changes for those components inside OOTB folders.

The process normally followed here is creating same folder structure under custom and copy those components that you want to modify.

Once you copied under custom, you can modify those components as per your requirement.

Please note Dashboard components needed to be remapped with custom folder to show the latest reports.

Hope this help.

Thank you!