7.1. Setup Data Source & Cognos Embedded Dashboard
Lab Steps:
Step 1: Connect to Data Source
In the Cloud Pak for Data Homepage, click All projects under Projects to visit Project page.
Click New Project + and then click Next
Choose
Create an empty project
Enter the name to project and then click Create
Once project is created then click ‘New assets’ and then select Connection to create connection with external data source.
Select PostgreSQL from available connectors and provide connection details provided for Amazon Aurora PostgreSQL database credentials provided as part of Lab - 0.
Step 2: Create a new Cognos Embedded Dashboard
Before you get started, download the lab1-dashboard.zip dashboard file and extract the zip file.
Go back to the Cognos_Dashboard project created in previous step and then click ‘Add to project’ and then select asset type as Dashboard.
Select create a new dashboard from Local file, upload cognos-dashboard.json, provide a name to dashboard and click Create.
Step 3: Relink Data Assets to the Dashboard
Once the dashboard is created, you will see a message saying Missing data asset (1/5).
To relink the ts_regional_risk_index_table, follow below steps.
Similarly follow the same steps to relink : ts_wallonia_region_table ts_flanders_region_table ts_brussels_region_table flanders_cases_prediction_table
Dashboard
Once all the assets are relinked, you will see the dashboard view as shown.
