Join with the Enterprise Cost Intelligence Dashboard

This section is optional and shows how you can add your AWS Organization Datas to your Enterprise Dashboards - 200_Enterprise_Dashboards .

This example will show you how to map your Enterprise Dashboard linked_account_id to your Organizations account_number to add account information that is meaningful to your organization. This is to replace this step: https://wellarchitectedlabs.com/cost/200_labs/200_enterprise_dashboards/2_modify_cost_intelligence/.

Go to the Amazon QuickSight service homepage
In QuickSight, select the summary_view Data Set
Select Edit data set
Select Add data:
Select your Amazon Athena organization_data table and click Select
Select the two circles to open the join configuration then select Left to change your join type:
Create following join clause :
- linked_account_id = account_number Click Apply

Images/dashboard_mapping_7.png

Scroll down in the field list, and confirm the Account ID must be Int:
Select Save
Repeat steps 2-9, creating mapping joins for your remaining QuickSight data sets:
- s3_view
- ec2_running_cost
- compute_savings_plan_eligible_spend

You now have new fields that can be used on the visuals in the Cost Intelligence Dashboard - we will now use them

Go to the Cost Intelligence Analysis
Edit the calculated field Account:
Change the formula from toString({linked_account_id}) to {account_name}
You can now select a visual, select the Account field, and you will see the account names in your visuals, instead of the Account number:

You now have successfully utilized Organization mapping data on your Cost Intelligence Dashboard