What I have noticed that for the portlets, whose datasource query is having the outerjoins or not having the group by condition; in these portlets the PORTLET_MAX_ROWS_RETURNED parameter is not working.
I have tested this in PPM v 7.1. May be this is the tool limitation.
To avoid such scenario, include any group by condition and avoid usage of outerjoin.
Cheers.. Utkarsh Mishra
-- Remember to give Kudos to answers! (click the KUDOS star)
my understanding is that if you are trying to group rows then return results - this won't necessarily work. You have to pull all results, group them as needed, then pull the 200 or whatever number from that new grouped dataset. If I just pull the top 200, it may pull 200 but it will only group the 200 I pull which might mean I'm leaving the correct data out. This has been my experience at least.