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 Oracle 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 Oracle Cloud Infrastructure (OCI).
   1. Log on to the OCI console.
   2. Click Analytics & AI > Oracle Analytics Cloud.
   3. Select Create Instance and then add the required information.
   4. Select 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, select 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 the OCI console, and then select Analytics Home Page.
8. Select Import Workbook/Flow and import both workbook files. Select Include all permissions if exists. Enter OraAnalytic@2025 as the password. For more information, see Import a Workbook File.
9. Update the data source connection details for the Analytics_Connection dataset.
   1. Go to the Data page in Oracle Analytics Cloud.
   2. Find the Analytics_Connection dataset and then select Inspect/Edit > Update database connection.
   3. Map the database views.
   4. Select 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 system owner and participant organization dashboards.
    1. In Oracle Analytics Cloud, select Console.
    2. Select Roles and Permissions, then select Application Roles.
    3. Select Create Application Role and create the SystemOwnerRole application role.
    4. Under Members, select Groups and then select Add Groups.
    5. Assign groups to the SystemOwnerRole 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 SystemOwnerRole 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.
       • SYSTEM_ADMINS
       • SYSTEM_AUDITORS
       • SYSTEM_CREATORS
       • SYSTEM_MANAGERS
       • SYSTEM_ISSUERS
       • SYSTEM_RETIRERS
    6. Create roles for the participant organizations: ParticipantOrg1Role, ParticipantOrg2Role, and so on.
    7. Assign groups to the participant organization 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 participant organization in the group name to match the corresponding organization role.
       • ORG1_ADMINS
       • ORG1_AUDITORS
       • ORG1_MANAGERS
       • ORG1_OFFICERS
    For more information, see Assign Application Roles to Groups.
11. Update the instance name parameters for the system owner and participant organization dashboards.
    1. Log in as an adminstrator and open the system owner dashboard.
    2. Select Edit.
    3. Under Parameters, right-click to edit the parameter for the system owner instance name.
    4. Enter the system owner instance name or the membership service provider (MSP) ID. For example, enter CB.
    5. Repeat the previous steps to update the system owner instance name in the participant organization dashboard.
12. Update the roles in the participant organization dashboard.
    1. Open the participant organization dashboard, and then select Edit Dashboard.
    2. Select the Data tab, and then select the System_Owner_Account_Trans_Mod-Participating_Org view.
    3. Select Join Diagram.
    4. Add roles and filters for each participant.
       1. Select the add button next to Role filters.
       2. Add a filter expression that includes a query. For example, add the following SQL query to the ParticipantOrg1Role role, which mentions Org1 and Org2 as participant organizations.

          FROM_ORG_ID = 'Org1' AND TO_ORG_ID = 'Org2'

          You must add roles and filter expressions sequentially, before proceeding to the next role.
       3. Repeat this process for the ParticipantOrg2Role, ParticipantOrg3Role roles, and so on.
13. Move the dashboards to shared folders in Oracle Analytics Cloud.
    1. Navigate to Catalog > My Folders.
    2. Create a folder named Shared in the Shared Folders directory.
    3. Move the dashboards from the My Folders directory to the Shared folder inside the Shared Folders directory.
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.