Reporting and Analytics for Sales

Get Involved. Join the Conversation.

Topic

    Mohammed Rafi
    Drill Down to Opportunity
    Topic posted October 7, 2019 by Mohammed RafiBlack Diamond: 60,000+ Points 
    60 Views, 11 Comments
    Title:
    Drill Down to Opportunity
    Content:

    Hi,

     

    I have created report for Opportunity and once drilled down I would like to open the Opportunity Page to view entire details of an Opportunity.

     

    How can this be done kindly guide

     

    Thanks

    Comment

     

    • Mihaela M

      Hi,

      You need to use Deep Links for this. They enable to drill down from a BI page to an application page using proper context. In general the format of deep link is:
      https://[hostname:port]/[Application]/faces/CrmFusionHome?cardToOpen=[CARD]&tabToOpen=[TAB]&TF_[Object]Id=[12345]&TF_subTabName=[SUBTAB]

      You need to use proper link for object in question and page needed.

       

      • Mohammed Rafi

        Thanks Mihaela

        Where do I need to specify the deep link do you have any document ID with an example to share

        • Mihaela M

          Hi, 

          You can find details in https://docs.oracle.com/en/cloud/saas/engagement/19b/facaa/analytics-on-interfaces.html#FACAA2251149 

    • Dimple Nagesh

      Hi Rafi,

          Open the BI report > Navigate to Criteria Tab > Select the Opportunity column from which you are trying to navigate > Edit Column properties > Interaction > Values > Select Action Links > Click on + and create a new Action link > Navigate to the Web page > Paste the formed URL > Click on define parameters

      https://xxxxx.oraclecloud.com/sales/faces/CrmFusionHome?cardToOpen=MOO_OPPTYMGMTOPPORTUNITIES_CRM_CARD&tabToOpen=MOO_OPPTYMGMTOPPORTUNITIES_CRM&TF_skipToEditOptyId="Opportunity"."Opportunity ID"

      Now edit the third parameter as Column Value and select "Opportunity"."Opportunity ID" and Save it.

      • Cyrille Saulnier

        Hi Dimple, this is great and life saving!

        Quick question: I get a pop up "Invoke Action" (attached screenshot). Can we remove it as it is not very user-friendly?

        Thanks for your help

        Cyrille

        • Priscila Terazawa

          Hi Cyrille,

          If you haven't found it yet, in the action link configuration, all you need to do is to select "Do not display in a popup if only one action link is available at runtime" in the column Properties > Interaction. See the screenshot

           

          • Cyrille Saulnier

            Hi - thanks Priscila

            The option is ticked indeed but I still get the Invoke Action pop up window...

            any idea?

            • Priscila Terazawa

              Hi Cyrille,

              Please try to set Primary Interaction as Action link from my screenshot.

              Make sure you save the changes before testing.

              See if that helps.

              Thanks,

              Priscila

              • Cyrille Saulnier

                Hi Priscilla

                As per my screenshot, the Primary Interaction is set as "Action Links" and it is all saved. I have tried both in Edit/Results and by opening the report.

                Thanks for your help