Configure Oracle Analytics Cloud
Complete the following steps to configure Oracle Analytics Cloud and use the dashboards and visualizations for the wholesale CBDC application.
- 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.
- 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.
- Create an instance of Oracle Analytics Cloud in OCI.
- Log on to the Oracle Cloud Infrastructure (OCI) console.
- Click Analytics & AI > Oracle Analytics Cloud.
- Click Create Instance and then add the required information.
- Click Create and then wait for the instance creation to complete.
- 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. - Extract the
WholesaleCBDCAnalyticsPackage.zip
file, which contains theWholesaleCBDCAnalyticsPackage
directory. The workbook (.dva
) files are in theWholesaleCBDCAnalyticsPackage
directory - Back up both workbook files,
CBDC FI Dashboard.dva
andCBDC Central Bank Dashboard.dva
. - Navigate to Oracle Analytics Cloud in OCI console, and then click Analytics Home Page.
- Click Import Workbook/Flow and import both workbook files. Enter OraAnalytic@2025 as the password. For more information, see Import a Workbook File.
- Update the data source connection details for the
WCBDC_Connection
dataset.- Go to the Data page in Oracle Analytics Cloud.
- Find the
WCBDC_Connection
dataset and then click Inspect/Edit > Update database connection. - Map the database views.
- Click Save.
- Set up roles and permissions for the central bank and financial institution dashboards.
- In Oracle Analytics Cloud, click Console.
- Click Roles and Permissions, then click Application Roles.
- Click Create Application Role and create the CBRole application role.
- Under Members, click Groups and then click Add Groups.
- Assign groups to the
CBRole
and theBI Dataload Author
roles. TheBI 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 theBI Dataload Author
role. If the theCBRole
and theBI 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
- Create roles for the financial institutions: FI1Role, FI2Role, and so on.
- 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
- Update the instance name parameters for the central bank and financial institution dashboards.
- Log in as an adminstrator and open the central bank dashboard.
- Click Edit.
- Under Parameters, right-click to edit the parameter for the central bank instance name.
- Enter the central bank instance name or the membership service provider (MSP) ID. For example, enter CB.
- Repeat the previous steps to update the central bank instance name in the financial institution dashboard.
- Update the roles in the financial institution dashboard.
- Open the CBDC FI dashboard.
- On Analytic View Dashboard, click Edit.
- Click the Data tab.
- Double-click the CB_ACCOUNT_TRANS_MOD-FI view.
- 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.
- On the dashboard, click Join Diagram.
- Click the plus sign (+) to add a role.
- 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'
- Click Console > Roles and Permissions.
- Under Application Roles, add roles, assign user groups to roles, and verify existing roles as needed.
- Save your changes.
- Move the dashboards to shared folders in Oracle Analytics Cloud.
- Navigate to Catalog > My Folders.
- Move the dashboards from My Folders to Shared Folders.
- Test thoroughly to ensure that all visualizations, data connections, user access, and other functions are working as expected.
- To embed the analytics dashboards in the sample Oracle Visual Builder application, complete the following steps.
- Register the application as a safe domain in Oracle Analytics Cloud. See Register Safe Domains.
- Embed the analytics URL in the iFrame in the application. See Use iFrame to Embed Analytics Content into an Application or Web Page.