1. Configuring Applications
  2. Add Parameter Values in Embedded Reports

Add Parameter Values in Embedded Reports

Users can add any parameter values to the reports/dashboards embedded into Oracle Field Service. The reports / dashboards are refreshed based on these parameter values. To add parameter values in embedded reports, users can create corresponding filter in Oracle BI Cloud Service reports/dashboards.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

To add parameter values:

  1. Add resource tree parameters {pid} in the Oracle BI Cloud Service URL:
    1. p0 represents the no of parameters included in the URL
    2. p1 indicates the operators, for example eq.
    3. p2 stands for the column name in Oracle BI Cloud Service
    4. p3 indicates the value of the attribute to be passed.
  2. Create a filter in the Oracle BI Cloud Service report / dashboard with PID. Add resource tree parameters {pid} in the URL as follows:

    • https://businessintellt-identity-domain.analytics.oraclecloud.com/analytics/saw.dll?Go&Path;=%2Fcompany_shared%2FOFSCDEMO%2F_portal%2FOFSC%20Sample%20Dashboard& p0=1&p1;=eq&p2="provider"."pid"&p3;="{pid}"

      Note: For displaying the dashboard for both parent and leaf nodes, the URI requires two PID placeholders.

    • https://businessintellt-identity-domain.analytics.oraclecloud.com/analytics/saw.dll?Dashboard&PortalPath;=%2Fcompany_shared%2FOFSC-DEMO%2F_portal%2FOFSC%20DEMO%20Dashboard&Action;=Navigate&P0;=2&P1;=eq&P2;=PROVIDER.RESOURCE_ID&P3;={pid}&P4;=eq&P5;=PROVIDER.PARENT_RESOURCE_ID&P6;={pid}&options;=mdr

      • P1- Operation btw first parameter set, "eq" stands for equal to

      • P2- Column name in the format of table name column name, PROVIDER.RESOURCE_ID - for considering resource owned activity in reports

      • P3- Value , the placeholder {pid}

      • P4 - Operation between second parameter set

      • P5 - PROVIDER.PARENT_RESOURCE_ID - for aggregating child resources owned activities in reports

      • P6- Value, the placeholder {pid}

  3. Configure SSO in both Oracle Field Service and Oracle BI Cloud Service to avoid multiple login sessions.