Drill down from OTBI adhoc reports to PPM

mickel rmeily

Dear All

How can I extract the drilldown hyperlink from PPM to OTBI ? I need the page that show the project financial settings structure

Regards

Nathan CCC

Hi, What link in PPM? Where is the link? What in OTBI do you wish to link to? Possibly you mean the other way? From OTBI to a page in the application? If so, in one of your analysis, select analysis, select Edit, select Criteria, on the presentation column with the link, select column properties, select Interaction, on an action link select Edit Action Link, then select Edit Action. The link is in field URL. For example, in this case using subject area "Projects - Cross Subject Area Analysis - Real Time", to go to a page in projects https://xxx.oraclecloud.com/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=ProjectId=@{3} where parameter 1 is value PROJECT 2 is value OVERVIEW or MANAGE_FIN_PLAN etc. and 3 is column "Project"."Project Key". You can go to work area Deep Links in Tools to view a list of deep links.

Nathan CCC

Hi, or is it you want to know the path in the OTBI catalog that someone has entered when they added something to the list in tab Reports and Analytics on a work area such as Project Management.

If you select More rather than View it will go to the object in the catalog showing you the path.

mickel rmeily

Dear @Nathan CCC

Thank you for your help

I just want to link the column project Number to the subledger

inside this window we have plenty of project so when the user click on the project number he should find himself inside that window

and if we can reach this step i would be better

Regards

Mickel

Rich Merkel

Hi,

I would suggest looking at this documentation:

https://docs.oracle.com/en/cloud/saas/project-management/23a/fapca/deep-links-for-project-management.html#s20076969

mickel rmeily

Dear @Rich Merkel

Thank you so much for the link it's helpful but I am not able to create my link

do you mind if u can just put the link of project overview and I add the identifier before /fscm ?

Regards

Mickel

Rich Merkel

Hi,

Please see attached archive file. Use this as example

Two columns in query: (Using Projects Cross Subject Area)

Project Number Formula: "Project"."Project Number"

Project ID: CAST("Project"."Project Key" as CHAR)

^^For above note you can hide this column in your output as in the example.

In order to edit the drill down URL, click on column properties for project number -> interaction -> edit action link

Then click on the arrows and select edit action

Then replace hostname below with URL of your server. Click ok, save/etc.

Good Luck!

Project Deep Link to Overview.zip