Embed the Edit Succession Plan Deep Link in an Analysis

This example shows how to embed the edit succession plan 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?	Plan ID

To edit a succession plan directly from an OTBI analysis:

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

2. Edit the analysis.

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

4. Save the analysis.

Add a Drill-Down Link

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

2. Go to the Criteria tab.

3. In the Plan 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 Plan.

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=pPlanId=@{PLAN_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	PLAN_ID
    Prompt	Any suitable value, say Plan ID
    Value	Column Value and then select the Plan 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 Plan 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 Plan ID column.

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