How to configure default sorting for Portfolio Items Dashboard in PPM 6.0

[Former Member]

Hi,

I am trying to display the recently created Portfolio Item on the top of the list when user navigates to Portfolio Items Dashboard under Portfolio Management tab.

Whenever user creates New Portfolio Item, saves it and return back to the Portfolio Item dashboard the recently created Portfolio item is not show as first record in the list. I tried manually refreshing the Worklist but no change. Is there a place to configure this sorting that will take effect globally.

Thanks

Ravi.

[former_member188458]

Hi Ravi,

Please check the Personalization icon , which you can find on the top right corner of your dashboard .To set the sort sequence  , you can set the sort columns in Sort tab .

Hope this helps.

Best Regards,

Rini

P.S : Please mark the answer as correct as correct/helpful if so.

[Former Member]

hi Rini,

I did check that option but Sort tab has no Created On or Changed On column. I tried adding 'Changed On' field through configuration for RIH Dashboard and then tired selecting the 'Changed On' column in Sort Tab but the column doesn't populated with any value though the backend table has values for 'Changed On'.

I am looking for place where I can change it globally by adding desired field on which I would like to sort on.

My requirement is to see the most recently created Item on top of the list.

Thanks

Ravi.

[former_member188458]

Hi Ravi,

Ideally once you define Field Configuration in SPRO for Dashboard settings it is supposed to fetch the value .

Can you please try to refresh the dashboard to see if the "Changed On/Created On"(added in Field Config for Workarea -WS , object type - RIH) is getting refreshed .

If still an issue I will be able to help once I check the issue in system once I get back to office

after the weekend.

Regards,

Rini

[Former Member]

Hi Rini,

I tired refreshing the dashboard still no change.

I have added field 'D_CHANGED_ON' SPRO-> SAP Portfolio and Project Management -> Portfolio Management -> Global Customizing -> Global Field Settings -> Dashboard Settings -> Define Fields for Dashboards -> Dashboard Fields per Dashboard Type.

Once config is saved and login to portal access Portfolio Management tab, by default the Dashboard for Portfolio Items (RIH) opens, the column for Changed On is blank even after refreshing.

Thanks

Ravi.

[former_member188458]

HI Ravi ,

I checked it in the system by adding the changed on field for Item (Work Area - WS &  object type - RIH) Dashboard in SPRO . And it is working well. i.e. Changed On value is reflected as expected.

Not sure why it is not the same in your case .

Probably you can try to debug and see if the data is getting fetched and moved properly :

You can keep the breakpoint in class -

1) /RPM/CL_WD_ALV_REUSE , method RETRIEVE_ALV_DATA  , at line no 48 , where the below method call is done

CALL METHOD query_dashboard_data

Or you can keep it in below method

2) Class - /RPM/CL_ITEM_D_API , method /RPM/IF_DASHBOARD~RETRIEVE_DASHBOARD_DATA

Hope it helps to resolve your issue.

Best Regards,

Rini

P.S : Please mark the answer as correct as correct/helpful if so.

[Former Member]

Hi Rini,

I did debug as you suggested, when the method /RPM/CL_ITEM_D_API->GET_REQUIRED_COLUMNS is called the column D_CHANGED_ON is not not picked.

It is comparing the columns from structure  '/RPM/ITEM_D' and the configured columns. The structure ' /RPM/ITEM_D' has column RPM_CHANGED_ON where as in configuration it is showing as D_CHANGED_ON. So in the code it is not considering to pick the column 'D_CHANGED_ON'.

Could you confirm the exact field name it shows for 'Changed On' in SPRO-> SAP Portfolio and Project Management -> Portfolio Management -> Global Customizing -> Global Field Settings -> Dashboard Settings -> Define Fields for Dashboards -> Dashboard Fields for 'WS' object Type 'RIH'.

Also I tired implementing BADI /RPM/ITEM_API for the method /RPM/IF_EX_ITEM_API~ALTER_ITEM_LIST where it has changing parameter 'CT_API_ATTRIBUTES'. I tried to sort based on RPM_CHANGED_ON assuming it would sort the dashboard output. But when I debug the value for 'RPM_CHANGE_ON' is not populated in 'CT_API_ATTRIBUTES'.

Thanks

Ravi.

[former_member188458]

Hi Ravi ,

I configured the field "D_CHANGED_ON" only in Dashoboard fields.

From your reply above , do u mean '/RPm/item_d' structure doesnt have "D_CHANGED_ON" ,

that is the only case I see when the Move-corresponding shouldnt work.

I would have to check in the system what the GET_REQUIRED_COLUMN method is doing to understand your issue .

Will check the same and will let you know.

Regards,

Rini