1. Using Innovation Management
  2. Create Deep Links to Objects in Reports

Create Deep Links to Objects in Reports

Create deep links to navigate from Oracle Transactional Business Intelligence (OTBI) reports to specific objects. In this procedure, see how you can create a link to idea objects from a report.

Use the Navigator to go to the Reports and Analytics work area. OTBI folders are also accessible from the Reports and Analytics side tab of an idea. Click the Browse Catalog icon to create a report.

  1. To create a report and add fields:

    1. In the Catalog page, from the New menu, click Analysis to create a report.

    2. Select Innovation Management - Ideas Real Time from the Select Subject Area menu.

    3. From the Subject Areas panel, click Ideas. Select and double-click the column names, Idea Name and Ideas ID, to add them to the reports. Other columns and data are optional.

    The Idea ID object doesn't work with a decimal, ensure that you set it to a non-decimal value.

  2. To set a non-decimal value:

    1. Click the Idea ID. From the menu, click the Column Properties option.

    2. In the Column Properties dialog, click the Data Format tab.

    3. Select the Override Default Data Format check box.

    4. Set the value in Decimal Places to a non-decimal value. Click OK.

  3. To configure the name column to be a URL that opens the selected object in another tab:

    1. Click the Idea Name.

    2. From the menu, click the Column Properties option and in the dialog, click the Interaction tab.

    3. From the Primary Interaction menu, select Action Links and create a link format.

    4. Click the + icon to add an action link.

    5. From the New Action Link select Navigate to a Web Page.

    6. In the Create New Action page, add the URL. This creates a web page and passes dynamic values to load the selected object. The template of the dynamic URL is

      https://<hostname>/fscmUI/faces/deeplink?objtype=IDEAS&action=EDIT&objKey=ideaId=<IDEA_ID>

      Note that:

      • the Object Type is Ideas

      • the Action is Edit

      • the Object Key is Idea ID

  4. To define parameters:

    1. Click Define Parameters. The value for the object key is dynamic and the object ID is retrieved from the report data.

    2. In the Values column, in the third row, click the 123 menu, and select Column Value.

    3. From the menu select Idea Details: Ideas ID.

    4. Select the Fixed and Hidden check boxes in all the rows to ensure that the URLs work automatically.

  5. Add the reference to Idea ID in the URL field of the Create New Action dialog after you define parameters.

  6. Click Options to open the Action Options window.

  7. Check the Open in New Window check box and click OK. You return to the Create New Action window.

  8. Click OK. You return to the New Action link window.

  9. Click OK. In the Column Properties window, select the 'Do not display pop-up if only one addition link is available at runtime' check box. This helps when there are multiple action links with different actions. Click OK.

  10. Click Save Analysis to save the report.

  11. Click the Results tab to view search results. If you click one of the links in the search results, the object opens in a new window.

Related Topics