Embed the Edit Talent Pool Deep Link in an Analysis

This example shows how to embed the edit talent pool deep link in an Oracle Transactional Business Intelligence (OTBI) analysis.

This table summarizes key decisions for this scenario.

Decisions to Consider	This Example
What type of URL should I embed?	Standard Deep Link URL
For which column should I add an interaction?	Pool ID

To edit a talent pool directly from an OTBI analysis:

1. Create an analysis that includes the Pool ID as a column.

2. Edit the analysis.

3. Add a drill-down link for the Pool ID column.

4. Save the analysis.

Add a Drill-Down Link

1. Edit an existing analysis that has the Pool ID attribute as a column.

2. Go to the Criteria tab.

3. In the Pool ID column, click Settings > Column Properties.

4. Click the Interaction tab.

5. Select the values indicated in this table.

   Field	Value
   Primary Interaction	Default (Drill)
   Value	Action Links

6. Click Add Action Link.

   You see the New Action Link dialog box.

7. In the Link Text field, type Edit Pool.

8. Click the Create New Action icon.

9. Select Navigate to a Web Page.

   You see the Create New Action dialog box.

10. Enter URL in this format:

    https://<hostname>/fscmUI/faces/deeplink?objType=SUCCESSION_PLAN&action=EDIT&objKey=pPoolId=@{POOL_ID}

11. Click Define Parameters.

12. Add a new parameter.

13. In the third row, specify the values shown in this table.

    Column	Value
    Name	POOL_ID
    Prompt	Any suitable value, say Pool ID
    Value	Column Value and then select the Pool ID column

14. Select the Hidden check box for all the rows.

15. Clear the Optional check box for all the rows.

16. Click Options.

17. In the Action Options dialog box, select the Open In New Window check box.

18. Click OK to close the Action Options dialog box.

19. Click OK to close the Create New Action dialog box.

20. Click OK to close the New Action Link dialog box.

21. In the Column Properties dialog box of the Pool ID column, click the Data Format tab.

22. Select the Override Default Data Format check box and then specify the value for Treat Number As field as Number.

    Note: You need to override the default data format only for the Pool ID column.

23. Click OK to close the Column Properties dialog box.