Configure Oracle Analytics Cloud

Complete the following steps to configure Oracle Analytics Cloud and use the dashboards and visualizations for the wholesale CBDC application.

  1. Create an instance of Oracle Autonomous Database. For information on how to provision Oracle Autonomous Database for the wholesale CBDC sample, see Provision Autonomous Database.
  2. Set up the database view definitions. For information on how to set up the database view definitions for the wholesale CBDC sample, see Oracle Database View Definitions for Wholesale CBDC.
  3. Create an instance of Oracle Analytics Cloud in OCI.
    1. Log on to the Oracle Cloud Infrastructure (OCI) console.
    2. Click Analytics & AI > Oracle Analytics Cloud.
    3. Click Create Instance and then add the required information.
    4. Click Create and then wait for the instance creation to complete.
    For more information about Oracle Analytics Cloud, see Oracle Analytics Cloud.
  4. Under Sample wCBDC Web Application and Analytics Workbook on the Digital Assets page in Oracle Blockchain Platform Digital Assets Edition, click Download sample VBCS UI and sample Analytics package. The WholesaleCBDCAnalyticsPackage.zip file, which contains the sample application, is downloaded to your computer.
  5. Extract the WholesaleCBDCAnalyticsPackage.zip file, which contains the WholesaleCBDCAnalyticsPackage directory. The workbook (.dva) files are in the WholesaleCBDCAnalyticsPackage directory
  6. Back up both workbook files, CBDC FI Dashboard.dva and CBDC Central Bank Dashboard.dva.
  7. Navigate to Oracle Analytics Cloud in OCI console, and then click Analytics Home Page.
  8. Click Import Workbook/Flow and import both workbook files. Enter OraAnalytic@2025 as the password. For more information, see Import a Workbook File.
  9. Update the data source connection details for the WCBDC_Connection dataset.
    1. Go to the Data page in Oracle Analytics Cloud.
    2. Find the WCBDC_Connection dataset and then click Inspect/Edit > Update database connection.
    3. Map the database views.
    4. Click Save.
    For more information about connecting Oracle Autonomous Transaction Processing to Oracle Analytics Cloud, see Connect to Oracle Autonomous Transaction Processing.
  10. Set up roles and permissions for the central bank and financial institution dashboards.
    1. In Oracle Analytics Cloud, click Console.
    2. Click Roles and Permissions, then click Application Roles.
    3. Click Create Application Role and create the CBRole application role.
    4. Under Members, click Groups and then click Add Groups.
    5. Assign groups to the CBRole and the BI Dataload Author roles. The BI Dataload Author role is required for embedding Oracle Analytics Cloud data into Oracle Visual Builder. The Oracle Identity Cloud Service (IDCS) groups that are associated with the sample application must be mapped to the BI Dataload Author role. If the the CBRole and the BI Dataload Author roles are not mapped, the analytics data will not be shown in the sample application, even if Oracle Analytics Cloud is integrated with Oracle Visual Builder. Map all relevant IDCS groups from the sample application to these roles. For example, map the following groups.
      • CB_CBDC_ADMINS
      • CB_CBDC_AUDITORS
      • CB_CBDC_CREATORS
      • CB_CBDC_MANAGERS
    6. Create roles for the financial institutions: FI1Role, FI2Role, and so on.
    7. Assign groups to the financial institution roles and to the BI Dataload Author role. You can create groups with any names, such as the following example groups. In the following example groups, change the number of the financial institution in the group name to match the corresponding financial institution role.
      • FI1_CBDC_ADMINS
      • FI1_CBDC_AUDITORS
      • FI1_CBDC_MANAGERS
      • FI1_CBDC_OFFICERS
    For more information, see Assign Application Roles to Groups.
  11. Update the instance name parameters for the central bank and financial institution dashboards.
    1. Log in as an adminstrator and open the central bank dashboard.
    2. Click Edit.
    3. Under Parameters, right-click to edit the parameter for the central bank instance name.
    4. Enter the central bank instance name or the membership service provider (MSP) ID. For example, enter CB.
    5. Repeat the previous steps to update the central bank instance name in the financial institution dashboard.
  12. Update the roles in the financial institution dashboard.
    1. Open the CBDC FI dashboard.
    2. On Analytic View Dashboard, click Edit.
    3. Click the Data tab.
    4. Double-click the CB_ACCOUNT_TRANS_MOD-FI view.
    5. Add roles for the participant and create a filter for each role. The roles that you add must also be present in the Roles and Permissions section of the dashboard. To add roles to filters, complete the following steps.
      1. On the dashboard, click Join Diagram.
      2. Click the plus sign (+) to add a role.
      3. Create a filter, and then add an Expression Filter that includes a query. For example, add the following SQL query, which mentions the FI1 and FI2 participant organizations.
        FROM_ORG_ID = 'FI1' AND TO_ORG_ID = 'FI2'
    6. Click Console > Roles and Permissions.
    7. Under Application Roles, add roles, assign user groups to roles, and verify existing roles as needed.
    8. Save your changes.
  13. Move the dashboards to shared folders in Oracle Analytics Cloud.
    1. Navigate to Catalog > My Folders.
    2. Move the dashboards from My Folders to Shared Folders.
  14. Test thoroughly to ensure that all visualizations, data connections, user access, and other functions are working as expected.
  15. To embed the analytics dashboards in the sample Oracle Visual Builder application, complete the following steps.
    1. Register the application as a safe domain in Oracle Analytics Cloud. See Register Safe Domains.
    2. Embed the analytics URL in the iFrame in the application. See Use iFrame to Embed Analytics Content into an Application or Web Page.